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

Your Points Tracker
Challenges
Leaderboard
  • 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
Recognition
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?
Kudos
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

Downloading XML export

I have successfully extracted a number of documents we have in Jira Work Management and parse the XML and put data into an access database to make some queries and reports.

Now I want to automate the XML download. I have found some VBA code but I cannot authenticate and successfully login.

1 comment

I am trying now with JSON ], but, I can pull the data on the browser and it returns me the JSON document - so this is fine, but when do it programmatically it tells me I have no permissions.

here is my code:

Set myReq = CreateObject("WinHttp.WinHttpRequest.5.1")
myReq.Open "GET", "https://{my server}/rest/api/2/issue/BI-2393"
myReq.send

Debug.Print myReq.responseText

I get this error:

{"errorMessages":["Issue does not exist or you do not have permission to see it."],"errors":{}}

I think you'll need some type of authentication on the Jira side to allow the API access your instance.

Perhaps I should ask these permissions to the managers. Thanks for the tip...

@Gustavo Miller 

For the REST API calls, you need to pass in the authentication details in the payload.

from the code snippet, it is not apparent that you have passed the authentication creds (username, password/API token)

 

The error denotes that you are trying to access the link with anonymous user and this operation is not permitted for non authenticated users.

Indeed, you are right. I think I am starting in the wrong way. i think I need to read some more about the different services and how things work, before I can jump into developing applications to talk to JIRA.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Jira Work Management

Jira Work Management FAQ

Welcome to the Jira Work Management FAQ We're glad you're here. If you haven't already, watch our video to get a one-minute overview of Jira Work Management. Check out some basic technical and logi...

7,046 views 50 25
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