Solved: How to export the custom report design - Page 2

akoo · 05-20-2016 09:09 AM

As a developer leveraging reproducibility, I am interested in exporting a custom report design I have created in a non-prod org. I want to take that custom report design and import it into the prod org to have the same exact report. As a benefit, I would be able to save the export of the design in my SCM.

Looking through the documentation here, I don't see such a capability.

Any suggestions?

anilsr

@Alex Koo ,

Guess what, I found a hack using APIs,

GET Custom Report , In JSON Format,

https://api.enterprise.apigee.com/v1/organizations/{YOURORGNAME}/reports/{REPORTID}

Create a new report using POST

https://api.enterprise.apigee.com/v1/organizations/{YOURORGNAME}/reports

POST Body, From Above GET, Change ORG NAME, Email Address of Org ADMIN & Make post call

{
  "chartType": "column",
  "comments": [],
  "createdAt": 1455087324749,
  "createdBy": "XXXX@apigee.com",
  "dimensions": [
    "apiproxy",
    "developer_app"
  ],
  "displayName": "Traffic for Proxies and Apps - Duplicate",
  "environment": "test",
  "lastModifiedAt": 1455087324749,
  "lastModifiedBy": "XXXXX@apigee.com",
  "lastViewedAt": 1463762541649,
  "metrics": [
    {
      "function": "sum",
      "name": "message_count"
    }
  ],
  "organization": "YOURORGNAME",
  "properties": [
    {
      "property": "__ui__",
      "value": [
        {
          "name": "description",
          "value": "Custom report to see trafic for proxies and apps"
        },
        {
          "name": "accuracy"
        }
      ]
    }
  ],
  "sortbyCols": [],
  "tags": [],
  "timeUnit": "hour"
}

It worked for me, Thanks to API First Approach of Apigee 🙂

View solution in original post