Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Create a record using API via VBA

Is there a way to create a JIRA record using API (post) via VBA??

Perhaps a sample would be great!

1 answer

0 votes
DPK J Community Leader Sep 19, 2021

@Gustavo Miller this is for sure possible.

As sample you take some inspiration from this post - https://ashuvba.blogspot.com/2014/08/excel-vba-json-rest-with-jira-json-is.html

 

Also, if you can find better library for VBA to call rest api you can use that as well. Documented here - https://medium.com/automation-generation/using-vba-and-excel-to-make-authenticated-requests-for-alpacas-trading-api-2968acaa3776

Sorry for the tardiness, it is been very busy at work. I will look at this.

DPK J, I was wondering if you can share a sample of a JSON string. Due to the number of double-quotes, building the string can be quite challenging.

This is what I gather from the samples:

{“fields” :
      {
           “project” : { “key” : “@KEY@” } ,
          “issuetype” : { “name” : “@IssueType@” }
      }
}

I am assuming that the 'at' signs at NOT part of the string; guess in there I replace with my data. If you can help I would appreciate very much.

DPK J Community Leader Sep 27, 2021

Here is sample curl that I use

curl --request POST \
--url 'https://<DOMAIN>.atlassian.net/rest/api/3/issue' \
--user '<YOUR_EMAIL>:<API_TOKEN>' \
--header 'Accept: application/json' \
--header 'Content-Type: application/json' \
--data '{
"fields": {
"summary": "Issue summary",
"issuetype": {
"id": "10000"
},
"project": {
"id": "10000"
}
}
}'

 

On data, sure you need to replace `@`, and data itself is JSON string. So for this you can use any library that has 'stringify' function. For example this - https://github.com/VBA-tools/VBA-JSON

Here you create dictionary and collection and then convert that to json string, which is much more easier than directly writing json string.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Work Management

Lessons from Vilius Zigmantas’ path to Continuous Process Improvement at GeoComply

  “Organizations are made of people who create and follow processes which are constantly changing and are in need to be supported and nurtured… this is the spot where I realized I can br...

1,730 views 9 19
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