{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Adapter for Envoy
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • 日本語コミュニティ
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Analytics /
avatar image
1
Question by Alex Koo · May 20, 2016 at 04:09 PM · 1.3k Views custom reports

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?

Comment
Add comment Show 6
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image psunda · Oct 14, 2016 at 06:19 AM 0
Link

@Anil Sagar @Alex Koo

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 :

https://api.enterprise.apigee.com/v1/organizations/prisunda/reports/%7B0950ddbc-1787-4287-b2b9-a5115469987d%7D

Result:

Illegal character in path at index 57: http://management:8080/v1/organizations/prisunda/reports/{0950ddbc-1787-4287-b2b9-a5115469987d}
avatar image Anil Sagar @ Google ♦♦ psunda   · Oct 14, 2016 at 06:32 AM 0
Link

@Priya Sundararajan , Answers are strictly for answers. Please Ask a question instead of posting same in other threads.

avatar image Anil Sagar @ Google ♦♦ Anil Sagar @ Google ♦♦   · Oct 14, 2016 at 06:41 AM 0
Link

@Priya Sundararajan , Remove the curly braces !

avatar image psunda Anil Sagar @ Google ♦♦ · Oct 14, 2016 at 06:48 AM 0
Link

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. 
Show more comments
avatar image psunda psunda · Oct 14, 2016 at 08:44 AM 0
Link

Thanks! That worked :)

Close

2 Answers

  • Sort: 
avatar image
3
Best Answer

Answer by Anil Sagar @ Google   · May 20, 2016 at 04:47 PM

@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 :)


screen-shot-2016-05-20-at-101828-pm.png (149.3 kB)
Comment
Add comment Show 4 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Alex Koo ♦♦   · May 20, 2016 at 07:48 PM 0
Link

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

avatar image Alex Koo ♦♦   · May 20, 2016 at 07:54 PM 0
Link

Hi @wwitman, please see above, as our docs will benefit from additional notes on how to export/import. Perhaps here or as a new sub topic under Analyze.

avatar image Will Witman ♦♦ · May 24, 2016 at 04:38 PM 0
Link

@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.

avatar image Anil Sagar @ Google ♦♦ Will Witman ♦♦   · May 25, 2016 at 06:31 AM 0
Link

Awesome, Thank you @wwitman for quick update & docs article regarding same.

avatar image
0

Answer by Lee · Jun 22, 2016 at 10:00 AM

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.

Comment
Add comment · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Follow this Question

Answers Answers and Comments

22 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Analytics - monthly data and errors for previous month 0 Answers

Custom reports fail to run after recent update 2 Answers

Analytics report on proxy chaining.. no of call to a proxy and from a proxy 1 Answer

Wildcard characters in Custom Report Filter 1 Answer

Is possible to get error code with error description in the apigee custom reports 0 Answers

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2021 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Adapter for Envoy
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • 日本語コミュニティ
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Badges