Search by API / JSON - Latam and Gol (Power BI)

Question

Good Morning!

Guys, I’m riding a Dashboard on Power BI, and I need to link it to the Gollog and Latam load tracking site.

I already have the link to search the web service, but I do not know how to link this search to my Power BI database. I need him to run a search for every line of my database, where the Awbs are being searched.

link:

https://api-golcargo.gollog.com.br/Api/PartnerIntegration/UCAS http://integracliente.soa.lancargo.com/lancargo/wteService?wsdl

Answer 1

I believe that in Power BI it is not possible to run such a service. I believe that the ideal would be to create a service party that consumes the data of its base, consult the API and generate another base so that there is relationship between the two bases.

With python it is very easy to assemble API consumption.