How to get ConnectALL automation field mapping from database?

Products

• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

I have automation with Insights that I cannot view because the Insights 1.0 adapter is retired in ConnectALL 4.
Can I get the automation field mapping from database?

Environment

4.x

Resolution

Yes, you can use below query to get the automation details. You can format the output in JSON to get the field mapping details.

SELECT al.application_link_name, alv.automation
FROM application_link al, application_link_version alv 
WHERE al.application_link_id = alv.application_link_id
AND al.application_link_name in ('ALM2JiraCloudUserSyncTest', 'ADO2JiraFeatures')
AND alv.is_current = 1;