Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

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
qliksrikanth
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.
alexandernatale
Creator II
Creator II
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator II
Creator II
Author

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
Partner - Specialist II
Partner - Specialist II

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense