Garrett_Jason | 2020-06-26 18:00:12 UTC | #1
I am trying to setup a Salesforce Data Action that will query against the Salesforce Task Object with a PureCloud Conversation ID(callobject) and return the SF Contact ID(WhoId) so we know who an agent was last looking at in SF. However every time we try to test this it comes back with 0 results. When we run the same query in SF itself it does return with data. Here is the Data Action query that we are using: /services/data/v37.0/query/?q=$esc.url("SELECT WhoId from Task where callobject = '${input.callobject}'")
Is there some special access, or formatting needed to query against the Salesforce Task object?
I also built another Salesforce Data Action that is querying against the Contact Object and it is returning data correctly. Here is the Contact query: /services/data/v37.0/query/?q=$esc.url("SELECT ContactSourceID_c from contact where (id = '${input.contactid}')")
Jason_Mathison | 2020-06-26 18:09:20 UTC | #2
There is a Salesforce specific escape macro that may solve your issue salesforce.escReserved
https://help.mypurecloud.com/articles/velocity-macros-data-actions/#SalesforceMacros
--Jason
system | 2020-07-27 18:09:21 UTC | #3
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 8128