Error in Salesforce Connector with ExecuteCustomQuery action

Google Cloud Integration Services
1

Hello everyone!

I am trying to create a dynamic query in a Salesforce connector that I have set up in an integration, where the offset and limit values are set via a query parameter. When I run the test, I get the following error (it seems the query parameters are not being saved correctly). How can I ensure that the placeholders are replaced by the corresponding value?

Set query
Set query1400×736 43 KB

Set variable
Set variable1397×793 55.6 KB

Execution error
Execution error1285×686 75 KB

Thank you!

2

Hi miguelgracia
We tried to replicate the same scenario at our end and it was reproducible. When we debugged further on this we found out setting the offset value in the query parameter is not supported in GCP and it is supported only for queries in the where clause.