but 14 is a PaymentId, not a transaction id. If I follow the the apiUrl (with access token of course) it would return an empty string. The real transaction id is 422 (in this example), so the url should be https://api.infusionsoft.com/crm/rest/v1/transactions/422
What is wrong: the url or the id?
I need to get the list of the products from that transaction after the payment. How can I do it? Preferably without querying 3 tables (InvoicePayment, InvoiceItem, and OrderItem)
Hi @and_dev it looks like we are giving back the PaymentId which mismatches what the transaction endpoint requires. You would need to first get the correct transaction Id from the orders/{orderId}/transactions endpoint⌠This looks like an oversight, I have created a ticket for the team to address this.
itâs not orderId either, orderId for this transaction would be 24, not 14. I was experimenting with promotions, when the price is $0, it doesnât count as a payment, I guess. REST Hook wasnât triggered.
14 matches PaymentId from the table InvoicePayment, so it requires several steps to get transactionId
Can you update this topic when the issue would be resolved? Thanks
The answer is there but no one like it. You follow the payment id back to get the invoice id. While it might be nice to combine these into one api call, itâs still available this way, just by tracking back the idâs. It would be great if the api allowed for SQL JOINs but it doesnât so tracking back is at least viable
do you want the order id or the id of the invoice the payment was applied to? an order is just a one time template that all invoices are created fromâŚthe payment is made therefor, against the invoice⌠when you retrieve the payment information it provides a invoice id
NOTE: I realize that IS/Keap have always used the term order a bit loosely and that causes confusionâŚbut clarifying that the payment is against an INVOICE is most importantâŚthe âget order details or payment etcâ is a mis-use of the terms on their part, non the less, using the REST api, this is what returns the invoice id in question.