SC Excel Template “The Request Body Could Not Be Deserialized”
"Map run failed. The request body could not be deserialized. Please check the formatting of your request body."
It appears that what is being sent as XML isn't formatted correctly. Can you please send the export of the map in SmartConnect and also the Excel file you have formatted. The problem area may be in the hidden Sheet2 pulling the wrong values after you reformatted the main sheet.
I was able to get it working after realizing that the Excel 'form' created by the template had all cells set to 'General'
When entering the phone numbers into the form it converted them to scientific notation on Sheet2. Once I changed the formatting in the 'form' for the phone numbers it imported without issue.
If you would like to submit an answer or comment, please sign in to the eOne portal.