Forum Discussion
Get Api Data from Web Api Connection
Go to Power Query and select the correct query. You should see something like this:
Click List.
Then click 'To Table' on the top left. Click 'OK' on the prompted window. You should see this as below
Click this button circled above. Uncheck the option in the 'Use original column name as prefix' then click OK. You will see several more columns that have this option as well once it is expanded. That is because there is a nested list. Do the same for those columns and make sure to click 'Expand to New Rows'.
Hope this helps!
Go to Power Query and select the correct query. You should see something like this:
Click List.
Then click 'To Table' on the top left. Click 'OK' on the prompted window. You should see this as below
Click this button circled above. Uncheck the option in the 'Use original column name as prefix' then click OK. You will see several more columns that have this option as well once it is expanded. That is because there is a nested list. Do the same for those columns and make sure to click 'Expand to New Rows'.
Hope this helps!
It worked perfectly!!!!!
Thank you very much!!!!!
Hello
I’m trying to get datas from a web service, but without success.
The procedure I am following is:
- Open PowerBI
- Select “get data”
- Other
- Web
- Selected “basic”
- I have informed the https://api.vhsys.com/v2/extratos/:id
- Then pressed ENTER), but it showed the querry has 404 error
The API documentation shows the following PHP
<?php
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://{api_address}/v2/extratos/:id",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => array(
"Access-Token: SEU (Access-Token) DE ACESSO ",
"Secret-Access-Token: SEU (Secret-Access-Token) DE ACESSO",
"Content-Type: application/json"
),
));
$response = curl_exec($curl);
$erro = curl_error($curl);
?>
Does anyone can help me?
