Jitterbit · Transformations with connector JSON schemas

expected String to be a Array

Short answer

This Jitterbit error appears when special characters in connector-provided JSON schema names are replaced by underscores, so the endpoint receives names it does not expect. Confirm the affected activity uses a JSON schema with a root node named json.

VerifiedLast verified

01Error text

Jitterbit error
{location_ids:expected String to be a Array}

02Likely causes

  • Special characters in schema field or node names are replaced by underscores. For example, location_ids[] becomes location_ids__.
  • Under legacy JSON processing, the default for projects created before the 11.48 Harmony release, the endpoint then receives names that no longer match what it expects.

03How to fix it

  1. Confirm the affected activity uses a JSON schema with a root node named json.
  2. Enable the Preserve JSON names project setting, which requires agent 11.48 or later.
  3. Reconfigure, deploy and run the operation.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.