Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
3 years ago

Illegal character due to | symbol

Hi Team,

We are facing issues in the salesforce upsert snap while using External Id for the operation. The external Id is of the format “TH10-2023|0100044213|000086|3010”
So the snap interprets the ‘|’ as logical AND and throws the error. Is there any way to prevent the issue? Shall we consider it as a whole string instead?

Thanks,
Harshavardhana

1 Reply

  • ljupcho_machko1's avatar
    ljupcho_machko1
    New Contributor III

    Hi @Harsha3 ,
    Can you please try to escape pipe character by adding before it escape character . So for External ID try with this:

    ?