Illegal character due to | symbol

Designing Pipelines
1

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

2

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

?

1 Like