The XML you submitted is ill-formed at the Amazon Envelope XML level at (or near) line 1, column 1.

[udtren]

I write a code that read the shipping confirmation template and create a flat file. After sending the data to amazon and get the feed result document, it says 'The XML you submitted is ill-formed at the Amazon Envelope XML level at (or near) line 1, column 1.' What is the problem of my code? My OS is Windows 10.

  def submit_feed(xls_file_path, sheetname, header):

    df = pd.read_excel(io=xls_file_path, sheet_name=sheetname, header=header)
  
    csv_buffer = StringIO(newline='')
    csv_writer = csv.writer(csv_buffer, delimiter='\t')
    csv_writer.writerow(['order-id', 'ship-date', 'carrier-code', 'carrier-name', 'tracking-number'])
  
  
    for index, row in df.iterrows():
  
        order_id = row['order-id']
        ship_date = row['ship-date']
        carrier_code = row['carrier-code']
        carrier_name = row['carrier-name']
        tracking_number = row['tracking-number']
  
        csv_writer.writerow([order_id, ship_date, carrier_code, carrier_name, tracking_number])
  
    responses = Feeds(marketplace=Marketplaces.JP,credentials=credentials).submit_feed(feed_type='POST_ORDER_FULFILLMENT_DATA', file=csv_buffer)

if __name__ == "__main__":

    amazon_file_path = sys.argv[1]
    submit_feed(amazon_file_path, '出荷通知', 2)

Here is the result document

<?xml version="1.0" encoding="UTF-8"?>
<AmazonEnvelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="amzn-envelope.xsd">
        <Header>
                <DocumentVersion>1.02</DocumentVersion>
                <MerchantIdentifier>************</MerchantIdentifier>
        </Header>
        <MessageType>ProcessingReport</MessageType>
        <Message>
                <MessageID>1</MessageID>
                <ProcessingReport>
                        <DocumentTransactionID>58008018789</DocumentTransactionID>
                        <StatusCode>Complete</StatusCode>
                        <ProcessingSummary>
                                <MessagesProcessed>0</MessagesProcessed>
                                <MessagesSuccessful>0</MessagesSuccessful>
                                <MessagesWithError>1</MessagesWithError>
                                <MessagesWithWarning>0</MessagesWithWarning>
                        </ProcessingSummary>
                        <Result>
                                <MessageID>9223372036854775807</MessageID>
                                <ResultCode>Error</ResultCode>
                                <ResultMessageCode>50001</ResultMessageCode>
                                <ResultDescription>The XML you submitted is ill-formed at the Amazon Envelope XML level at (or near) line 1, column 1.</ResultDescription>
                        </Result>
                </ProcessingReport>
        </Message>
</AmazonEnvelope>

[saleweaver]

What version are you using?

[udtren]

Version is python_amazon_sp_api-0.5.2.dist-info