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"
}
