How to export the custom report design
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?
I am having issues in fetching the report from my Trial(Cloud) version of Edge. When I ran the following command, I received a list of reports :
https://api.enterprise.apigee.com/v1/organizations/prisunda/reports
Result :
<Reports> <Qualifier> <displayName>WeatherReport</displayName> <name>dff90738-920d-4e06-84ab-f05ffda5f5dc</name> </Qualifier> <Qualifier> <displayName>FlowSegment</displayName> <name>0950ddbc-1787-4287-b2b9-a5115469987d</name> </Qualifier> <Qualifier> <displayName>SCOReport</displayName> <name>a0b7eb12-87af-4d42-90c6-6b19264112f2</name> </Qualifier> </Reports>
If I try to GET the report with id {dff90738-920d-4e06-84ab-f05ffda5f5dc} using the following command, I get a URI parsing error :
Result:
Illegal character in path at index 57: http://management:8080/v1/organizations/prisunda/reports/{0950ddbc-1787-4287-b2b9-a5115469987d}@Priya Sundararajan , Answers are strictly for answers. Please Ask a question instead of posting same in other threads.
@Priya Sundararajan , Remove the curly braces !
Just tried that with https://api.enterprise.apigee.com/v1/organizations/prisunda/reports/0950ddbc-1787-4287-b2b9-a5115469987d.
Now getting the following error :
JAXBException occurred : 1 counts of IllegalAnnotationExceptions.
Best Answer
Answer by Anil Sagar @ Google
·
May 20, 2016 at 04:47 PM
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 :)
Excellent. As your answer suggests, I only need to remove the 'name' field (e.g., "name" : "a08c851d-7fb3-4c7d-8472-ad935b23e830") from the GET response, then I can POST that to the new org. Thanks for the great answer, @Anil Sagar
@Alex Koo -- Good suggestion. And excellent post here. For now, I added a brief topic that points to this post, which does a good job of explaining how to. We can build out the topic as time permits.
Awesome, Thank you @wwitman for quick update & docs article regarding same.
Did I miss some docs? Is it possible to run reports via API?
Ideally, it would be nice to get the tabular output as JSON or CSV rather than the default "meta" model provided by analytics APIs.
