'amazon sp api empty document report generated

I am using node.js to create an inventory report. The problem is that I am getting an empty document report. I have 900 listings. This is the code to create the report:

let reportid = await sellingPartner.callAPI({
        operation:'createReport',
        endpoint: 'reports',
          body:{
            sellerId:'XXX',
            marketplaceIds:['A1PA6795UKMFR9'],
            reportType: 'GET_FLAT_FILE_OPEN_LISTINGS_DATA',
            period: 'PT1H'
          },
          options:{
            version:'2021-06-30'
          }          
      });
      console.log(reportid.reportId)
      return reportid;

This is the output of create report:

{ reportId: 'XXX' }

This is the code to retrieve the report:

 let report = await sellingPartner.callAPI({
    operation:'getReport',
    endpoint: 'reports',
      path:{
        reportId: XXX //reportid.reportId
      },
      options:{
        version:'2021-06-30'
      }          
  });
  console.log(report)
  let doc = await sellingPartner.callAPI({
    operation:'getReportDocument',
    endpoint: 'reports',
      path:{
        //sellerId:'A3EWV26DRDLUH4',
        reportDocumentId: report.reportDocumentId
      },
      options:{
        version:'2021-06-30'
      }          
  });
  return doc;

This is the ouput of the report:

{
  reportType: 'GET_FLAT_FILE_OPEN_LISTINGS_DATA',
  processingEndTime: '2022-03-11T17:33:25+00:00',
  processingStatus: 'DONE',
  marketplaceIds: [ 'A1PA6795UKMFR9' ],
  reportDocumentId: 'XXX',
  reportId: 'XXX',
  dataEndTime: '2022-03-11T17:32:56+00:00',
  createdTime: '2022-03-11T17:32:56+00:00',
  processingStartTime: '2022-03-11T17:33:16+00:00',
  dataStartTime: '2022-03-11T17:32:56+00:00'
}

This is the output of the document:

{
  reportDocumentId: 'XXX',
  url: 'https://tortuga-prod-eu.s3-eu-west-1.amazonaws.com/%2FNinetyDays/XXX?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20220314T094140Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=XXX&X-Amz-Signature=XXX'
}

At the specified url I am getting only the document columns:

sku asin price quantity Business Price Quantity Price Type Quantity Lower Bound 1 Quantity Price 1 Quantity Lower Bound 2 Quantity Price 2 Quantity Lower Bound 3 Quantity Price 3 Quantity Lower Bound 4 Quantity Price 4 Quantity Lower Bound 5 Quantity Price 5 Progressive Price Type Progressive Lower Bound 1 Progressive Price 1 Progressive Lower Bound 2 Progressive Price 2 Progressive Lower Bound 3 Progressive Price 3 Minimum order quantity Sell remainder


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source