Filter query in Get Records fails if criteria contains a '

(0) Share

Report

Posted on by beatrizfuster

I use the Get Records against Sales Force and I use the filter query to detect a row containing certain criteria.

It normally works but it fails if the criteria contains a '

If value is "Cote D'Ivori" then the filter Query fails:

{

"status": 400,

"message": "There is an unterminated literal at position 34 in 'GEOLeve4Name__c eq 'Cote D'Ivoire''.\r\n inner exception: There is an unterminated literal at position 34 in 'GEOLeve4Name__c eq 'Cote D'Ivoire''.\r\nclientRequestId: 02b0bb1c-4cbc-426c-824f-2d7dc975cf85",

"error": {

"source": "salesforce-ne.azconn-ne.p.azurewebsites.net"

}

Any clue on how to fix that?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @beatrizfuster

Most likley the issue is related to single quotes after D.

'Cote D'Ivoire'

I have replied another post similar to this issue but not specific to Salesforce. Please have a look and let me know.

https://powerusers.microsoft.com/t5/Using-Flows/Unable-to-get-user-Send-an-HTTP-request-to-SharePoint-when-email/m-p/610265#M15676

Thanks

Was this reply helpful? Yes No
beatrizfuster 24 on at

Like (0)

Report

Thanks. Your answer help me to find the fix:

replace(items('Apply_to_each')?['Department']?['Value'],'''','''''')

Thanks!

Was this reply helpful? Yes No
Rohit Sharma354 on at

Like (0)

Report

Hello,

Yes, the solution provided by @abm should work in your scenario as well.

Was this reply helpful? Yes No