Trouble authenticating API request in Table from JSON macro

mwilder May 24, 2021

I've had success with most features and macros in the Table Filter and Charts product, including simple API requests where the auth token is in the URL. However, For requests that require a basic auth header, I always get a 401 unauthorized error in the response. I can test my request in Postman without issue. I'm trying to use the "custom" header and using variations of basic mytoken or authorization: basic mytoken... But so far I haven't found the trick to getting this to work. I've whitelisted the source urls too. I'm not sure what I could be missing or if this is a bug.

2 answers

1 accepted

0 votes
Answer accepted
mwilder May 27, 2021

For me the solution was using my token which typically would reside in the username field of a basic auth header with a colon at the end was to use the token with a colon at the end, convert it to base64 and use that in the custom header option of the macro.

2 votes
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 25, 2021

Hello @mwilder,

Did you try to enter login and password into the Table from JSON macro?

If this doesn't work, please tell me more about the request and authentication you use in the Postman. Or you can contact Stiltsoft support.

mwilder May 25, 2021

Hello @Andrey Khaneev _StiltSoft_ ,

Yes, I've also tried the username and password option, filling in only the field for username with the token. I've tried every format I can think of including ending the token with a colon, or not, using both kinds of authentication headers available.

 

The API I am attempting to request data from is documented here:

https://developers.cloudability.com/docs

And the request I am submitting is a simple one, retrieving a short list of vendors:

https://api.cloudability.com/v3/vendors

 

The application provides a basic auth token to be used. When I set it up in Postman I select basic auth and enter the token into the username field.

 

What Postman generates for the request is as follows:

curl --location --request GET 'https://api.cloudability.com/v3/vendors' \--header 'Authorization: Basic MyToken' 

Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 25, 2021

Did you try to set a custom auth header and enter Basic MyToken in the input?

mwilder May 25, 2021

Yes I have, I expect that would be the method which would succeed but I still encounter an error. Are there configurations or settings in Confluence that are required to enable this which could be interfering? 

Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 25, 2021

Please, create a support ticket where we'll continue the investigation of the issue. I think a call with screen sharing will be more productive in this case.

mwilder May 25, 2021

Ticket created     TFCS-374

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events