I want to fetch multiple records and have a list of ids(comma separated) as a parameter. How can I query using this from Salesforce to get data(like using IN operator)?
Try the In operator available on Salesforce Operation.
Pass the values from the parameters tab in CSV format like below.
Thanks Girish for the reply.
I think I overlooked the IN operator available in the connector operation.
I had passed the ids in comma separated value as static value as shown here and it works as expected.
But, how about if I want to pass the ids from multiple profile elements which are getting generated from another connector operation in a previous step.
1. create some dynamic document property ( say- test ) using message shape just before the salesforce connector.
2. concatenate the profile elements with comma in between as shown below.
3. pass DPP ( test ) as input to salesforce parameters tab.
let me know, if this solves your problem.
Retrieving data ...