community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

get data from API OAuth 2.0

shareef2
7 - Meteor
‎11-17-2021 11:16 PM

Hi Team,

 

I would like pass ID to API an get data. below are the details i received from API team.

 

 

Grant Type: Client Credentials
Access Token URL: https://123.com/apex/epex/oauth/token
Client ID: ..xxx..
Client Secret: ..yyy..
Client Authentication: Send as Basic Auth header

 

==ENDPOINT==

https://123.com/apex/epex/?parameter

 

where "parameter" is the ID to get data.

 

i have tried multiple option in download tool . but can not connect to API. can you please help

 

Thanks 

Sha

 

 

 

to supplement further, here is how we are connecting from POSTMAN

 

shareef2_0-1637228843118.png

 

Tried this option --> error : 401 - Unauthorized: Access is denied due to invalid credentials

shareef2_0-1637232089479.png

 

shareef2_3-1637232149418.png

 

shareef2_4-1637232168349.png

 

 

 

 

 

Labels:
Reply
0 Likes
10 REPLIES 10
shareef2
7 - Meteor
‎11-18-2021 01:48 AM

to supplement further, here is how we are connecting from POSTMAN

shareef2_0-1637228889060.png

 

Reply
0 Likes
patrick_digan
17 - Castor
17 - Castor
‎11-18-2021 05:56 AM

@shareef2 I don't know postman that well, but you should be able to have it give you the curl request that is actually being sent. Postman is showing easier to read names like "Grant Type". In alteryx, I believe you would need that to be "grant_type". The curl from postman should give you everything you need. In looking at the items you're sending in alteryx, I would make these changes: 

Change Client ID to client_id

Change Client Secret to client_secret

Change Grant Type to grant_type

Remove Token Name and Client Authentication (I don't think they're necessary but not sure).

 

The server should then respond with your access token. Then you would hit the actual endpoint (https://123.com/apex/epex/?parameter) and this time you would presumably have a field called "Authorization" and the value should be "Bearer your_token_from_step1" (so "Bearer aoeust23123eouaoue12" for example). You would no longer need to send the client id, secret, or grant_type.

 

Hope that helps!

 

 

Reply
shareef2
7 - Meteor
‎11-22-2021 07:18 PM

@patrick_digan  thnx. i will try these options next week and update you. 

 

Thanks again for the details. 

 

Reply
0 Likes
shareef2
7 - Meteor
‎11-25-2021 10:31 PM

@patrick_digan 

Hi, I tried these options:

shareef2_0-1637908138887.png

 

the responce is :

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>401 - Unauthorized: Access is denied due to invalid credentials.</title>

 

but with same client_id & secret i can connect from postman.

 

is there any other way to send id/secret ?

 

Reply
0 Likes
shareef2
7 - Meteor
‎11-25-2021 10:36 PM

POSTMAN log:

shareef2_0-1637908575430.png

 

Reply
0 Likes
apathetichell
20 - Arcturus
‎11-25-2021 10:50 PM

are you using the base-64 encoder? Postman does this for you - with Alteryx you need to encode your client id/client secret yourself via the base 64 encoder tool. For a test run - take what you have in postman and recreate it EXACTLY in Alteryx. It should work - if not you  haven't recreated it exactly. Make sure you hard code your content-type etc...

Reply
0 Likes
shareef2
7 - Meteor
‎11-25-2021 11:07 PM

@apathetichell  

Hi , as suggested i have used encoder but still same issue.

shareef2_1-1637910457627.png

 

Reply
0 Likes
shareef2
7 - Meteor
‎11-25-2021 11:18 PM

Tried same options as postman: same error

 

shareef2_0-1637911086555.png

 

Reply
0 Likes
patrick_digan
17 - Castor
17 - Castor
‎11-29-2021 06:27 AM

@shareef2 Which endpoint are you having errors with (https://123.com/apex/epex/oauth/token or https://123.com/apex/epex/?parameter). You mentioned both in your initial post.   

Reply
0 Likes
Community Live
Live Cloud Quest Solve
Labels
Top Solution Authors
View All