REST Sync API - Payments do not show up until several HOURS later

[Nimja]

This is just one example, every transaction appears to follow the same pattern of taking *at least* 4 hours before they are visible.

I got a verification (by email) of a new donation, with transaction ID; XXX123 - Timestamp: 6 June 2018 at 07:30:42 GMT+2

I can see this transaction in my activity log when I login to PayPal.

I CANNOT see this transaction, wither with:

https://api.paypal.com/v1/reporting/transactions?transaction_id=XXX123

This just returns 0 results.

Or with:

https://api.paypal.com/v1/reporting/transactions?start_date=2018-06-04T07%3A05%3A01%2B00%3A00&end_date=2018-06-07T07%3A05%3A01%2B00%3A00&fields=all&page_size=300

This returns results of other donations that are more than 4 hours old.

Why does it take so long to show up in the SYNC API results?

[Nimja]

Yes, I am having similar issues since March 7th.

[Gyro85]

Same issue as other 7th March 04:00 was last transaction in API

[p4yp4y]

 @joelconv 

What api do you use to list transaction.If are using https://developer.paypal.com/docs/archive/nvp-soap-api/merchant/get-transaction-details-nvp/ api,It does not give invoice id and transaction code ,which is crucial to me.  If not,  how can I get transaction details with transaction code and invoice id 

[Chris455]

Yep, seeing the same problem. It looks like Paypal's just dropping the ball, and since they're effectively a monopoly, they're not concerned about fixing it, because what are you going to do? Switch to Venmo, which is also owned by Paypal?

This is really frustrating, because I upgraded to a business account so I could plug in a script to their API and process customer payments, but it looks like it takes, on average, about 6 hours for transactions to show up in the API.  Turns out customers reeeeally don't like waiting 6 hours to get a payment confirmation, and I can't blame them. This is all especially weird because transactions are instantly visible on the webpage. So not only is Paypal now taking a huge cut of all my payments, but I'm they're giving me a worthless API in return. I'm going to have to write my own interface that scrapes Paypal's website just to read transactions.

[availes]

I'm wondering if this has something to do with daylight saving time.

I do note that here in the states (I don't know where all of you are from) we bumped our clocks up an hour at 2AM local time on 2020-03-08.

And 2020-03-07 is the last day that the PayPal transaction history api seems to be working.

The URL:

https://api.paypal.com/v1/reporting/transactions?start_date=2020-03-07T14:59:59-0000&end_date=2020-0...

Works for me, but the URL:

https://api.paypal.com/v1/reporting/transactions?start_date=2020-03-07T15:00:00-0000&end_date=2020-0...

What's important about this?

2020-03-07T14:59:59-0000 is 2020-03-07 2:59:59AM at International Date Line West. Add one second to this and you're at 3AM which is what we just sprung up to.

Hard to wrap my head around it completely, but it looks to be something to do with daylight saving time. Hard to imagine that PayPal has this issue every year or every time the time changes? Was it like this last year?

Nevermind, daylight saving time was 2020-03-08 not 2020-03-07 ... still seems that 2020-03-07T14:59:59-0000 is the last time to work correctly ... so something must've happened then.

[p4yp4y]

@availes 

{"transaction_details":[],"account_number":"***","start_date":"2020-02-29T01:00:00+0000","end_date":"2020-03-07T07:29:59+0000","last_refreshed_datetime":"2020-03-07T07:29:59+0000","page":1,"total_items":0,"total_pages":0,"links":[{"href":"https://api.paypal.com/v1/reporting/transactions?start_date=2020-02-29T01%3A00%3A00Z&end_date=2020-0..."}]}

that date is the last_refreshed_datetime in the response. We can not get any data after that date. This problem needs to be solved immediately. Many developers have developed their apps using Rest api, which paypal implicitly forces us to use that by restricting some of  the features  of rest api that nvp /soap does not have 

[StuC22]

Seeing the same here, now with data upto "2020-03-07T19:29:59+0000"

Every couple of hours it seems to be gaining  30minutes data..

[Handlerparts]

We have the same problem 

now "last_refreshed_datetime": "2020-03-07T19:59:59+0000"

anybody have solution?

[UCB]

Does anyone have a solution to this ?? is PayPal working on this issue ??

[StuC22]

looks to be improving from yesterday - current have upto 2020-03-10T08:59:59+0000

so its added in about 2.5 days since yesterday..