I am exporting order data from Amazon SP-API and Importing it to Snowflake. When I try to import the data into Snowflake I get an error stating that the numeric value 'Order' is not recognized. I don't understand why Snowflake thinks this value should be numeric, In Celigo I have tried mapping this key with and without manually setting the datatype to String.
Any help would be greatly appreciated.
Basic Configuration Details
I am using the "Hybrid" connection to Amazon
I am using "SP-API" api type
My export type is "Test - export only 1 record"
My parsed output looks like this (the orders list contains 100 order objects):
When I try to import the records into snowflake I get this error:
Numeric value 'Other' is not recognized
Error ID: 484384545
Classification : Value
My retry data shows that the only key that has a value of "Other" is "PaymentMethod". I have confirmed that If I remove payment method from the import mapping, this error goes away.
If I edit any of the retry data (not the PaymentMethod), and retry then the error also goes away for this one record.
Since this is a test export, only one page of data is returned, and the "Orders" array only contains 100 orders.
All 100 orders have the same key value pair of:
So, I don't think this error is caused by having one of the records incorrectly sending an integer value.
One to Many Configuration
In my import I break out the nested orders using the one to many option:
PaymentMethod field Configuration
I have tried this integration with and without the Data type being explicitly set to String.
In snowflake the definition for the "paymentmethod" column is:
CREATE TABLE ...(
Please sign in to leave a comment.