We have been using the GET_MERCHANT_LISTINGS_DATA report to get updates on the active Amazon listings. The report is supposed to come back as a CSV file with the columns separated by tabs.
Recently the reports have started coming back with newline characters in the description column. This breaks the processing of the file as a CSV file.
Is there a way to either have the report behave as it did in the past and have the description column show newlines as a character representation that does not break CSV or to have the data in all columns contained in some kind of delimiter to be able to treat the column as a single column even if it has newline characters in it.
Thanks
Unfortunately Amazon doesn’t encapsulate columns with " which is the standard when sending a column that may have the delimiter character in CSV that would be a ‘,’. If the description doesn’t have a tab you could just replace all tabs with ‘","’ (comma in between quotation marks) and add quotation marks to the beginning and end of the line as a makeshift fix.