Updating a custom Jira field from Excel using API

ianvanzyl September 23, 2021

Hi there

I am trying to update a specific field in Jira using the Jira API through Excel Power Query and I am not having much success.

 

Issue key: CRTP-42
id = 234543
custom_field_18470 = CRTP-Priority

 

I wish to update the custom field "CRTP-Priority" on issue key "CRTP-42" with the value of "Oct-21"

 

This is the HTML that is generated but it gives a 404 error

https://jira_server_url/rest/api/2/issue/234543/%7B"update":%7B"fields":%7B"customfield_18470":"Oct 21"%7D%7D%7D

(same URL as above but hex codes replaced)
https://jira_server_url/rest/api/2/issue/234543/{"update":{"fields":{"customfield_18470":"Oct 21"}}}

 

Please could someone assist with the necessary Power query code to achieve the above

 

Thanks in advance

 

Regards

 

0 answers

Suggest an answer

Log in or Sign up to answer