功能同需求
亚马逊数据报表中心对接发票的两个接口,并对外接两个接口
功能同需求
亚马逊数据报表中心对接发票的两个接口,并对外接两个接口
背景:现有亚马逊回款费用数据报告,缺少信用卡数据。
需求:对接信用卡账号数据;
数据来源:
地址:https://advertising.amazon.com/API/docs/en-us/invoices/#/invoice/getAdvertiserInvoices
对接结构(主键):
商户号,店铺ID ,添加时间,更新时间,页码,发票号,类型,国家,币种,金额 ( 详细参考下面内容 );
Token 10264 提供來源渠道token获取接口给数据报表组使用 ( 关联需求,非验证内容 )
需求交付:
数据中心下载,并提供 2 个 接口
接口 1 GET/invoices Get invoices for advertiser
接口 2 GET/invoices/{invoiceId} Get invoice data by invoice ID
测试验证需求:以下主要接口字段实现数据中心页面交付可用即可。
接口1 详情 需求:
Requires (INPUT) :
CustomerID 'int'
MerchantID 'string'
count 'integer'
cursor 'string'
}
netxcursor ‘String’
PreviousCursor 'String'
Invoice Fees {
cost 'String'
currencyCode 'String'
Fees Type 'String'
PaymentMethod: 'String'
id:‘String’
DowloadableDocuments: ‘String’
Status: 'String'
toDate 'String'
dueDate 'String'
invoiceDate 'String'
}
| cost* |
Currency Amount currencyCode |
| feeType* | string |
| paymentMethod* | paymentMethod |
| status* | Invoice Statusstring |
| id* | string title: Invoice Id |
| toDate* | datestring
Date in YYYYMMDD format |
| dueDate* | datestring
Date in YYYYMMDD format |
| invoiceDate* | datestring
Date in YYYYMMDD format |
接口2 详情 需求:
接口 2 GET/invoices/{invoiceId} Get invoice data by invoice ID
Requires (INPUT) :
CustomerID 'int'
MerchantID 'string'
invoiceId 'string'
}
Invoice Summary Fees
{
"cost" "string"
"currencyCode": "string"
"feeType": "string"
"invoiceDate": "string"
payments:
{
"paymentMethod": "CREDIT_CARD", 'String'
"id": 0, '‘String’
"refundedAmount": ‘String’
"status" : 'String'
}
governmentInvoiceInformation
{
"transactionType": "DEBIT"
}

Postman 案例:
curl --location --request GET 'https://advertising-api.amazon.com/invoices?cursor=eyJpbnZvaWNlSWQiOjg2NzcyMTEwLCJpbnZvaWNlRGF0ZSI6MTYzMDI2MzEzNTAwMCwiaW52b2ljZVN0YXR1c2VzIjpbMCw5LDIsMyw0LDcsMTMsMTQsMTUsMTYsMTcsMTgsMTksMjAsMjEsMjJdLCJjb3VudCI6MjEsImlzQmFja0N1cnNvciI6ZmFsc2V9&count=20' \
--header 'Amazon-Advertising-API-ClientId: amzn1.application-oa2-client.bb835f08d5654ef88976a8b79bf14608' \
--header 'Amazon-Advertising-API-Scope: 747209745745892' \
--header 'Authorization: Bearer Atza|IwEBIMgNe3-Wez_hzvyMZRiVzUy4Niw8gedhlKEyEb0-LFqq8GCshVVrep7JVb06Wca1RvPOdMc94EiEFKhQF-npt8O6eXy4n28m68GZBpup-4ioYXfMy48Q_qRDKKpToQ9ixUk2_j5kPVVHQjGoaFJZ6x6o1kK_Av0iNGP7pBSaYjiNHsllUcXIXlAt0rhVWdPubMm_8GSFmkw9Usx0LPnMwzERRZVh9g87TOZgSGveYv-BtRFg_d4z2wFZOXcbZE4yYO_SotbJj81QGy7aqsrd669z-SGSHea63mQGYZm0o9XYiGw1h3t4nVbAWQ9RQhKqhfHxAx_G5jxyR7xcI_fm_PxNe7qFGCd-SpKi8v1mNf_3YzINocmLFa0iWpaxEogBNhRQ2EhcTcJXYX2JiKVgEg_xMix4f4OxRNXwFvxBkk2Z4fstNJgF
{ "nextCursor": "string", "previousCursor": "string", "invoiceSummaries": [ { "fees": [ { "cost": { "amount": 0, "currencyCode": "USD" }, "feeIdentifiers": { "countryCode": "string" }, "feeType": "AUDIENCE_FEE" } ], "paymentTermsDays": 0, "taxAmountDue": { "amount": 0, "currencyCode": "USD" }, "remainingTaxAmountDue": { "amount": 0, "currencyCode": "USD" }, "remainingFees": [ { "cost": { "amount": 0, "currencyCode": "USD" }, "feeIdentifiers": { "countryCode": "string" }, "feeType": "AUDIENCE_FEE" } ], "toDate": "string", "dueDate": "string", "invoiceDate": "string", "remainingAmountDue": { "amount": 0, "currencyCode": "USD" }, "fromDate": "string", "amountDue": { "amount": 0, "currencyCode": "USD" }, "taxRate": 0, "purchaseOrderNumber": "string", "paymentTermsType": "EOM", "paymentMethod": "CREDIT_CARD", "id": "string", "downloadableDocuments": [ "INVOICE" ], "status": "ACCUMULATING" } ] }
参考查询案例
Amazon-Z01513-US(ID 11977)

Amazon-Z01537-US(ID 12503)

| 所属迭代 | 【分支】产品中心1月非正常更新版本(2022年) |
|---|---|
| 所属模块 | 赛盒科技 赛盒ERP管理系统 数据报表组 |
| 相关需求 | 亚马逊信用卡费用对接 |
| 指派给 | Closed 于 2023-10-31 14:48:28 |
| 任务类型 | 后端 |
| 任务标签 | 初始 |
| 开发组 | |
| 任务状态 | 已关闭 |
| 进度 | 100% |
| 优先级 | P2 |
| 关键词 | |
| 抄送给 |
| 由谁创建 | 韦思成 于 2021-12-14 09:41:07 |
|---|---|
| 由谁完成 | chenjie 于 2021-12-16 17:40:41 |
| 由谁取消 | 暂无 |
| 由谁关闭 | 周杰 于 2023-10-31 14:48:28 |
| 关闭原因 | 已完成 |
| 最后编辑 | 周杰 于 2023-10-31 14:48:28 |
| 团队 | 最初预计 | 总计消耗 | 预计剩余 |
|---|
| 最初预计 | 24工时 |
|---|---|
| 总计消耗 | 24工时 |
| 预计剩余 | 0工时 |
| 预计开始 | 2021-12-14 |
| 实际开始 | 2021-12-16 |
| 截止日期 | 2021-12-16 |
添加调度Job
/job/AdvertisingInvoicesJob/RequestReport
CustomerID 选填
OrderSourceID 选填
初始化接口
/job/AdvertisingInvoicesJob/RequestFullDataReport
CustomerID 选填
OrderSourceID 选填
添加MQ队列消息
MqWorker 下载发票列表以及最近7/15/30/45天发票日期的详细数据
列表信息
发票详细
数据接口文档
http://192.168.200.253/apidoc/web/#/69?page_id=4450