Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
07/25/2023 06:35 AM
Hello All,
What is the query to get all the REST type of connections and also need to update below config in ConfigJSON with below syntax for all the REST type of connections using custom query. Please help me with the syntax. @rushikeshvartak @naveenss
Solved! Go to Solution.
07/25/2023 06:47 AM - edited 07/25/2023 06:51 AM
Hi @harishyara
please try with the below select statement.
select * from externalconnattvalue where connectiontype in (select EXTERNALCONNECTIONKEY from externalconnection where EXTERNALCONNECTIONTYPE in (select EXTERNALCONNECTIONTYPEKEY from externalconnectiontype where connectiontype like '%REST%')) and attributekey='ConfigJson'
07/25/2023 06:50 AM - edited 07/25/2023 06:53 AM
Hi @harishyara ,
Use below query to get all the connection of type REST present.
select EXTERNALCONNECTIONTYPE, CONNECTIONNAME from externalconnection where EXTERNALCONNECTIONTYPE =30
Make sure to execute this query through analytics and not in data analyzer as this table is not exposed in Data Analyzer.
08/18/2023 09:23 AM - edited 08/18/2023 09:24 AM
Hi @pmahalle Where should i find all columns which belongs "externalconnection" table and "jobs" related tables inside saviynt. is thr anyother way apart from data analyzer.
07/25/2023 07:00 AM
@harishyara below is the sample update statement as well. let me know if this helps!
UPDATE externalconnattvalue ex,
externalconnection ext,
externalconnectiontype et
SET
ex.attributevalue = '{\"connectionTimeoutConfig\": {\"timeout\": 300,\"retryWait\": 500}}'
WHERE
ex.connectiontype=ext.externalconnectionkey
AND ext.externalconnectiontype = et.externalconnectiontypekey
AND et.connectiontype = 'REST'
AND ex.attributekey = 'ConfigJson';
07/25/2023 08:17 AM