Query to fetch Connection Attributes

[CRashmitha]

Hi Team,

Can someone help me the query to fecth the connection jsons. I mean to say is we have a requirement to fetch the jsons which are present in the connection.

Regards,

Rashmitha

[nimitdave]

The related tables are not exposed in the data analyzer.

But you can use the transport --> export feature to do so.

[Enakshi]

Run the below query from analytics to fetch the required data -

select extcon.CONNECTIONNAME, extconattval.ATTRIBUTEKEY, extconattval.ATTRIBUTEVALUE
from externalconnection extcon, externalconnattvalue extconattval
where extcon.EXTERNALCONNECTIONKEY = extconattval.CONNECTIONTYPE

[sk]

Yeah you can either use export feature to capture the JSONs or you can run below query using analytics

select ec.connectionname, ecv.ATTRIBUTEKEY, ecv.ATTRIBUTEVALUE from externalconnection ec inner join externalconnattvalue ecv on ec.externalconnectionkey=ecv.CONNECTIONTYPE