3scale Analytics imported in external Data Visualization tool

In this article we are going to see how we can export the analytics of 3scale API Products and import it into external (3rd party) Data Visualization tool.

Here I am using https://www.datawrapper.de/ as it was providing a Personal instance without any trial basis at the time of writing.

Steps to export / download the Analytics API :

• Go to Products->Analytics->Traffic and download the CSV as indicated in the image below.

Upload CSV into Data Visualization tool :

• Create a FREE account in https://www.datawrapper.de/.
• Click “Create New Chart” and upload the CSV downloaded earlier.
• You will see options to customize the graphs (discussing options is out of scope here) and be able to select different kind of visualizations

Conclusion :

3scale also supports generating Analytics in JSON / XML format using 3scale API Docs REST API . If your Data Visualization tools supports, you can use those formats too.

References : https://access.redhat.com/documentation/en-us/red_hat_3scale_api_management/2.10/html/admin_portal_guide/exporting-threescale-api-analytics-beyond-built-in-capabilities_analytics-for-threescale-apis