Inconsistent Salesforce query error with number-like string

We are running version 1.101.1, self-hosted.

We receive a (number) uuid called “cuOrderId” from the initial trigger, convert it to a string in an intermediate step, and then use a Salesforce “Get many custom objects” node to retrieve the relevant record.

Sometimes the query works fine because n8n sends the variable to SFDC as a string. Sometimes we get a Bad request error, because n8n sends the variable as a number. As near as I can tell, it’s just a coin flip. The two executions screenshotted below took place ~20 minutes apart, with no changes to the workflow between them.

The number->string conversion in a previous node should be enough, ideally. But I have also tried {{ $json.cuOrderId.toString() }} in the SFDC note and that doesn’t fix it. Any ideas?


Hi Matt,

Were you able to find a workaround to this issue?