Power Query Get Token for OAUTH

[Anonymous]

Hello everyone,

I have the following code to generate an OAUTH token Does anyone have any idea how I write this in Power Query

// Values from your OAuth app. You create ONE for a page/plugin/service.
$clientid     = "#Place OAuth clientID here#";
$clientsecret = "#Place OAuth client secret here#";

// The official CleverReach URL, no need to change this.
$token_url = "https://rest.cleverreach.com/oauth/token.php";

// We use curl to make the request
$curl = curl_init();
curl_setopt($curl,CURLOPT_URL, $token_url);
curl_setopt($curl,CURLOPT_USERPWD, $clientid . ":" . $clientsecret);
curl_setopt($curl,CURLOPT_POSTFIELDS, array("grant_type" => "client_credentials"));
curl_setopt($curl,CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($curl);
curl_close ($curl);

// The final $result contains the access_token and some other information besides.
// For you to see it, we dump it out here.
var_dump($result);

The final result of the OAuth process is the access token.Here is the format of the reponse as an example.

{
  "access_token":  "7h4t1s50mek1nd0fab4t70ken",
  "expires_in":    31536000,
  "scope":         "batmobile batcycle batplane batcopter",
  "refresh_token": "m4keb4t70kenfr35h"
}

[Stachu]

have a read here:
https://community.powerbi.com/t5/Desktop/Issue-with-getting-data-via-API-with-bearer-token/m-p/12623...
and here
https://community.powerbi.com/t5/Desktop/Power-Query-Open-ID-and-OAuth-2-0-Rest-API/m-p/693162

[Anonymous]

@Stachu Thanks for the links, but unfortunately I can't get anywhere with them, because the cURL process for the request is not explained here. Do you have an idea how I write this with PowerQuery

[Stachu]

try to connect with the PowerBI UI (regular web connection) and show the M code that gets generated together with the respective errors, I will try to troubleshoot from there

[Anonymous]

I have inserted the Token URL alone into the Web Connection without settings and this message appears.