CRM update failed: the CRM rejected the value

Updated

Applies to: Super Admins, Creators and Integrators, with Salesforce or HubSpot connected

A CRM update failed because of a value it tried to save. In the project's Logs, the Update Salesforce Field or Update Hubspot Field row has an X in Success. The message in Error describes the problem with the value. Payload shows the values OnRamp sent, if it sent any.

Why it happens

Either your CRM rejected the value, or OnRamp stopped the update before sending it because a value was too long.

When your CRM rejects a value, Error shows the CRM's own error text if the CRM sends one. Otherwise, depending on the connection, it shows the raw response from the integration, or CRM update failed on followed by the object and record ID. A value the CRM rejects for being too long can show exceeds the field maximum of.

Before it sends anything, OnRamp checks length itself. It shortens plain text that's too long for the field, and the update goes ahead. When that happens, the row's Payload lists the shortened fields under truncated_fields, with each value's original length and the field's maximum.

OnRamp doesn't shorten a value when a shortened one would be wrong. It stops instead for:

  • IDs, project links and link data fields

  • A static value you set in the mapping

  • URL and multi-select fields in your CRM

  • Field types with no fixed length limit, such as email, phone and long text area

In these cases, Error includes accepts at most, and Payload shows only {}. The message names the field and the mapped value, and says what to do next.

Fix it

Find the reason that matches the message in Error:

What the message is about

What to change

accepts at most

Follow the message: map a shorter value, or make the field longer in your CRM. If you mapped the project link, map the project ID instead.

exceeds the field maximum of

Map a shorter value, or make the field longer in your CRM.

A picklist value the field doesn't allow

Follow Salesforce picklist options don't match in automation actions.

Any other message from your CRM

Change the value so it meets the field's rules in your CRM, or ask your CRM admin about the field.

  1. In Logs, select View in the Error column. Compare the message with the values in Payload.

  2. Select the automation in the list. It opens in Workflow.

  3. Select the Update Salesforce field or Update Hubspot field step.

  4. Under Map fields to update, make the change the table describes. If the change belongs in your CRM, make it there instead.

  5. Select Save. You'll see Save only if you can update the project's settings. Otherwise, the automation opens read-only.

  6. Repeat the event on the project. Then, in Logs, select Refresh to see the new row.

Still stuck?

Contact support with the project's name and link, the row's Timestamp, and the text from Error and Payload. Include the field's API name and type in your CRM.

More in Getting Unstuck Fast