PlandayTeam Honor Student

Honor Student

Honor Student
Posts: 1
Registered: ‎09-16-2016

API Integration


I need a query URL which shows me MRR per customer per month.


Therefore I need these endpoints from different report types:

- Account: Portal GUID (custom field)

- Account: Name

- Account: Currency

- Bill To: Country

- Rate Plan Charge: MRR

- Invoice: Status

- Invoie: Invoice Date


Is there a way to extract data from customized reports like the one I created above? A workaround would be to push this report into Google Sheets, if Zuora is capable to do so, since my dashboard tool can integrate with Google Sheets or I setup a GET Rest API query.


Any help appreciated!