Access to Keboola system through REST API

Question

Hi all ... I have credentials to access Keboola but facing issues to translate the commands into Power Query. I tested the options in browser (by the documentation) and it is working (response=200 from API) but facing problems in Power BI.

Anyone with experience in this system who could share some knowledge?

dax · Answer

Hi&nbsp;gdecome&nbsp;,&nbsp;
You said that you have problem&nbsp; when&nbsp; connect to powerbi, so if possible, could you please inform me more detailed error information? Then I will help you more correctly. In addition, you also could post this problem in&nbsp;Keboola&nbsp; forum for more suggestions.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

gdecome · Answer

Hi, after more tests I could get the record that I´m looking for. For now it is working. I will use the Keoola forum as well for some help. Thank you very much for now.

gdecome · Answer

Hi&nbsp;dax,&nbsp;my Power Query is working to access the APIs but in the last step, when I need to get the csv file, I don´t know how to create the code to get if from s3 bucket. I can get the Credentials and s3Path information (see below) but not sure how to use them to get the file.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "credentials": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"AccessKeyId": “ACCESSKEY”,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"SecretAccessKey": “SECRETACCESSKEY”,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"SessionToken": “SESSUIBTOKEN”,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"Expiration": "2020-02-01T06:00:16+00:00”&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"s3Path": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"bucket": "kbc-sapi-files”,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;"key": "exp-30\/123\/table-exports\/out\/c-test\/my_accounts\/1234.csv”&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }

Forum Discussion

Access to Keboola system through REST API

3 Replies

Related content

SharePoint Access

Dashboard Access

Connection Access

Mobile app access blocked

Accessing one lake