Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
twanqlik
Creator
Creator

Qlikview --> Rest API Connection including a parameterized URL

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..."; );

0 Replies