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.