Reading SQL Scripts from Github

[kirantadi]

Hello Community,

Has anyone able to read SQL scripts from GITHUB. I am trying to read the SQL scripts from using the REST APIs. But for some reason when i use JSON tool I dont see any data coming through the download tool. Can anyone please help me with this, i tried searching community posts to find a solution but couldnt find any. I am attaching the images with the complete information on the alteryx workflow i am building. Any help would be appreciated.

[bbak91]

Can you add a browse after the download tool and double click on the cell under the Download Data column in the results window? You should be able to see if there is additional information in the cell. 

[kirantadi]

Hi BrandonB,

Thanks for the reply. All i am seeing is a HTML text in the download data. Not sure if this is what it is expected.

Please see the screenshot below

[bbak91 · Accepted solution]

I am thinking you may be pointed at a webpage instead of an API endpoint. Here is a great article on getting started with APIs in Alteryx: https://community.alteryx.com/t5/Engine-Works/REST-API-In-5-Minutes-No-Coding/ba-p/8137 

And here are the endpoints that are available for GitHub Apps: https://docs.github.com/en/rest/overview/endpoints-available-for-github-apps 

If you are still sure that your endpoint is correct, try adding this to the Header tab:

Name                              Value

Content-Type            application/json