Creating automation script

1. Open the Automation Scripts application.
2. On the navigation panel, click Create and select Script with Object Launch Point.
3. On the Create Script with Object Launch Point : Step 1 of 3 pop-up, fill the fields as follows:
   • Launch Point: Specify the launch point name, for example, INCIDENTTEST.
   • Object: Search for the INCIDENT object and select.
   • Object Event Condition: Fill below condition in this box:
     • :createjiraticket=1 and :jiraendpoint!="
       Note: createjiraticket and jiraendpoint are the names of the attribute created in Adding Attribute in Incident Application.
   • Click the Save button, check the checkbox for the Update?, and click After Save button.
   • Click the Next.
4. On the Create Script with Object Launch Point : Step 2 of 3 pop-up, fill the fields as follows:
   • Script: Specify as jython
   • Script Language: Search and select jython
   • Log Level: Search and select Debug
   • Click Next
5. Save the below code as a JSON file and save it in your directory such as C:\Users\Administrator\Documents\priority_mapping.json.
   Note:

   • The below is the sample JSON code, update the code as per your JIRA server.
   • Make sure that this same JSON file directory is mentioned in the below step 6 script as necessary.

   {
   1:10000,
   2:2,
   3:3,
   4:4,
   5:10001
   }

6. On the Create Script with Object Launch Point : Step 3of 3 pop-up, fill the script box with the below script, and click Create
   Note:

   • The below script is a sample and for reference only, update the script as per your custom field ID's and other changes as necessary.
   • The priority_mapping.json file directory must be the same in below script as you save the JSON file in the above step 5.
   • The custom filed ID's in the below script must be same as it was generated in Creating custom fields in JIRA.

{
"Done":"CLOSED",
"Pending":"QUEUED",
"Work in progress":"INPROG",
"Open":"NEW"
}

1. Go to the Automation Scripts application.
2. On the left-hand side navigation panel, click Create and select Script.
3. On the Create Script pop-up, fill the fields as follows:
   • Script: Specify the script name such as UPDATEINCIDENT
   • Script Language: Search and select jython
   • Log Level: Search and select Debug
   • Fill the script box at the bottom of pop-up with the below script and click Create.
     Note:

     • The below script is a sample and for reference only, update the script as per your custom field ID's and other changes as necessary.
     • The status_mapping.json file directory must be the same in the below script as you saved the JSON file in the prerequisite above.
     • The custom filed ID's in the below script must be same as it was generated in Creating custom fields in JIRA.

     # Copyright (C) Altran ACT S.A.S. 2021.  All rights reserved
     # This script is used to update icd incident when an update is being triggered from jira.
     
     from java.util import Calendar
     from org.python.core import PyTuple
     
     #from org.json import JSONObject
     
     from java.io import BufferedReader, IOException, InputStreamReader, BufferedInputStream
     from java.lang import System, Class, String, StringBuffer, Integer
     from java.nio.charset import Charset
     from java.util import Date, Properties, List, ArrayList
     
     from org.apache.commons.codec.binary import Base64
     from org.apache.http import HttpEntity, HttpHeaders, HttpResponse, HttpVersion
     from org.apache.http.client import ClientProtocolException, HttpClient
     from org.apache.http.client.entity import UrlEncodedFormEntity
     from org.apache.http.client.methods import HttpGet
     from org.apache.http.entity import StringEntity
     from org.apache.http.util import EntityUtils
     from org.apache.http.impl.client import DefaultHttpClient
     from org.apache.http.message import BasicNameValuePair
     from org.apache.http.params import BasicHttpParams, HttpParams, HttpProtocolParamBean
     
     from com.google.gson import JsonObject, JsonParser, JsonElement
     
     from psdi.mbo import Mbo, MboRemote, MboSet, MboSetRemote
     from psdi.security import UserInfo
     from psdi.server import MXServer
     from psdi.mbo import SqlFormat
     from psdi.mbo import MboConstants
     from sys import *
     
     def getICDStatus(jira_status):
         status = ""
         # read mapping file
         with open('C:\Users\Administrator\Documents\status_mapping.json', 'r') as myfile:
             data=myfile.read()
         
         # converting string to json
         final_dictionary = eval(data)
         
         status = final_dictionary.get(jira_status)
         return status;
         
     def getICDPriority(jira_priority):
         priority = ""
         # read mapping file
         with open('C:\Users\Administrator\Documents\priority_mapping.json', 'r') as myfile:
             data=myfile.read()
         
         # converting string to json
         final_dictionary = eval(data)
         
         # converting string to json
         final_dictionary = eval(data)
         for key, value in final_dictionary.items():
             if jira_priority == value :
                 return key;
                 
         return priority;
     
     def getJsonValue(val):
         
         if val.isJsonPrimitive():
             p = val.getAsJsonPrimitive()
             if p.isString():
                 return p.getAsString()
             if p.isBoolean():
                 return p.getAsBoolean()
             if p.isNumber():
                 return p.getAsNumber().intValue()
         else:
             return
         
     def invokeUpdateMbo():
         #set content-type here
         responseHeaders.put("content-type","application/json")
             
         #convert request body to json object
         jsonElement = JsonElement
         jsonObject = JsonObject
         try:
             jsonElement = JsonParser().parse(requestBody)
             jsonObject = jsonElement.getAsJsonObject()
         except:
     	    System.out.println('error while parsing json')
     	    
         # ticket uid 
         ticketuid = jsonObject.get('fields').get('customfield_10200')
         
         # read mapping file
         with open('C:\Users\Administrator\Documents\incident_icd_jira_mapping.json', 'r') as myfile:
             data=myfile.read()
         
         # converting string to json
         final_dictionary = eval(data)
         
         #get incident mbo
         ticketSet = MXServer.getMXServer().getMboSet("TICKET", request.getUserInfo());
         format = SqlFormat("ticketuid=:1");
         
         format.setObject(1, "TICKET", "ticketuid", getJsonValue(ticketuid));
         ticketSet.setWhere(format.format());
         ticketSet.reset();
         
         incidentMbo = ticketSet.getMbo(0);
         
         #iterate json object
         jsonObject1 = jsonObject
         for key, value in final_dictionary.items():
             
             temp = value
             arr = temp.split(".")
             val = ""
             length = len(arr)
             for i in arr:
                 if length == 1:
                     val = jsonObject.get(i)
                 
                 else :
                     tempjson = jsonObject.get(i)    
                     jsonObject = tempjson
                 
                 length = length -1
             
             jsonObject = jsonObject1
             incidentMbo.setValue(key, getJsonValue(val), MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
             
         jira_status = jsonObject.get('fields').get('status').get('name')
         icd_status = getICDStatus(getJsonValue(jira_status))
         
         if icd_status == '':
             System.out.println( 'icd_status is empty')
         else :    
             incidentMbo.setValue('STATUS',icd_status,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
         
         jira_priority = jsonObject.get('fields').get('priority').get('id')
         icd_priority = getICDPriority(getJsonValue(jira_priority))
         incidentMbo.setValue('REPORTEDPRIORITY',icd_priority,MboConstants.NOACCESSCHECK | MboConstants.NOVALIDATION_AND_NOACTION)
         
         #save incident mbo
         incidentMbo.getThisMboSet().save();
     
     # Main part
     invokeUpdateMbo()