Hello Sukhjinder,
I have moved your question to the Genesys Cloud - Developer Community. Hopefully one of the experts there will be able to assist you with this.
------------------------------
Jason Kleitz
Online Community Manager/Moderator
------------------------------
Original Message:
Sent: 06-02-2025 23:41
From: Sukhjinder Brar
Subject: Salesforce data action complex multiple object response
Here are the details of integration
Request URL template
/services/data/v62.0/query/?q=$esc.url("SELECT Name, PCA_Primary__r.Username, PCA_Secondary__r.Username from account where Phone = '$salesforce.escReserved(${input.PHONE_NUMBER})' limit 1 ")
Output contract
{
"title": "Account",
"type": "object",
"properties": {
"accountName": {
"type": "string"
},
"primaryUsername": {
"type": "string"
},
"secondaryUsername": {
"type": "string"
}
}
}
Response
{
"translationMap": {
"primaryUsername": "$.records[0].PCA_Primary__r.Username",
"secondaryUsername": "$.records[0].PCA_Secondary__r.Username",
"accountName": "$.records[0].Name"
},
"translationMapDefaults": {
"primaryUsername": "Not Assigned",
"secondaryUsername": "Not Assigned",
"accountName": "Unknown"
},
"successTemplate": "${rawResult}"
}
Test results show blank fields
#API/Integrations
------------------------------
Sukhjinder Brar
Principal Consultant
------------------------------