Api access for historical data (transaction) longer than 12 month and upto 7 years.

[Shalid]

Hey guys, we are trying to use a third party solution to access our historical data (transactions) to sync them to our qbo accounting program. I have been told that while I can view and download transactional data dating back 7 years, they restrict third party application such as paytraqer and Synder to only 1 year. It used to be 7 years then three years but have recently changed it to one year. Is there anyway for PayPal to allow access for the seven year. Even temporarily will work. An api will make the most sense. Looking forward to your reply.

[MTS_Chiranjeevi]

Good day @Shalid,

Thank you for posting to the PayPal community.

I would suggest to please use Transaction Search API (REST API Integration) to get the history of transactions for a PayPal account.

https://developer.paypal.com/docs/api/transaction-search/v1/
https://developer.paypal.com/docs/api/transaction-search/v1/#transactions_get 

Guide link for Transaction Search API (NVP API Integration) : 

https://developer.paypal.com/docs/nvp-soap-api/transaction-search-nvp/

NOTE : Merchants can also use PayPal Activity download report.

Login PayPal.com >> Reports >> Activity Download >> select "Transaction type"  >> date range >> create report.

(Or)

Login PayPal.com >> Goto direct link - https://www.paypal.com/reports >> select "Activity download".

Sincerely,

Chiranjeevi

PayPal/Braintree MTS

If this post or any other was helpful, please enrich the community by giving kudos or accepting it as a solution.

[Shalid]

Hi Sir, Thank you for your reply. You are correct, we can download the data through the activity window (https://www.paypal.com/reports) but can only download it. Will the api allow us to retrieve this data in real-time for syncing purposes?

[MTS_Chiranjeevi]

@Shalid 

Yes, merchant can use the below PayPal APIs and get the transaction data to handle your internal database or accounting software etc.

Please use Transaction Search API (REST API Integration) to get the history of transactions for a PayPal account.

https://developer.paypal.com/docs/api/transaction-search/v1/
https://developer.paypal.com/docs/api/transaction-search/v1/#transactions_get 

Transaction Search API (NVP API Integration) : 

https://developer.paypal.com/docs/nvp-soap-api/transaction-search-nvp/

[Shalid]

Hi Chiranjeevi, Thank you so for gettting back to me and your support. Just to confirm, this api call is not restricted to 3 years of data but will allow us to access and sync data all the way back to 2016? Looking forward to your reply.

[MTS_Chiranjeevi]

Hi @Shalid,

This call lists transaction for the previous three years. However, a full three years of data will not be available until July 2018 because data has only been stored since July 2016.

https://developer.paypal.com/docs/transaction-search/ 

https://developer.paypal.com/docs/api/transaction-search/v1/#search_get 

NVP API - https://developer.paypal.com/api/nvp-soap/transaction-search-nvp/ 

[Shalid]

Hi Chiranjeev, I am sorry for the confusion. Are you saying that we will be able to access data with this api from 2016 to now or the api only allows 3 years of data 2020-2023? Looking forward to your reply.

[MTS_Chiranjeevi]

@Shalid you should be able to access last 3 years of data.