Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Trouble authenticating API request in Table from JSON macro

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

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.

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.

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:

And the request I am submitting is a simple one, retrieving a short list of 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 '' \--header 'Authorization: Basic MyToken' 

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

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? 

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.

Ticket created     TFCS-374

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

☕️ Monday coffee with Jexo: Weekly Atlassian news roundup | 21st June 2021

Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...

59 views 0 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you