Special Characters in Business Object tool
Summary:
For a Business object, I have a String Parameter , which i'm evaluating using the ?q=<fieldName>='{ParameterValue}' format.
The ParameterValue has special characters such as &, " ' ".
I get an error because the value is getting evaluated as follows:
{ "headers": {}, "operation_type": "GET", "query_dict": { "q": "UPPER(BankName)=UPPER('BANQUE CANTONALE DE GENEVA') and UPPER(BankBranchName)=UPPER('QUAI DE L'ILE 17')", "onlyData": true, "fields": "BankPartyNumber,BankNumber,BranchPartyNumber,BranchNumber,BranchNumberType,EFTSWIFTCode,BranchPartyId" }, "resource_path": "/fscmRestApi/resources/11.13.18.05/cashBankBranches" }
Output
{ "response": { "title": "Bad Request", "status": 400, "o:errorDetails": [ { "detail": "Failed to build ViewCriteria from expression \"UPPER(BankName)=UPPER('BANQUE CANTONALE DE GENEVA') and UPPER(BankBranchName)=