Special Characters in Salesforce Module

How To
1

Hey everyone.

I’m having an issue with the Salesforce Module using SOQL and I’m hoping you might be able to help with. I have a SOQL that usually works:

SELECT FIELDS(ALL) FROM OpportunityLineItem WHERE OpportunityId = ‘OpportunityId’ AND Product_type__c = ‘New’ AND Product__c = ‘toString(Product__c)’

OpportunityId and Product_c are coming through correctly.

However, when the Product_c is ‘Example Product(‘Cash PB’)’ it returns an error unexpected token: ‘Cash’ so I’m assuming it doesn’t like the '. Do you know of a way with this API we can allow special characters?

Thank you

3

Hi @shauna ,

I think that your assumption " I’m assuming it doesn’t like the '" is true.
Maybe you could use ‘Example Product(\‘Cash PB\’)’ or “Example Product(‘Cash PB’)”.

Maybe it is a stupid question, why do you use a such product name?

BR,

PBI

2 Likes