'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 |
|---|
