Google Data Studio
#
IntroductionThrough the Business Intelligence integration, it is possible to optimize time by easily issuing customized reports, in addition to allowing data to be extracted and consumed on BI platforms.
#
EndpointsTo use this feature, access the menu Integrations and then Business Intelligence at the right panel and click at the Integrate button:
To analyze data on your BI platform, there are 4 types of endpoints that allow the user to generate .JSON file and feed the BI tool:
Deploys
Projects
Assets
Users
To create a connector with the BI tool, just copy the Conviso Platform URL (https://app.convisoappsec.com/), the Endpoint, and your x-api-key (you can generate your x-api-key by following the instructions here) and insert the parameters at the BI tool you are using.
#
Google Data Studio SetupLog on to Google Data Studio here, click at Create button and choose Report:
At the search box, search for JSON/CSV/XML
and select the JSON/CSV/XML Connector:
Now you have to authorize Data Studio to use a Google user account. To do so, click at the button Authorize:
A floating window will be shown for user selection. Select your user (or provide an existing user credentials) by clicking over it:
A new floating window will be shown. Click at the Allow button to allow the connector to access the provided Google user account:
Next, click the Authorize button below the JSON/CSV/XML authorization box:
Finally, click at the close icon to close the Supermetrics floating window:
This windows will be shown. We will fill this form with the following data: Data Type, Source URL or Google Drive path and HTTP headers:
- At Data Type, select JSON;
- At Source URL or Google Drive path, insert
https://app.convisoappsec.com/api/v2/projects
; - At HTTP headers, insert
x-api-key:<your-generated-api-key>
.
When done filling the form, click at the button Add, in the lower right corner:
A floating confirmation window will be shown. Click at the Add to Report button to save:
Your automatically generated Dashboard will be shown. It is also possible to create Dashboards of your own: