How to Get Payment by Invoice

[Menelion]

Hello,

I'd like to get payments by invoice. So I have all the invoice info and I need to connect it to payments somehow. There is InvoiceId and InvoiceNumber in the Payment object, but they are available for creating only. How do I query payments by invoice in real time?

Thanks!

[tatyana]

Hi! You will want to pull it via InvoicePayment object https://knowledgecenter.zuora.com/Central_Platform/API/G_SOAP_API/E1_SOAP_API_Object_Reference/Invoi...

[Menelion]

Hi, thanks.

I tried `select PaymentId from InvoicePayment where InvoiceId=<id>`. InvoiceId is valid, no errors are thrown, but ZoQL returns no results. Any more ideas please? Thanks.