topic Re: QLik Sense Business (ex Cloud) + GitHub in Connectivity & Data Prep

QLik Sense Business (ex Cloud) + GitHub

alexandernatale — Fri, 02 Apr 2021 08:50:33 GMT

Good morning,

I need to connect to a repository on github to download data periodically.

Can anyone give me some tips? I tried with the connector on QLik but I can't use it.

Help me, please.

Thanks.

Re: QLik Sense Business (ex Cloud) + GitHub

qliksrikanth — Tue, 25 Feb 2020 12:57:15 GMT

Hi, can you please go through this https://help.qlik.com/en-US/connectors/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_QWC_BuiltIn/Introduction/Creating-a-connection.htm link and let me know if its helpful.

Re: QLik Sense Business (ex Cloud) + GitHub

alexandernatale — Tue, 25 Feb 2020 13:07:25 GMT

Thanks @qliksrikanth for the reply!

I read the online guide but i don't know which option to use to link directly to a file containing data that is periodically updated.

My goal is to connect to a specific repository file that is updated daily in order to always have the dashboard updated on Qliksense Business (ex cloud)

thanks for help!

Re: QLik Sense Business (ex Cloud) + GitHub

rwunderlich — Tue, 25 Feb 2020 16:01:48 GMT

Do you want to get repo metadata (e.g. commits, stats) or load specific files in the repo (e.g. src/myfle.js)?

-Rob

Re: QLik Sense Business (ex Cloud) + GitHub

alexandernatale — Tue, 25 Feb 2020 22:41:11 GMT

Hello @rwunderlich and thanks for the reply!

What i would like to do is connect a specific .csv located in a github repository.

For example (Coronavirus data):

CSSEGISandData/COVID-19/archived_data/archived_time_series/time_series_2019-ncov-Confirmed.csv

Re: Qlik Sense Business (ex Cloud) + GitHub

chrisbrain — Tue, 14 Apr 2020 08:07:55 GMT

This isn't supported with the current GitHub connector (although we are aware that this would be useful).

It looks like there is a workaround though using the REST connector which I just tried and will explain below.

1) Create a personal access token in GitHub (https://help.github.com/en/github/authenticating-to-github/creating-a-personal-access-token-for-the-command-line) - I think this needs to have the 'repo' scope selected. Take a copy of this token before GitHub hides it.

2) Find the CSV file you want to load in GitHub and click the 'Raw' button to get the URL to the raw CSV file. Take a copy of this URL BUT remove the token=XXXXX part at the end.

3) In Qlik Sense, create a REST connection using the URL from step 2).

4) In the connection dialog, add a Query header with name 'Authorization' and value 'token PERSONAL_ACCESS_TOKEN' where PERSONAL_ACCESS_TOKEN is the value from step 1).

You should now be able to save the connection and then select data from the underlying file. I tested this with an XML file but CSV should be the same. If this is a public repo you can likely skip step 1).