Get Report Details

HTTPS Request

GET https://zconnectsandbox.zuora.com/api/rest/v1/reports/0000000050b0ade40150b4966498003f/report-details

JSON Response:

{
  "success" : true,
  "response" : {
    "createdBy" : "8a8081d250440d000150a829710626fa",
    "updatedBy" : "8a8081d250440d000150a821c273268a",
    "createdOn" : "2015-10-29T10:12:46-0700",
    "updatedOn" : "2015-11-30T12:28:47-0800",
    "id" : "0000000050b0ade40150b4966498003f",
    "deleted" : false,
    "name" : "Gross MRR (as of date) over time",
    "number" : "REP0000270",
    "type" : "Common",
    "datasource" : "Rate Plan Charge",
    "dsName" : "RatePlanCharge",
    "description" : "RatePlanCharge.EffectiveDateRange (not New Date Range Field, but StartDate and EndDate), grouped by month\tProduct.Name, Account.Currency; Sum of RatePlanCharge.MRR; Subscription.Status is not in \"Expired\", \"Draft\"",
    "definition" : "{\"rowFields\":[{\"name\":\"Name\",\"id\":\"Product.Name\",\"label\":\"Name\",\"type\":\"text\",\"order\":8,\"dataSourceName\":\"Product\",\"dataSourceLabel\":\"Product\",\"dataSourceType\":\"Product\",\"searchKey\":\"Product Name\",\"sortDir\":\"NONE\",\"sortPriority\":-1,\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true},{\"name\":\"Currency\",\"id\":\"Account.Currency\",\"label\":\"Currency\",\"type\":\"text\",\"order\":14,\"dataSourceName\":\"Account\",\"dataSourceLabel\":\"Account\",\"dataSourceType\":\"Account\",\"searchKey\":\"Account Currency\",\"options\":[\"AED\",\"AFN\",\"ALL\",\"AMD\",\"ANG\",\"AOA\",\"ARS\",\"AUD\",\"AWG\",\"AZN\",\"BAM\",\"BBD\",\"BDT\",\"BGN\",\"BHD\",\"BIF\",\"BMD\",\"BND\",\"BOB\",\"BRL\",\"BSD\",\"BTN\",\"BWP\",\"BYR\",\"BZD\",\"CAD\",\"CDF\",\"CHF\",\"CLP\",\"CNY\",\"COP\",\"CRC\",\"CUP\",\"CVE\",\"CZK\",\"DJF\",\"DKK\",\"DOP\",\"DZD\",\"EEK\",\"EGP\",\"ERN\",\"ETB\",\"EUR\",\"FJD\",\"FKP\",\"GBP\",\"GEL\",\"GHS\",\"GIP\",\"GMD\",\"GNF\",\"GTQ\",\"GYD\",\"HKD\",\"HNL\",\"HRK\",\"HTG\",\"HUF\",\"IDR\",\"ILS\",\"INR\",\"IQD\",\"IRR\",\"ISK\",\"JMD\",\"JOD\",\"JPY\",\"KES\",\"KGS\",\"KHR\",\"KMF\",\"KPW\",\"KRW\",\"KWD\",\"KYD\",\"KZT\",\"LAK\",\"LBP\",\"LKR\",\"LRD\",\"LSL\",\"LTL\",\"LVL\",\"LYD\",\"MAD\",\"MDL\",\"MGA\",\"MKD\",\"MMK\",\"MNT\",\"MOP\",\"MRO\",\"MUR\",\"MVR\",\"MWK\",\"MXN\",\"MYR\",\"MZN\",\"NAD\",\"NGN\",\"NIO\",\"NOK\",\"NPR\",\"NZD\",\"OMR\",\"PAB\",\"PEN\",\"PGK\",\"PHP\",\"PKR\",\"PLN\",\"PYG\",\"QAR\",\"RON\",\"RSD\",\"RUB\",\"RWF\",\"SAR\",\"SBD\",\"SCR\",\"SDG\",\"SEK\",\"SGD\",\"SHP\",\"SLL\",\"SOS\",\"SRD\",\"STD\",\"SVC\",\"SYP\",\"SZL\",\"THB\",\"TJS\",\"TND\",\"TOP\",\"TRY\",\"TTD\",\"TWD\",\"TZS\",\"UAH\",\"UGX\",\"USD\",\"UYU\",\"UZS\",\"VEF\",\"VND\",\"VUV\",\"WST\",\"XAF\",\"XCD\",\"XOF\",\"XPF\",\"YER\",\"ZAR\",\"ZMK\",\"ZWD\"],\"sortDir\":\"NONE\",\"sortPriority\":-1,\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true}],\"colFields\":[{\"name\":\"EffectiveStartDate\",\"id\":\"RatePlanCharge.EffectiveStartDate\",\"label\":\"Effective Start Date\",\"type\":\"date\",\"order\":19,\"dataSourceName\":\"RatePlanCharge\",\"dataSourceLabel\":\"Rate Plan Charge\",\"dataSourceType\":\"RatePlanCharge\",\"searchKey\":\"Rate Plan Charge Effective Start Date\",\"sortDir\":\"NONE\",\"sortPriority\":-1,\"dateOptions\":{\"groupBy\":\"CM\",\"cohortAnalysis\":false},\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true},{\"name\":\"EffectiveEndDate\",\"id\":\"ProductRatePlan.EffectiveEndDate\",\"label\":\"Effective End Date\",\"type\":\"date\",\"order\":4,\"dataSourceName\":\"ProductRatePlan\",\"dataSourceLabel\":\"Product Rate Plan\",\"dataSourceType\":\"ProductRatePlan\",\"searchKey\":\"Product Rate Plan Effective End Date\",\"sortDir\":\"NONE\",\"sortPriority\":-1,\"dateOptions\":{\"groupBy\":\"CM\",\"cohortAnalysis\":false},\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true}],\"valFields\":[{\"name\":\"MRR\",\"id\":\"RatePlanCharge.MRR\",\"label\":\"MRR\",\"type\":\"decimal\",\"aggregation\":\"SUM\",\"order\":23,\"dataSourceName\":\"RatePlanCharge\",\"dataSourceLabel\":\"Rate Plan Charge\",\"dataSourceType\":\"RatePlanCharge\",\"searchKey\":\"Rate Plan Charge MRR\",\"extendedType\":\"Currency\",\"relatedField\":\"Account.Currency\",\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true}],\"summaryFilters\":[{\"field\":{\"name\":\"Status\",\"id\":\"Subscription.Status\",\"label\":\"Status\",\"type\":\"text\",\"order\":21,\"dataSourceName\":\"Subscription\",\"dataSourceLabel\":\"Subscription\",\"dataSourceType\":\"Subscription\",\"searchKey\":\"Subscription Status\",\"options\":[\"Draft\",\"Pending Activation\",\"Pending Acceptance\",\"Active\",\"Cancelled\",\"Expired\"],\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true},\"value\":\"Expired\",\"operator\":{\"name\":\"is not equal to\",\"value\":\"!=\"}},{\"field\":{\"name\":\"Status\",\"id\":\"Subscription.Status\",\"label\":\"Status\",\"type\":\"text\",\"order\":21,\"dataSourceName\":\"Subscription\",\"dataSourceLabel\":\"Subscription\",\"dataSourceType\":\"Subscription\",\"searchKey\":\"Subscription Status\",\"options\":[\"Draft\",\"Pending Activation\",\"Pending Acceptance\",\"Active\",\"Cancelled\",\"Expired\"],\"groupable\":true,\"sortable\":true,\"custom\":false,\"filterable\":true},\"value\":\"Draft\",\"operator\":{\"name\":\"is not equal to\",\"value\":\"!=\"}}],\"detailFilters\":[],\"selectedFields\":[],\"shareAsReadOnly\":false}",
    "version" : 1,
    "userId" : "8a8081d250440d000150a829710626fa",
    "creator" : "tim@zuora.com",
    "updater" : "gail@zuora.com",
    "executedOn" : 1452683152000,
    "favorite" : false,
    "shared" : true,
    "zuora" : false,
    "hidden" : false
  }
}