AMC data upload file format requirements

CSV file requirements

CSV files must be UTF-8 encoded and comma delimited. In Microsoft excel, save the file as CSV UTF- 8 (comma-delimited) format. When CSV files are uploaded, AMC will automatically convert data to the corresponding column type. For example, if 12423.56 is contained in the CSV file and is mapped to a DECIMAL type column, AMC will coerce the string value contained in the CSV file to the appropriate column type.

JSON file requirements

JSON files must contain one object per row of data. Do not use JSON arrays. Following is an example of the accepted JSON format:

{"name": "Product A", "sku": 11352987, "quantity": 2, "pur_time": "2021-06-23T19:53:58Z"}
{"name": "Product B", "sku": 18467234, "quantity": 2, "pur_time": "2021-06-24T19:53:58Z"}
{"name": "Product C", "sku": 27264393, "quantity": 2, "pur_time": "2021-06-25T19:53:58Z"}
{"name": "Product A", "sku": 48572094, "quantity": 2, "pur_time": "2021-06-25T19:53:58Z"}
{"name": "Product B", "sku": 18278476, "quantity": 1, "pur_time": "2021-06-26T13:33:58Z"}