JSON Error: Input string was not in a correct format

Error Details:

There was a failure executing the send pipeline <Pipeline Name> Source: “JSON encoder” Send Port: <Send Port Name> URI: <URI> Reason: Input string was not in a correct format.


Most of the time when we generate schemas with XML or JSON or csv files with specified wizard (JSON Schema wizard, Flat File Schema Wizard, or Generate Schemas). While creating elements in schema, there are some elements datatypes are defined as unasignBite or unasignInt etc..

Most of the time we find these datatypes while creating schemas for numeric data. It defines as unasignInt or unasignByte etc. while creating of Schema from Wizard.

So, when we applied JSON Encoder to convert XML to JSON, this throws exception that Input string was not in a correct format. 


So, After creating Schemas, verify Schemas elements’ data types and update to valid data type e.g. string, integer which are accepted for the JSON format. This will resolve the problem.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s