Stripe Reporting API返回CSV仅含表头无数据行问题求助

我用Postman调用Stripe API获取Reporting API数据，测试账户内有多笔已完成的成功交易。从Stripe仪表盘直接下载的付款文件包含有效表头和数据行，但通过API创建report run（ID：frr_1OYsDeHpBAlTJ9LaKaZJPWCn）后下载的CSV文件仅含表头，无数据行。以下是该report run的响应结果：

{"id": "frr_1OYsDeHpBAlTJ9LaKaZJPWCn","object": "reporting.report_run","created": 1705333018,"error": null,"livemode": false,"parameters": {"interval_end": 1705276800,"interval_start": 1702944000},"report_type": "payout_reconciliation.itemized.5","result": {"id": "file_1OYsE0HpBAlTJ9LaHP83ElFn","object": "file","created": 1705333040,"expires_at": 1736869040,"filename": "frr_1OYsDeHpBAlTJ9LaKaZJPWCn.csv","links": {"object": "list","data": [{"id": "link_1OYtbbHpBAlTJ9LaAhALJNLt","object": "file_link","created": 1705338347,"expired": false,"expires_at": null,"file": "file_1OYsE0HpBAlTJ9LaHP83ElFn","livemode": false,"metadata": {},"url": "https://files.stripe.com/links/MDB8YWNjdF8xT1A0clRIcEJBbFRKOUxhfGZsX3Rlc3RfZWJkVnowU1JkNEh3VW1JTHEwdDJoeWhi00LKHMAhaA"},{"id": "link_1OYta2HpBAlTJ9LaVmCJZDUV","object": "file_link","created": 1705338250,"expired": false,"expires_at": null,"file": "file_1OYsE0HpBAlTJ9LaHP83ElFn","livemode": false,"metadata": {},"url": "https://files.stripe.com/links/MDB8YWNjdF8xT1A0clRIcEJBbFRKOUxhfGZsX3Rlc3RfcXlhTm9LdXR0ekRoWWx6UWJ0eTBUcngz00Bjfm8xi2"}],"has_more": false,"url": "/v1/file_links?file=file_1OYsE0HpBAlTJ9LaHP83ElFn"},"purpose": "finance_report_run","size": 170,"title": "FinanceReportRun frr_1OYsDeHpBAlTJ9LaKaZJPWCn","type": "csv","url": "https://files.stripe.com/v1/files/file_1OYsE0HpBAlTJ9LaHP83ElFn/contents"},"status": "succeeded","succeeded_at": 1705333040}

可能的原因及解决方法 #

• 报表类型不匹配：你选用的payout_reconciliation.itemized.5报表，仅统计已关联到付款（payout）的交易明细，而非所有成功交易。仪表盘下载的可能是其他类型报表（如all_transactions.1），包含全量交易数据，所以能看到内容。
• 时间区间无匹配数据：转换时间戳可知，你指定的区间是2023-12-18至2024-01-15。若测试账户内的付款记录不在这个时间段内，报表会无数据。
• 测试交易未完成付款流程：Stripe测试环境中，交易创建后不会自动触发付款，需手动在仪表盘创建测试付款，或等待模拟的2天付款周期结束。若交易仍处于待付款状态，不会出现在payout_reconciliation类报表中。

解决步骤 #

1. 更换报表类型为all_transactions.1，重新生成报表验证是否能获取交易数据。
2. 登录Stripe仪表盘，检查指定时间区间内是否有已完成的付款记录。
3. 若需使用payout_reconciliation报表，先在测试账户中手动完成付款流程，再重新生成报表。

内容的提问来源于stack exchange，提问作者Zabs