I’m not a developer, but a data analyst. Please excuse my lack of knowledge of API.
I have 3 tables from Paypal API:
- subscriptions
- refunds
- disputes
There is no shared key/column that I can associate with the original subscription to refund or dispute. It looks like we are pulling all the information available.
Is it really not possible to link a refund/dispute back to the parent subscription? Or have we missed something?
2
Answers
Refunds should reference the parent transaction at the least, and parent transactions should reference the subscription ID. If you don’t have this information available, it’s because you haven’t stored it from the responses you receive from PayPal.
Forget about these tables – and simply query the live API instead.
This would be the full data-set, until today, which has all the fields.