Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

QLik Sense Business (ex Cloud) + GitHub

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.

5 Replies
Highlighted
Contributor III
Contributor III

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.
Highlighted
Creator
Creator

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!

 

Highlighted
MVP & Luminary
MVP & Luminary

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

-Rob

Highlighted
Creator
Creator

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

 

Highlighted
Specialist
Specialist

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