Acess Hub repository files from external platform using URLs

Hello,

We need to access some CSV files stored in the Hub repo from PBI Report Server. Previously, with KNIME Server, this worked using basic authentication (user/pass) in PBI RS with our personal KNIME Server credentials, but with the Hub, the related URL only works if we were previously logged into the Business Hub. We are talking about using a URL in a browser to access a Hub file, e.g:

api.hubdomain.net/repository/Users/commitTeam/Compartido/Historical%20data%20workflows%20running%20per%20day.csv:data?version=current-state

Any suggestions?

Thanks in advance.

This is also possible with KNIME Hub if you are using an application password.

Thanks! Could you please provide an example of this type of configuration??

Ok, we managed to do it by ourselves: In the Hub web interface, Hub user → Settings → Application passwords. Then these app credentials were used to log in when connecting to that CSV URL from PBI RS.

Is there any way to read all CSV files in a repo folder?

Thank you for your support!