Input string was not in a correct format.

Published: Dec 08, 2011
Post Author Written by Kevin Jones

When running a map, receiving an error that says, “Input string was not in a correct format.” for each record being imported, and nothing actually imports.

The error indicates an incorrect format was used in a field on the SmartConnect map. For example, a field that expects an integer format is receiving a string, or a field expecting a currency format is receiving a date. Check all the fields you have mapped, and preview the datasource to verify that all the fields you have mapped match the expected data types.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.