n8n - 💡(How to fix) Fix Numeric string values without leading zero are sent without quotes in SOQL

Official PRs (…)
ON THIS PAGE

Recommended Tools

×6

Utilities matched from this issue’s tags and category — try them while you read without losing context.

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…

Error Message

Salesforce error: "must be of type string and

Fix Action

Fix / Workaround

Workaround: leading zero values (e.g. 039381512) work correctly, pure numeric values without leading zero fail with Salesforce error: "must be of type string and should be enclosed in quotes"

RAW_BUFFERClick to expand / collapse

Bug Description

Node: Salesforce - Get Many Bug: Numeric string values without leading zero are sent without quotes in SOQL

SOQL generated: WHERE IdNumber__c = 307795203 ← WRONG Expected: WHERE IdNumber__c = '307795203' ← CORRECT

Workaround: leading zero values (e.g. 039381512) work correctly, pure numeric values without leading zero fail with Salesforce error: "must be of type string and should be enclosed in quotes"

To Reproduce

<img width="410" height="318" alt="Image" src="https://github.com/user-attachments/assets/ef87ac58-c986-4b33-9af5-1e3c836a8056" /> <img width="1385" height="794" alt="Image" src="https://github.com/user-attachments/assets/86bfd3c2-78cb-4a79-b200-bceff66882d2" />

Expected behavior

it must find contact by national id

Debug Info

sales force problematic NODE

Operating System

ubuntu 24

n8n Version

Version 2.20.11

Node.js Version

v24.13.1

Database

PostgreSQL

Execution mode

main (default)

Hosting

self hosted

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…

FAQ

Expected behavior

it must find contact by national id

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING

n8n - 💡(How to fix) Fix Numeric string values without leading zero are sent without quotes in SOQL