Working with JSON Data

We've encountered an issue exporting this macro. Please try exporting this page again later.

As happens from time to time, you will want to work with JSON data. For example, when passing JSON data when using httpPut() or httpPost().

Background

In this example, I will be using the this REST API example from the Atlassian Community.

Method 1 - Add JSON Data Inline

As is shown in the example, we start with the example JSON that will be used to input.

"properties": [
   {
    "key": "sd.public.comment",
    "value": {
       "internal": true
    }
   }
  ]
}

Overview

Use the Find/Replace feature of the SIL Manager to add an escape character before every quote.
Surround each line with quotes and place a plus sign at the end.
Set the newly formatted JSON to a string variable and put a semicolon at the end.

Step 1 - Add an Escape Character before Every Quote

Use the Find/Replace feature of the SIL Manager to add an escape character before every quote.

Step 2 - Place Quotes Around Each Line

Surround each line with quotes and place a plus sign at the end. Place a semicolon at the end.

Step 3 - Set the Formatted JSON to a String Variable

Set the entire code block to a string variable so that it can be passed into the REST endpoint.

string updateInfo = "{" +
                        "\"properties\": [" +
                            "{" +
                                "\"key\": \"sd.public.comment\"," +
                                "\"value\": {" +
                                    "\"internal\": true" +
                                "}" +
                            "}" +
                        "]" +
                    "}";
                     
runnerLog(updateInfo);

Step 4 - Print Output and Check for Accuracy

The output should match the original JSON from the beginning.

Step 5 - Change Desired Hard-Coded Values to Accept Variables

Add a variable and use plus signs to concatenate it to the existing string values. Again, the output should match the original JSON from the beginning.

The Final Script

Below we use httpPut() to pass the "updateInfo" values to update the Service Desk value "isPublic" to false.

string isPublic = "false";
number [] ids = getAllCommentIds(key);
number lastComment = ids[size(ids) -1];
 
 
string updateInfo = "{" +
                        "\"properties\": [" +
                        "{" +
                        "\"key\": \"sd.public.comment\"," +
                        "\"value\": {" +
                            "\"internal\": " + isPublic + "" +
                        "}" +
                        "}" +
                        "]" +
                    "}";
 
 
HttpRequest request; 
request.headers += httpCreateHeader("Content-Type", "application/json"); 
request.headers += httpBasicAuthHeader("admin", "admin");  
 
string result = httpPut("http://localhost:8080/rest/api/3/issue/" + key + "/comment/" + lastComment, request, updateInfo);
 
// runnerLog(result);
 
number statusCode = httpGetStatusCode();
if (statusCode >= 200 && statusCode < 300) {
    runnerLog("SUCCESS");
}
else {
    string msg = trim(statusCode) + ":" + httpGetErrorMessage() + ":" + httpGetReasonPhrase();
    runnerLog(msg);
}

Additional Help

Need help implementing this script? Talk to me directly to me by clicking on the bot on this page.