@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.