Hi
New Alteryx user here! Just dipping my toe into the world of workflows and I have to say I like it so far!
I'm trying to get some CRM data from an Auth0 Rest API, and searched the community and found this Zoom rest API into Alteryx as a possible solution to get the bearer token
Not sure if I've gone down a rabbit hole but I've done the following
When I'm back into Alteryx (Non-Admin Designer) Version: 2021.3.1.47945, the Jupyter notebook doesn't open. I have try
My question is, do I need to use Python to obtain the Bearer Token for API call or is there a different way to do it? If I do need python then why doesn't the notebook open - have I missed some configuration option.
At the moment my workflow only consists of Python tool, so not much to share.
I have managed to connect Alteryx to the Public API and process the JSON data into a usable form....
Any suggestions or signposting.
Thank You
Mark
Solved! Go to Solution.
hey @MarkBurns !
Quite a cool workflow you're working on!
Couple of questions here so i'll try to cover as much as i can methodically.
1) do I need to use Python to obtain the Bearer Token for API call or is there a different way to do it?
2) If I do need python then why doesn't the notebook open - have I missed some configuration option.
Hope this helps!
TheOC
Thank TheOC
Yeah really excited about the potential of Alteryx and how I can use it to pull student engagement data (work in Higher Education) join that with Academic data and then present the whole out into an interactive Tableau dashboard!
This is the sample Notebook
Thanks for the link, I'll have a read after I grab a cuppa and suspect that the issue that I'm using a corporate network and something funky is happening in the background - might be my VPN thinking about it!
Cheers
Mark
hey @MarkBurns
Yeah the download tool still is one of the most impressive tools to me. Its just nice opening doors to API connections in a shareable, easy to use format in the sense of Alteryx. Showing someone code who has never used code before is a difficult task.
Also yeah thats curious, you might well be right with VPN issues - i believe it mentions VPN/proxy as a potential issue within the article. Let me know how you get on!
Cheers,
TheOC
Ok will do, had a brew and looked at ..
Worked though that guide and still no joy!
So I think either the Juypter extension in Alteryx hasn't been installed correctly or it might not be there alternatively so thing else that I'm not sure how to check for.
Looking at the CMD from Jupyter I can see that activity happens when I browse the webpage but nothing when I click on the Python tool, which makes me suspect that Alteryx isn't even making the call.
Feels like I missing something obvious although I am a bit out of my depth here.
Mark
One quick note with the Download tool - which more knowledgeable people ( @TheOC @BrandonB et al) may chime in on - I find connecting via Postman and then recreating the connection parameters EXACTLY really helps. This means getting the raw Curl from Postman and hardcoding whatever values (content_type, host, etc...) until you get it to work.
@apathetichell postman has saved me atleast a headache a month 😁 Definitely +1 to that method!
So do you think that I could split the process into two functions both using download tool?
1 - Download the bearer token
then pass it to
2 A separate download tool?
Mark
Hey @MarkBurns
Sorry to hear you're still having problems with the Python tool.
I've seen a couple other things on the community saying run as administrator, or reinstalling Alteryx might fix.
I'll try to have another look and get back to you!
hey @MarkBurns
thats the main way I've seen it done before, and given your ongoing issues.
Theres quite a few posts on it too:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/API-s-Download-Tool-and-Basic-Auth-Oh-...
https://community.alteryx.com/t5/Engine-Works/REST-APIs-Part-2-Authentication/ba-p/12640
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/API-Basic-Authorization/td-p/749357
try not to get too 'lost in the sauce' however 😁.
Hope it helps,
TheOC