Query from salesforce in uipath

Question

I am using Connector.Salesforce.Activities in uipath to fetch records.

I am trying to run the following query:

"SELECT id, Name, BillingStreet FROM Account where Name='” + varAccountName+"'"

In the above query, the account name is stored in the varAccountName variable.

After executing the query in the Execute SOQL SANDBOX activity, no result is returned. Also, no exception is thrown.

Do you get any records if you leave the WHERE condition out of it? — Marek Stejskal
Yes. If I remove where condition, then all account records are fetched. — Ajinkya
Then something is wrong with your where condition. Try to hardcode it and see what happens. — Marek Stejskal
Event after hardcoding the value in where condition, no records are fetched. — Ajinkya

Santosh Kumar Santosh Kumar · Accepted Answer · 2018-12-07T11:08:25

The dynamic passing of name is not possible through this connector. You have to look for other options