I'm running a Qlikview API rest connection where i have used several parameters in the used URL. Now I would like to re-create this in Qlik Sense.
In Qlik Sense you can create an API connection with a new data connection, however that data connection doesn't offer any flexiblity in it. I'm trying to use an API data connection together with a URL, where I use the URL to use parameters.
Any idea how i can get this working?:
Qlikview:
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://secure.p01.eloqua.com/api/REST/2.0/assets/campaigns;timeout=30;method=GET;autoDetectResponse...;";
RestConnectorMasterTable:
SQL SELECT
"total"
FROM JSON (wrap on) "root";
Qlik Sense
Tried to convert it to Qlik Sense, but it gives a 'HTTP protocol error 400 (bad request)' error:
LIB CONNECT TO 'Eloqua (API_Test)';
RestConnectorMasterTable:
SQL SELECT
"total"
FROM JSON (wrap on) "root"
WITH CONNECTION
(url "https://secure.p01.eloqua.com/api/REST/2.0/assets/campaigns;timeout=30;method=GET;autoDetectResponse..."; );