Querying SF in Celigo

Integrator.io
, , ,
1

What is the proper way to query (for example an account) based on name when the name in SF could have an apostrophe (for example Joe's Pizza)? My issue is that I need to match to my payload based on name alone and sometimes the names may have an apostrophe and sometimes not. I'm confused on if I should be using {{}} or {{{}}}.

Example for Joe's Pizza:

SELECT 
   Id, 
   Name
FROM 
   Account
WHERE
   RecordTypeID = '012Hp000001357OIAQ'
AND 
   Name = '{{record.PlanInformation.Group}}'

Based on the above with double brackets is produces:

5301043caa20740200000001-3c9c5410d08c4947b4eed999b3f962d3.png
5301043caa20740200000001-3c9c5410d08c4947b4eed999b3f962d3.png307×180 8.4 KB

Should I be using triple brackets here? Will this work for names that don't have an apostrophe?

2

Hi @daveguderian , you can use {{{replace settings.export.Sname "'" "\'"}}} to escape the single quote character from soql. So the query in your case shoule be -

Select Id, Name FROM Account Name = '{{{replace record.PlanInformation.Group "'" "\'"}}}'

Thanks!