Skip to main content

Microsoft PowerBI - 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 on how to integrate the STILINGUE API with Microsoft PowerBI to create tables, charts, and dashboards. It is also possible to connect the STILINGUE API to Google Data Studio and Google Sheets.

Custom Services:  Need help with importing structured data? We can assist you! Our team of experts is ready to assist you. Contact your STILINGUE account manager to gain access to this and many 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, it is necessary to know which data will be included, for example, data from Overview:

The endpoint to be used is:

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

Important! Replace where <TOKEN> appears with the numbers of your token.

It is possible to include filters to increase the limit, date range, as well as various others 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 the JSON URL in Microsoft Power BI. To connect a JSON URL in Power BI, simply follow this tutorial: 

  • https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

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