csv - PayPal 自动完成付款的月度或周度报告
问题描述
我们可以通过手动访问https://business.paypal.com/merchantdata/reportHome并执行“活动下载”来下载 PayPal 已完成付款的 CSV 或 XLS:
但是如何每周或每月自动(通过电子邮件或使用 API)获取此 CSV 报告,而无需手动登录网站?
笔记:
我已经看过PayFlow 报告和下载报告,但它看起来很复杂,并且没有完整的示例(只有XML 示例,但不清楚如何使用它们)
我不想为此使用 IPN(我确实将它用于另一项任务,但由于其他原因等原因它并不完全可靠)
所需输出的示例:
"Date","Time","TimeZone","Name","Type","Status","Currency","Gross","Fee","Net","From Email Address","To Email Address","Transaction ID","Shipping Address","Address Status","Item Title","Item ID","Shipping and Handling Amount","Insurance Amount","Sales Tax","Option 1 Name","Option 1 Value","Option 2 Name","Option 2 Value","Reference Txn ID","Invoice Number","Custom Number","Quantity","Receipt ID","Balance","Address Line 1","Address Line 2/District/Neighborhood","Town/City","State/Province/Region/County/Territory/Prefecture/Republic","Zip/Postal Code","Country","Contact Phone Number","Subject","Note","Country Code","Balance Impact"
"3/1/2018","04:52:07","CET","John Doe","Website Payment","Completed","EUR","100.00","0","100","johndoe@gmail.com","contact@example.com",...
"3/1/2018","16:29:30","CET","Mike Abcd","Website Payment","Completed","EUR","100.00","0","100","mikeabc@example.com","contact@example.com",...
解决方案
您必须通过 XML api 来完成。基本上,您使用您提供的链接中的示例 XML 发出发布请求,但使用您的数据。响应将采用 XML 格式,您获取返回的reportId
内容,然后调用 get report api,它将以 xml 格式返回报告数据。
推荐阅读
- java - JavaFX 媒体循环
- angular - 使用 RxJS 的 Angular 6 错误:无法读取未定义的属性“调用”
- rx-java - 为什么 Observable.empty() 不向下游传播 onComplete() ?
- reactjs - React Redux 状态变化
- c++ - 无法在 C++ 代码中获得十进制输出。
- java - 这是 IntStream 嵌套循环的最佳选择吗?错误是什么?
- python - 如何在numpy中做antilog?
- angular - 无法将快速服务器中的图像提供给 Angular 2
- .net - 如何在 vb.net 中使用字典数据类型
- c# - 我需要帮助来恢复我的项目(被意外删除)