QLik Sense Business (ex Cloud) + GitHub

[alexandernatale]

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.

[qliksrikanth]

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

[alexandernatale]

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!

[rwunderlich]

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

-Rob

[alexandernatale]

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

[chrisbrain]

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