csv - PayPal 自动完成付款的每月或每周报告

Question

我们可以手动转到 https://business.paypal.com/merchantdata/reportHome 下载 PayPal 已完成付款的 CSV 或 XLS。并进行“事件下载”:

但如何每周或每月自动(通过电子邮件或 API)获取此 CSV 报告，而无需手动登录网站？

注意:

• 我已经查看了 PayFlow reports和 download-reports但是看起来挺复杂的，也没有完整的例子(只有XML samples但是不清楚怎么用)

• 我不想为此使用 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",...

Answer 1

您必须通过 XML api 来完成。基本上，您使用您提供的链接中的示例 XML 发出发布请求，但使用您的数据。响应将采用 XML 格式，您获取返回的 reportId，然后调用获取报告 api，它将以 xml 格式返返回告数据。