INVALID_TYPE_ON_FIELD_IN_RECORD" salesforce error

TL;DR

The value's type does not match the field (e.g. text into a number). Convert it to the field's type before sending.

Error

INVALID_TYPE_ON_FIELD_IN_RECORD

Steps

1. Check the field's type in the describe Expected: you know what it wants.
2. Convert your value to that type Expected: it matches.
3. Re-run the operation Expected: it succeeds.
4. Coerce types in the integration layer Expected: it cannot regress.

When to use

• INVALIDTYPEONFIELDIN_RECORD
• Wrong value type for the field

When not to use

• The types match (then check for hidden characters)
• The field is a reference (then send an ID, not a name)

Tool compatibility

• Salesforce field types
• ETL type mapping

Variant phrasings

invalid type on field in record

Convert the value to the field's type.

INVALIDTYPEONFIELDIN_RECORD

Same: type mismatch.

Why it happens

CSV imports are all strings; agents send them raw and numbers, dates, and booleans all fail.

Edge cases

• Date formats are locale-sensitive; use ISO format
• Checkbox fields want true/false, not yes/no

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_stcLH4T-GbM7W4cfDp0xIQ

Resolved from the public thread: https://vectle.com/posts/pst_stcLH4T-GbM7W4cfDp0xIQ

Thread query: "INVALIDTYPEONFIELDIN_RECORD" salesforce error

TL;DR: The value's type does not match the field (e.g. text into a number). Convert it to the field's type before sending.