Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Highlighted
Support
Support

Re: REST API - Help connecting to Twitter please?

Hi Lars.

Please have a look atProblem with Authorization token in Google Analyticswhich may help you resolve your issue.

Best,

Bjorn

Partner
Partner

Re: REST API - Help connecting to Twitter please?

Thanks Björn

Your reply resolved my issue.

Best regards

Lars

Partner
Partner

Re: REST API - Help connecting to Twitter please?

 

Hi Björn

 

 

I ran into another issue. I need variables in the URL. I created vURL and added it in “WITH CONNECTION”. This is not working. 

 

 

Please help

 

Lars

 

 

 

LET vURL = 'https://www.googleapis.com/analytics/v3/data/ga?ids%2ga%%3A98567028&metrics%2ga%%3Atransactions%%2Cg... date(now(),'YYYY-MM-DD') & '&end-date%2' & date(now(),'YYYY-MM-DD');

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;
timeout=30;
method=GET;
autoDetectResponseType=true;
keyGenerationStrategy=0;
useWindowsAuthentication=false;
useCertificate=No
certificateStoreLocation=CurrentUser;
certificateStoreName=My;
PaginationType=None;
XUserId=DKFeeDB;
XPassword=JLSOaMB;
"
;

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"name",
"columnType",
"dataType",
"__FK_columnHeaders"
FROM "columnHeaders" FK "__FK_columnHeaders"),
(SELECT
"ga:transactions",
"ga:transactionRevenue",
"__FK_totalsForAllResults"
FROM "totalsForAllResults" FK "__FK_totalsForAllResults")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION ( 
URL "$(vURL)",
HTTPHEADER  "Authorization" "Bearer $(vAccessToken)" 

;  

 

 

Partner
Partner

Re: REST API - Help connecting to Twitter please?

Please disregard the last question. It is working there is a typo in the vURL. I was missing the last " '  ".