Forum Discussion

gdecome's avatar
gdecome
Icon for Helper III rankHelper III
6 years ago

Access to Keboola system through REST API

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 fr...
Need Help
gdecome's avatar
gdecome
Icon for Helper III rankHelper III
6 years ago

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's avatar
gdecome
Icon for Helper III rankHelper III
6 years ago

Hi dax, 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.

 

            "credentials": { 

                         "AccessKeyId": “ACCESSKEY”, 

                         "SecretAccessKey": “SECRETACCESSKEY”, 

                         "SessionToken": “SESSUIBTOKEN”, 

                         "Expiration": "2020-02-01T06:00:16+00:00” 

             }, 

             "s3Path": { 

                         "bucket": "kbc-sapi-files”, 

                         "key": "exp-30\/123\/table-exports\/out\/c-test\/my_accounts\/1234.csv”

            }