APP-140 - Getting issue details... STATUS

1.Objective

Develop plugin to integrate Jira SD to ServiceNow

2.Features

Sl No	Features
1	admin user should be able to configure the connection parameters in screen
2	admins user should be able to map the JIRA SD and Service Now Fields
3	Any change (create/update/edit) in JIRA SD should update the respective incident in ServiceNow
4	Any change (create/update/edit) in ServiceNow should update the respective Task/issues in Jira SD

3.Solution Description

3.1 Task List

#	Task	Description	Dependent Task	Owner	Start Date	End Date	Status
1	Local Environment Setup	Installation of JIRA SDK, Eclipse Setup	0	Ariya Krishnan	11 Dec 2019	11 Dec 2019	AP-844 - Getting issue details... STATUS
2	Create ServiceNow Instance	Register in ServiceNow with empyra email Id	0	Sharmendra Vishwakarma	11 Dec 2019	11 Dec 2019	APP-147 - Getting issue details... STATUS
3	Connection Screen: Create UI	Screen to enter the connection details	1	Ariya Krishnan	11 Dec 2019	13 Dec 2019	APP-148 - Getting issue details... STATUS
4	Connection Screen: Edit UI	Screen to edit the connection details	1	Ariya Krishnan	11 Dec 2019	12 Dec 2019	APP-149 - Getting issue details... STATUS
5	Connection Screen : Details UI	Screen to display the connection details	1	Ariya Krishnan	11 Dec 2019	12 Dec 2019	APP-150 - Getting issue details... STATUS
6	Create the data model to store the connection details	Create database schema for storing the connection details	3	Ariya Krishnan	13 Dec 2019	13 Dec 2019	APP-155 - Getting issue details... STATUS
7	Business Logic to save/edit the connection details	Implementation logic to save the connection details	6	Ariya Krishnan	13 Dec 2019	16 Dec 2019	APP-152 - Getting issue details... STATUS
8	Business logic to test the ServiceNow connection	Implementation logic to test the connection	7	Ariya Krishnan	17 Dec 2019	17 Dec 2019	APP-153 - Getting issue details... STATUS
9	Business Logic to reset the connection	Implementation logic to RESET the connection	7	Ariya Krishnan	18 Dec 2019	18 Dec 2019	APP-156 - Getting issue details... STATUS
10	Configuration Screen : Fields mapping JIRA SD and ServiceNow	Screen to Mapp the Jira SD and ServiceNow fields	5	Dipesh Chouksey (Unlicensed)	19 Dec 2019	19 Dec 2019	APP-157 - Getting issue details... STATUS
11	Create data model to store the field mapping in db	Create database table to store the mapping details	10	Dipesh Chouksey (Unlicensed)	20 Dec 2019	20 Dec 2019	APP-158 - Getting issue details... STATUS
12	Business Logic to save/edit/delete the configuration details	Implementation logic to save/edit/delete the field mappings.	11	Dipesh Chouksey (Unlicensed)	20 Dec 2019	24 Dec 2019	APP-161 - Getting issue details... STATUS
13	Host the Jira Service Desk for ServiceNow Connectivity	Availability of this will help ServiceNow to connect to Jira SD	12
14	Implement Logger	Implementation the logger	1,2,3,4,5,6
15	Create a listener for JIRA Issue events(Create/Update/Edit) in Jira SD (Create/Update)	Need to check the deletion( Feature Not Required)	12	Sharmendra Vishwakarma	30 Dec 2019	03 Jan 2020	AP-898 - Getting issue details... STATUS
16	Create incident-based on Jira issue creation based on saved mapping	Supported field: Summary, description, Text Field (single line) custom field		Dipesh Chouksey (Unlicensed)	06 Jan 2020		AP-915 - Getting issue details... STATUS
17	Update incident-based on Jira issue creation based on saved mapping		16	Dipesh Chouksey (Unlicensed)			AP-916 - Getting issue details... STATUS
18	Listener for JIRA comments events(Create/Update/Edit) in Jira SD (Create/Update)	Need to check the deletion( Feature Not Required)	15	Sharmendra Vishwakarma	30 Dec 2019	03 Jan 2020	AP-899 - Getting issue details... STATUS
19	Setup instance and prepare for demo.						AP-928 - Getting issue details... STATUS
20	Listener for JIRA attachment events(Create/Update/Edit) in Jira SD (Create/Update)			Dipesh Chouksey (Unlicensed)			AP-919 - Getting issue details... STATUS
21	Check the API to push the create/update of incident to Jira SD	Need to check to configure outbound message configuration in ServiceNow	0	Sharmendra Vishwakarma	13 Dec 2019	16 Dec 2019	APP-151 - Getting issue details... STATUS
22	Setup client instance and support a single select field like priority			Dipesh Chouksey (Unlicensed)			AP-934 - Getting issue details... STATUS
23	~~Pushing the update from ServiceNow to Jira~~ Pull the incident update from ServiceNow and update Jira SD		0
24	Create User Documentation in Confluence		16
25	Test Cases		16
26	Create OBR for the marketplace		17

3.2 Data Model

