@amts I`m dealing with the same issue, and that is incorrect.
The captures object is not always returned.
For example, if you get the details of on order for a subscription payment, you get something like this:
{
"id":"2M9235603X788581X",
"intent":"CAPTURE",
"status":"APPROVED",
"payment_source":{
"paypal":{
"email_address":"email_address",
"account_id":"8XHXZUT5Y3CVS",
"name":{
"given_name":"John",
"surname":"Doe"
},
"address":{
"country_code":"US"
}
}
},
"purchase_units":[
],
"payer":{
"name":{
"given_name":"John",
"surname":"Doe"
},
"email_address":"email_address",
"payer_id":"8XHXZUT5Y3CVS",
"address":{
"country_code":"US"
}
},
"create_time":"2023-02-13T17:24:46Z",
"links":[
{
"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/2M9235603X788581X",
"rel":"self",
"method":"GET"
},
{
"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/2M9235603X788581X",
"rel":"update",
"method":"PATCH"
},
{
"href":"https:\/\/api.sandbox.paypal.com\/v2\/checkout\/orders\/2M9235603X788581X\/capture",
"rel":"capture",
"method":"POST"
}
]
}
Which is fine for the initial confirmation, but what do you do when you want to get the Fees for example?
Or you want to confirm the payment if the subscription is for later payment, not immidiate capture?
Well you search endlessly on google, and pull out some hair.
Because this is what the webhook gets as confirmation on the 'PAYMENT.SALE.COMPLETED' event:
{
"id":"WH-6SE66006R98946535-7F814879YL577135N",
"event_version":"1.0",
"create_time":"2023-02-13T17:25:09.906Z",
"resource_type":"sale",
"event_type":"PAYMENT.SALE.COMPLETED",
"summary":"Payment completed for EUR 39.37 EUR",
"resource":{
"billing_agreement_id":"I-0HN4N0KTWLMP",
"amount":{
"total":"39.37",
"currency":"EUR",
"details":{
"subtotal":"39.37"
}
},
"payment_mode":"INSTANT_TRANSFER",
"update_time":"2023-02-13T17:25:03Z",
"create_time":"2023-02-13T17:25:03Z",
"protection_eligibility_type":"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE",
"transaction_fee":{
"currency":"EUR",
"value":"1.76"
},
"protection_eligibility":"ELIGIBLE",
"links":[
{
"method":"GET",
"rel":"self",
"href":"https://api.sandbox.paypal.com/v1/payments/sale/036421861N8145017"
},
{
"method":"POST",
"rel":"refund",
"href":"https://api.sandbox.paypal.com/v1/payments/sale/036421861N8145017/refund"
}
],
"id":"036421861N8145017",
"state":"completed",
"invoice_number":""
},
"links":[
{
"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-6SE66006R98946535-7F814879YL577135N",
"rel":"self",
"method":"GET"
},
{
"href":"https://api.sandbox.paypal.com/v1/notifications/webhooks-events/WH-6SE66006R98946535-7F814879YL577135N/resend",
"rel":"resend",
"method":"POST"
}
]
}
Ok, so this is partial information, I have fees but not much else in terms of values, and I dont have a direct link to list all transaction/orders for a subscription.
Lets see what the API gives when you try and look for all the transaction for a given subscription:
{
"transactions":[
{
"status":"COMPLETED",
"id":"036421861N8145017",
"amount_with_breakdown":{
"gross_amount":{
"currency_code":"EUR",
"value":"39.37"
},
"fee_amount":{
"currency_code":"EUR",
"value":"1.76"
},
"net_amount":{
"currency_code":"EUR",
"value":"37.61"
}
},
"payer_name":{
"given_name":"John",
"surname":"Doe"
},
"payer_email":"email_address",
"time":"2023-02-13T17:25:03.000Z"
}
],
"links":[
{
"href":"https://api.sandbox.paypal.com/v1/billing/subscriptions/I-0HN4N0KTWLMP/transactions?start_time=2023-02-01T07%3A50%3A20.940Z&end_time=2023-02-28T07%3A50%3A20.940Z",
"rel":"SELF",
"method":"GET"
}
]
}
Thats odd, I had to specify a date to get transactions for a subscription, which makes no sense, but at least I got the fees and the proper amounts.
Ok good, soooo whats left now is for me to somehow connect the transaction ID with the order ID.....?!?!??!?!
And its basically a dead end, at least I dont see how to proceed.
I was left with the same question, whats the difference between order ID and transaction ID (in practicality, not the decided convention of the data structure)?
Also how do you connect them together?
If the order doesnt contain the fees or the captures where I can usually find the transaction IDs for one time paymnents, then how do I get them?
I dont have a way to connect a transaction ID with an order ID of a subscription payment, please help.
