How to connect to STATA or Power BI?
Connecting Alphacast to other tools is really simple using the following steps
Find the data you want to connect to your tool and copy the download link
When you navigate through Datasets in Alphacast, you will find a Download link (you have to be logged in). If you filter variables, download links will consider variables selection, and only filtered variables will be downloaded. You will now find an option to download Comma Separated Values (CSV):
Right click on the CSV Download link, and choose "Copy Link Address". You will notice the URL already has your personal api_key, and should not be shared publicly with other users, outside your team.
It will look like this
THE_URL = https://api.alphacast.io/datasets/5288/data?apiKey=YOUR_API_KEY&format=csv
Connecting to STATA
Data can be connected to STATA with a single line
insheet using "THE_URL"
Connecting to Power BI