Skip to main content

Google Data Studio - Integrations with the STILINGUE API

  • Updated

Index:

  1. Introduction
  2. How to establish the connection?

Introduction

From the API, it is possible to integrate two or more distinct systems. The great advantage of this process is the customization of data from these systems in a secure and agile way. 

This guide contains the instructions for integrating the STILINGUE API with Google Data Studio in order to create custom tables, charts, and dashboards. You can also connect the STILINGUE API to Microsoft PowerBI and Google Sheets.

Custom Services: Need help with importing structured data and managing interfaces for STILINGUE's complementary tools? We can assist you! Our team of experts is ready to assist you. Contact your STILINGUE Account Manager to access this and several other services.

 

How to establish the connection?

First, you need to generate the token from your STILINGUE research dashboard. To learn more about this process, check out our guide on the STILINGUE API.

With the STILINGUE API, you can make requests for various types of data.

First, you need to determine which data will be included - for example, in the case of Overview data:

The endpoint to be used is:

api.stilingue.com.br/wrapi/publicacoes/<TOKEN>

Important! Replace <TOKEN> with the numbers from your token.

You can include filters to increase the limit, date range, as well as various other features found in the  API documentation.

For the connection, we will use a test token with a limit of 400 publications from the publication wall in the last 3 days:

With the request in hand, we should connect to Data Studio:

  1. First, select Data Source from the "Create" menu;
  2. Search for JSON in the search bar and select Custom JSON/ CSV/XML. Since the API requests return data in JSON format, we should use a partner connector like supermetrics;
  3. Grant the necessary authorizations;
  4. Choose the data type as JSON and include the request, once done, just connect;
  5. After the connection is established, supermetrics will bring the list of returned fields for you to start creating dashboards:

 

This way, you can already create your custom reports.

Note: If you are interested in aligning the integration with the goals of your research, we recommend reaching out to your Success Manager for support in setting these objectives. This way, you can better extract the information you need from your reports.


For more information, visit the discussion on the subject at our community or videos on our channel. 😃

Related articles