Updating a custom Jira field from Excel using API

[ianvanzyl]

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