Sl No#	Table Name	Fields	Field Type	Display Name	Description
1	ao_snow_conn	id	char(36)	Id
		name	string(255)	Connection URL	Service Now base URL
		date_created	datetime	Date Created
		date_modified	datetime	Date Modified
		created_by	id	Created By
		modified_by	id	Modified By
		user_name	string(255)	User Name
		password	string(255)	Password
		hash_password	string(255)	Hashed Password
		create	boolean	Create	By Default True
		update	boolean	Update	By Default True
2	ao_snow_config_master	id	char(36)
		name	string(255)
		date_created	datetime
		date_modified	datetime
		created_by	id
		modified_by	id
		jira_project
		jira_issue_type
3	ao_snow_config_detail	id	char(36)
		name	string(255)
		date_created	datetime
		date_modified	datetime
		created_by	id
		modified_by	id
		ao_snow_config_id	id
		jira_field
		snow_field

3.3 Field Mapping

Display Field	Field Name	Type	Default	Description	Display Field	Field Name	Type	Default	Value	Sample data
Jira SD					ServiceNow
Need to create custom field	Incident	Text		To Capture Incident number of ServiceNow to JIRA SD	Number	number	Text	INC0010006
					Contact type		Dropdown	None	Email,Phone,Self-Service,Walk-in
Reporter					Caller	caller_id	Lookup		Users
Customer status					State	incident_state	Dropdown	New	New, In Progress, On Hold,Resolved, Closed , Cancelled
Request type					Category	category	Dropdown	Inquiry / Help	Inquiry / Help, Help, Software,Hardware,Network,Database	inquiry
					Impact	impact	Dropdown	3-Low	1-High.2-Medium,3-Low
					Subcategory	subcategory	Dropdown	None	Antivirus,Email, Internal Application
Urgency				Critical,High,Medium,Low	Urgency	urgency	Dropdown	3-Low	1-High.2-Medium,3-Low
					Service		Lookup
Priority				High,Medium,Low,Blocker,Minor	Priority	priority		5-Planning		5
					Configuration item		Lookup		Looup to Configuration
					Assignment group		Lookup		Lookup to Group
Assignee					Assigned to		Lookup		Lookup to users
Summary					Short description	short_description	Text			Laptop is not working
Description					Description	description	Text Area
					Notes
					Watch list	watch_list
Respond to Customer				If it is for Customer Comment, visibile to portal	Additional comments(Customer visible)		Text Area
Comment				Related Field, Internal Comment, not visible to customer	Work notes	work_notes	Text Area
					Related Records
					Problem		Lookup		Lookup to Problem
					Change Request		Lookup		Lookup to Change Request
					Caused by Change		Lookup		Lookup to Caused by Change
					Resolution Information
					Knowledge		Checkbox
					Resolved by	resolved_by	Lookup
					Resolution code		Dropdown	Solved(Work Around)
					Resolved
Resolution					Resolution notes		Text Area
Status			waiting for support	Depends on the workflow assigned
Component/s
Labels
Attachment				Related Field
Create Custom Field(	SysId	Text			sys_id	sys_id	Id			4830a73a4f69041088adff6f9310c76d
					sys_updated_on	sys_updated_on				10-12-2019 12:40
					sys_updated_by	sys_updated_by				admin
					sys_created_on	sys_created_on				10-12-2019 05:56
					sys_created_by	sys_created_by				admin

3.4 API Details

Events	Method		Sample Input	Table
	GET	https://dev48910.service-now.com/api/now/v2/table/{tableName}
Create incident in ServiceNow	POST	https://dev48910.service-now.com/api/now/v2/table/{tableName}
Get the incident details from ServiceNow	GET	https://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}
	PUT	https://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
	DELETE	https://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}
	PATCH	https://dev48910.service-now.com/api/now/v2/table/{tableName}/{sys_id}
	GET	https://dev48910.service-now.com/api/now/v2/table/incident?sysparm_limit=1&sysparm_offset=0
	GET	https://dev48910.service-now.com/api/now/attachment/file?table_name=incident&table_sys_id=4830a73a4f69041088adff6f9310c76d&file_name=test_note_1	Content-Type: document/txt Body: Binary	sys_attachment.list Reference : table_name, table_sys_id
Get the Field Lists from Incident	GET	https://dev48910.service-now.com/api/now/v2/table/sys_dictionary?sysparm_fields=internal_type,column_label,sys_name,name,read_only,max_length,active,mandatory,comments,sys_created_by,element&name=incident&sysparm_display_value=all New URL:- https://dev48910.service-now.com/api/now/v2/table/sys_dictionary?sysparm_query=name%3Dincident%5EORname%3Dtask&sysparm_display_value=all&sysparm_fields=column_label%2Csys_name%2Cname%2Cread_only%2Cmax_length%2Cactive%2Cmandatory%2Ccomments%2Csys_created_by%2Celement		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#	URL	Description
1	https://developer.servicenow.com/blog.do?p=/post/dot-walking-in-the-rest-table-api-2/	REST API to fetch data from table
2	https://docs.servicenow.com/bundle/istanbul-application-development/page/integrate/inbound-rest/concept/c_AttachmentAPI.html	For Attachment

Atlassian Apps - Internal

20.Technical Specification

Analytics

1.Objective

2.Features

3.Solution Description

3.1 Task List

3.2 Data Model

3.3 Field Mapping

3.4 API Details

4.References