Happy Business Starts Here

Re: List of invoices in bill run

Highlighted
Newly Enrolled

List of invoices in bill run

Using the REST Api it is possible to get the details of a bill run. It's also possible to get invoice details or a list of invoices of an account. How can I get a list of invoices that are included in a bill run? Should I use a query call or the include parameter on the GET bill-run?

2 REPLIES 2
Highlighted
Support SME

Re: List of invoices in bill run

Hi @sebastiaan you can try the following "action/query" call:

 

POST https://rest.zuora.com/v1/action/query

{
"queryString": "Select id, invoicenumber from invoice where sourceid = 'BR-00001026'"
}

 

Could you clarify what do you mean by "the include parameter on the GET bill-run" ?



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Highlighted
Zuora Alumni

Re: List of invoices in bill run

Hi @sebastiaan In order to information on bill runs, you could query the BillingRun object as seen below:

 

POST https://rest.apisandbox.zuora.com/v1/object/export

{
  "Format": "Excel", 
  "Name": "Billing Run Export", 
  "Query": "select BillingRunNumber, CreatedById, CreatedDate, EndDate, ErrorMessage, ExecutedDate, Id, InvoiceDate, NumberOfAccounts, NumberOfInvoices, StartDate, Status, TargetDate, TargetType, TotalTime, UpdatedById, UpdatedDate from BillingRun order by BillingRunNumber asc"
}

This will give you an Excel file with that Data. (Change to "Format": "csv", if Excel is not needed) 

 

Cheers,

Kevin