Excellent tutorial; really helped me with how to get data from an API and transpose the content into the format that I need. The pace, depth and methodology of your delivery is "just right". Slow enough to follow and fast enough to be efficient and keeping the focus all the time. Great presentation technique.
Thanks so much Nathan. This is awesome. You made it so easy. I am looking forward to do a class project that involves drawing time series correlations between different asset classes. I could use your approach for automating and iterating between all those publicly available data.
Thank you for another easy-to-follow post Nathan. I don't have particular scenario in my current work where I could apply this but regardless, it's good to keep watching your Alteryx videos as it helps me familiarise myself more and more with the software. If I may ask, is the main purpose of the "Browse" tool just to see what your data look like in Alteryx?
Thanks for the comments Kleanthis! Yes, the main purpose of the browse tool is to view data. You can also filter and sort the data then add the filter and sort tools from the browse tool. It is really handy. Check my video on how that works here: th-cam.com/video/o11eUDRGYFg/w-d-xo.html
Hi Neelima, there are a couple was to get data from desktop apps. If the app is storing data in a database, of course, the best way is to connect to that database. If you can't get access to the underlying database, then you could schedule reports or exports out of the desktop application. If that's not an option, then you move on to something like UiPath, Automate Anywhere, or Power Automate to try and pull data out of the desktop app. Alteryx has connectors to all three of the platforms I just mentioned.
Hi Nathan...i have a workflow where i use two server api tools one is to get all workflows list and the other is to match the users list wrto the workflows and i join these two with a join tool and a browse tool at the end..i get the required data but how to download this to a file like xlsx...
Hi there Sagar, try the link below. There are additional articles on the Community that address headers: community.alteryx.com/t5/Alteryx-Designer-Discussions/Setting-up-download-tool-with-oauth-token/td-p/91084
Excellent video and very helpful!!. Thanks a ton. Will be interesting to also see how to POST data to API using alteryx.
agree
Excellent tutorial; really helped me with how to get data from an API and transpose the content into the format that I need. The pace, depth and methodology of your delivery is "just right". Slow enough to follow and fast enough to be efficient and keeping the focus all the time. Great presentation technique.
Thanks for the kind comment, Graeme!
Thanks so much Nathan.
This is awesome. You made it so easy.
I am looking forward to do a class project that involves drawing time series correlations between different asset classes. I could use your approach for automating and iterating between all those publicly available data.
You're very welcome! The class project you're working on sounds great.
Your videos are so helpful. Thanks so much for taking the time to make them!
Glad you like them!
Thanks man. Really appreciate this session. Going to implement it today!
You're welcome, Anurag. Glad it was helpful!
Thank you Nathan, the video is very helpful! Do you also have got a video which shows an API-Download with an OAUTH2 accesstoken?
Thank you Nathan, I love your videos!
Thanks, Cathy. Glad to hear it! 👍👍
Great video Nathan! Are you planning to make a REST API with OAuth 2.0 video anytime soon? Thanks!
Thank you for another easy-to-follow post Nathan. I don't have particular scenario in my current work where I could apply this but regardless, it's good to keep watching your Alteryx videos as it helps me familiarise myself more and more with the software. If I may ask, is the main purpose of the "Browse" tool just to see what your data look like in Alteryx?
Thanks for the comments Kleanthis! Yes, the main purpose of the browse tool is to view data. You can also filter and sort the data then add the filter and sort tools from the browse tool. It is really handy. Check my video on how that works here: th-cam.com/video/o11eUDRGYFg/w-d-xo.html
Very helpful.. Thanks a lot for the explanation.
Glad it was helpful!
Your videos are amazing!!.Ateryx can connected to desktop applications to post and retrieve data?
Hi Neelima, there are a couple was to get data from desktop apps. If the app is storing data in a database, of course, the best way is to connect to that database. If you can't get access to the underlying database, then you could schedule reports or exports out of the desktop application. If that's not an option, then you move on to something like UiPath, Automate Anywhere, or Power Automate to try and pull data out of the desktop app. Alteryx has connectors to all three of the platforms I just mentioned.
thanks for nice explanation, can explain any health care project
Hi Nathan...i have a workflow where i use two server api tools one is to get all workflows list and the other is to match the users list wrto the workflows and i join these two with a join tool and a browse tool at the end..i get the required data but how to download this to a file like xlsx...
Super helpful. Question. Is it possible to POST a PFX Cert file and API key like you can in CURL using this Download tool?
Hi Brian, I just went through a similar process myself. I found it easier to use cURL with the Run Command Tool, instead of using the Download tool.
@@NPT I wonder if there is a way to too use both tools to make that possible, sounds like its the Run command tool? Thanks for your response.
@@BrianGarside Yep, the Run Command tool is like mortar to a brick. It can hold the workflow together when other tools are a bit too finicky.
excelent video, thank you a lot, it helped me very much!
You're welcome!
Hi Nathan, I want to make a token API call first to obtain the authcode and then the file. Can you suggest the best way to do this
Great job !
my friend, what happen if we need to iterate the workflow ?
beacuse it shop up 1000 line, but i have 15000, what should i do ?
regards.
Thank you Nathan
You're welcome Ami!
Can anyone tell me why this altreyx website is not working?
how do i apply access token and secret token key in headers?
Hi there Sagar, try the link below. There are additional articles on the Community that address headers:
community.alteryx.com/t5/Alteryx-Designer-Discussions/Setting-up-download-tool-with-oauth-token/td-p/91084
Please demo uoath 2.0