10-12-2017 05:48 AM
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!