Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sharmendra Vishwakarma

Sharmendra Vishwakarma

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Jira Legacy
serverSystem JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-140

...

Ariya Krishnan

Setup instance and prepare for demo.

Listener for JIRA attachment  eventsDipesh Chouksey (UnlicensedAP-919APP-15101617
#TaskDescriptionDependent TaskOwnerStart DateEnd DateStatusRemark
1Local Environment SetupInstallation of JIRA SDK, Eclipse Setup0  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-844






2Create ServiceNow InstanceRegister in ServiceNow with empyra email Id0Sharmendra Vishwakarma  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-147
3Connection Screen: Create UIScreen to enter the connection details1Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-148
4Connection Screen: Edit UIScreen to edit the connection details1Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-149
5Connection Screen : Details UIScreen to display the connection details1Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-150
6Create the data model to store the connection detailsCreate database schema for storing the connection details3Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-155
7Business Logic to save/edit the connection detailsImplementation logic to save the connection details6Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-152
8Business logic to test the ServiceNow connectionImplementation logic to test the connection7Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-153
9Business Logic to reset the connectionImplementation logic to RESET the connection7Ariya Krishnan  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-156
10Configuration Screen : Fields mapping JIRA SD and ServiceNowScreen to Mapp the Jira SD and ServiceNow fields5Dipesh Chouksey (Unlicensed)  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-157
11Create data model to store the field mapping in dbCreate database table to store the mapping details10Dipesh Chouksey (Unlicensed)  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-158
12Business Logic to save/edit/delete the configuration detailsImplementation logic to save/edit/delete the field mappings.11Dipesh Chouksey (Unlicensed)  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAPP-161
13Host the Jira Service Desk for ServiceNow ConnectivityAvailability of this will help ServiceNow to connect to Jira SD1214Implement Logger Implementation the logger1,2,3,4,5,6





15Create a listener for JIRA Issue events(Create/Update/Edit) in Jira SD (Create/Update)Need to check the deletion( Feature Not Required)12Sharmendra Vishwakarma  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-898
16Create incident-based on Jira issue creation based on saved mapping   Supported field: Summary, description, Text Field (single line) custom field Dipesh Chouksey (Unlicensed) 
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-915
17Update incident-based on Jira issue creation based on saved mapping   16Dipesh Chouksey (Unlicensed)
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-916
18Listener for JIRA comments events(Create/Update/Edit) in Jira SD (Create/Update)Need to check the deletion( Feature Not Required)15Sharmendra Vishwakarma
 
 
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-899
19
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-928
203Connection Screen: Create UIScreen to enter the connection details





4Connection Screen: Edit UIScreen to edit the connection details





5Connection Screen : Details UIScreen to display the connection details





6Create the data model to store the connection detailsCreate database schema for storing the connection details





7Business Logic to save/edit the connection detailsImplementation logic to save the connection details





8Business logic to test the ServiceNow connectionImplementation logic to test the connection





9Business Logic to reset the connectionImplementation logic to RESET the connection





10Configuration Screen : Fields mapping JIRA SD and ServiceNowScreen to Mapp the Jira SD and ServiceNow fields





11Create data model to store the field mapping in dbCreate database table to store the mapping details





12Business Logic to save/edit/delete the configuration detailsImplementation logic to save/edit/delete the field mappings.





13Host the Jira Service Desk for ServiceNow ConnectivityAvailability of this will help ServiceNow to connect to Jira SD





14Implement Logger Implementation the logger1,2,3,4,5,6




15Create a listener for JIRA Issue events(Create/Update/Edit) in Jira SD (Create/Update)Need to check the deletion( Feature Not Required)





16Create incident-based on Jira issue creation based on saved mapping   Supported field: Summary, description, Text Field (single line) custom field 





17Update incident-based on Jira issue creation based on saved mapping   






18Listener for JIRA comments events(Create/Update/Edit) in Jira SD (Create/Update)Need to check the deletion( Feature Not Required)





Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
key19

Setup instance and prepare for demo.









20Listener for JIRA attachment  events(Create/Update/Edit) in Jira SD (Create/Update)






21Check the API to push the create/update of incident to Jira SDNeed to check to configure outbound message configuration in ServiceNow0Sharmendra Vishwakarma  
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyNeed to check to configure outbound message configuration in ServiceNow





22Setup client instance and support a single select field like priority Dipesh Chouksey (Unlicensed)
Jira Legacy
showSummaryfalse
serverSystem JIRA
serverId6f8446ac-0270-38e8-bfda-78a5daa9d08d
keyAP-934







23

Pushing the update from ServiceNow to Jira

Pull the incident update from ServiceNow and update Jira SD








24Create User Documentation in Confluence






25Test Cases16






26Create OBR for the marketplace






3.2 Data Model


Sl No#Table NameFieldsField TypeDisplay NameDescription
1ao_snow_connidchar(36)Id


namestring(255)Connection URLService Now base URL


date_createddatetimeDate Created


date_modifieddatetimeDate Modified


created_byidCreated By


modified_byidModified By


user_namestring(255)User Name


passwordstring(255)Password


hash_passwordstring(255)Hashed Password


createbooleanCreateBy Default True


updatebooleanUpdateBy Default True
2ao_snow_config_masteridchar(36)



namestring(255)



date_createddatetime



date_modifieddatetime



created_byid



modified_byid



jira_project




jira_issue_type


3ao_snow_config_detailidchar(36)



namestring(255)



date_createddatetime



date_modifieddatetime



created_byid



modified_byid



ao_snow_config_idid



jira_field




snow_field


...

EventsMethod
Sample InputTable

GEThttps://dev48910.service-now.com/api/now/v2/table/{tableName}

Create incident in ServiceNowPOSThttps://dev48910.service-now.com/api/now/v2/table/{tableName}

Get the incident details from ServiceNowGEThttps://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}


PUThttps://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}Content-Type: application/json

Sample URL:

https://dev48910.service-now.com/api/now/v2/table/incident/e471a4de4f31005088adff6f9310c723

Sample JSON for body

+{

"short_description" : "",

"comments":"Enter the comments"

}+

Note: Enter the field name which you want to update


Response: JSON response



DELETEhttps://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}


PATCHhttps://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}


GEThttps://dev48910.service-now.com/api/now/v2/table/incident?sysparm_limit=1&sysparm_offset=0


GEThttps://dev48910.service-now.com/api/now/attachment/file?table_name=incident&table_sys_id=4830a73a4f69041088adff6f9310c76d&file_name=test_note_1Content-Type: document/txt
Body: Binary		sys_attachment.list
Reference : table_name, table_sys_id
Get the Field Lists from IncidentGET
New URL:-


tableName=sys_dictionary

sysparm_query=name=incident^ORname=task

sysparm_display_value=all

sysparm_fields=column_label,sys_name,name,read_only,max_length,active,mandatory,comments,sys_created_by,element


4.References


Sl No#URLDescription
1https://developer.servicenow.com/blog.do?p=/post/dot-walking-in-the-rest-table-api-2/REST API to fetch data from table
2https://docs.servicenow.com/bundle/istanbul-application-development/page/integrate/inbound-rest/concept/c_AttachmentAPI.htmlFor Attachment

...