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
{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[]becomeslocation_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
- Confirm the affected activity uses a JSON schema with a root node named
json. - Enable the Preserve JSON names project setting, which requires agent 11.48 or later.
- Reconfigure, deploy and run the operation.
04Official documentation
→Related errors
- Failed to convert XML file to JSONThis Jitterbit transformation error means XML embedded in JSON contains a CDATA section, which is not supported. In a Jitterbit script, use Replace to swap the special characters inside the CDATA section, including the CDATA delimiters, for their escaped equivalents.
- String value length exceeds the maximum allowedThis Jitterbit transformation error means a single JSON string value exceeded the agent JSON parser limit of 20 MB. On a private agent running version 12.5 or later, set MaxStringLength in the [JsonParser] section of jitterbit.conf, for example 50000000 for 50 MB.
- The node cannot be createdThis Jitterbit error means an imported transformation mapping with duplicate nodes is out of sync with the schema definition used at runtime. In the affected transformation, use Remove all mappings beneath this node on the root node.
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