REST API list payments

[BorisK]

Dear PayPal Team,
dear developers,

i am new in PayPal API but i am working with REST since some years to automate some financial and cloud backup processes.

Today i had a look to an old PHP script (PHP SDk Version 53, using for getting balance and get actual incoming payments) to check if it is still working. It didnt so i suppose that this is outdated.

I decided to do some fresh stuff and created a little .NET application. Getting oAuth key was working fine, request payments stuck. I got some payments, some not. After searching and searching i have read in another forum that REST API can only "see" that payments which are done by REST.

My questions:

a.) Am i right? REST API (list payments) show only REST payments?
b.) if a is true, is there another workaround to request full list of all payments (including refunds etc.)?

c.) Where do i find working examples for the "Classic" API to list ALL payments?

I found this url:
https://developer.paypal.com/docs/classic/api/merchant/TransactionSearch_API_Operation_NVP/

But what about endpoint? Which credentials to use?

Searching a little bit more:

https://developer.paypal.com/docs/classic/express-checkout/ht_searchRetrieveTransactionData-curl-etc...

"&SIGNATURE=merchant_signature"

Where to find or create such signature?

In my PayPal Account i see below certificate (installed some years before) a fingerprint. Is that my signature?

Using that fingerprint as signature returns:

TIMESTAMP => 2017-03-28T13:01:17Z
CORRELATIONID => d08d30492ac48
ACK => Failure
VERSION => 94
BUILD => 25237094
L_ERRORCODE0 => 10002
L_SHORTMESSAGE0 => Security error
L_LONGMESSAGE0 => Security header is not valid
L_SEVERITYCODE0 => Error

Using endpoint:

$curl = curl_init('https://api-3t.paypal.com/nvp');

Or is the certificate / signature binded to the server / ip where the certificate has been created? (Checked from origin IP but same).

Searching again:

https://developer.paypal.com/docs/classic/api/apiCredentials/

Signature on picture at the bottom: Line 4 "Signature" is missing in my account, but i can see username and password.

Thanks in advance.

Best regards from germany
Boris

[MTS_Nacho · Accepted solution]

a.) Am i right? REST API (list payments) show only REST payments?

Yes, the REST Payments API will only list the payments that have been made using such API.

b.) if a is true, is there another workaround to request full list of all payments (including refunds etc.)?

You could use our classic TransactionSearch and GetTransactionDetails API to list all of the transactions in your account:

https://developer.paypal.com/docs/classic/api/merchant/TransactionSearch_API_Operation_NVP/

https://developer.paypal.com/docs/classic/api/merchant/GetTransactionDetails_API_Operation_NVP/

c.) Where do i find working examples for the "Classic" API to list ALL payments?

Our classic SDKs should have examples for each API:

https://developer.paypal.com/docs/classic/api/nvpsoap-sdks/

For example, if you use .NET:

https://github.com/paypal/merchant-sdk-dotnet/tree/master/Samples/PayPalAPISample/APICalls

Alternatively, you can build your own NVP POST based in our API reference.

REgarding the API credentials, we would recommend to use API Signature, that can be obtained from this direct link:

https://www.paypal.com/cgi-bin/webscr?cmd=_profile-api-access

If you already have an API Certificate in place, you will need to remove it before being able to request a new API Signature.