Troubleshooting: Unexpected API Error

XLANS | Know the reason and workaround when you are getting Unexpected API error

Updated over a week ago

Error

Unexpected API Error


Reason for Error

This is happening because of the special character in the field name. CloudExtend writes formulae to the first row in Excel. If special characters exist in the column name, it breaks the formula.

In the example below, the field name of the custom field is Est. GP% which contains the percentage sign. This special character is disturbing the formula causing the issue.


Workaround

Enter a custom label without any special characters.

πŸ‘‰ See other common errors encountered when downloading Saved Searches from NetSuite.

Did this answer your question?