You will have to get full documentation of the REST request(with request examples) from the team that maintain REST server or API support
there must be 2 url one to fetch access token(you pass client id and client secret as query parameter) and other to get data.
access token has to be passed in second url as query parameter or header( you will see these options when you try to create a connection)
In QlikView, I don't think you can pass parameters dynamically (as it might not support with clause). I use qliksense which supports dynamic passing. It depends on how long your access token remains valid. You can fetch it manually everytime using clients like chrome advanced rest connection and put it manually in your rest call to fetch data if it is valid for considerable time like a week or a month etc. You can also use some other programming language to fetch and store data somewhere if you are a developer.
An example( qliksense but should help you understand)
//To fetch token, FetchConnection is the name of REST connection with url of fetching token . You can generate query using create query wizard
LIB CONNECT TO 'FetchConnection';
response:
SQL SELECT
"token_type",
"access_token"
FROM JSON (wrap on) "root";
let access_token = peek('access_token', -1);
let token_type = peek('token_type', -1);
trace $(access_token);
//this is call to fetch data url but instead of creating connection, i am passing dynamic values using with which may not work in qlikview
RestConnectorMasterTable:
SQL SELECT
xyz
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION (
Url "urltofetchdata",
HTTPHEADER "Accept" "application/json;odata=verbose",
HTTPHEADER "Authorization" "$(token_type) $(access_token)")
;
I will have data in RestConnectorMasterTable:
This video will help you understand how to create connection and create query using rest connector
https://www.youtube.com/watch?v=oUKNk1IZMZQ
.png "Former Employee"){kind=icon}
