Get Change Ticket Data

To get data of change tasks dumped using the Save Change Request Task API, use the GetChangeTicketData API. This API allows you to retrieve change ticket data based on various filters such as start date, end date, ticket number, assignment group, and sys_id. The API returns a JSON response containing the ticket details including ticket number, summary, description, assigned group, status code, creation date, last modified date, and more.

API version V1.0

API: GetChangeTicketData
Purpose: To get data of change tasks that are dumped using Save Change Request Task API.
API URL: http://<API URL>:<API Port>/iAutomateAPI/Request/GetChangeTicketData/7
Authentication type: Basic
Method Type: GET
Input Params in Query string:

You can pass the following filters in the URL to get desired data:

  • start_date
  • end_date
  • ticktet_number
  • assignment_group
  • sys_id
Filter field Supported Filter operator
start_date >= ,< , >, <=, =
end_date >= ,< , >, <=, =
Ticket_number =
assignment_group =
sys_id =
Example: http://<API URL>:<API Port>/iAutomateAPI/Request/GetChangeTicketData/7?start_date>=2020-01-29 07:12:23.607&end_date<=2019-11-18 06:24:52&

Output:

{

"statusCode": 200,

"status": "Success",

"message": null,

"result": [

{

"TicketNumber": "CRT0303863",

"Summary": "testing",

"Description": "testing data",

"AssignedGroup": "02cc6a39376e4f00c72b2b2943990e68",

"ChangeId": "2b535ab3dbc988506d7550d3dc96190e",

"StatusCode": "1",

"LastModifiedDate": "2019-11-18 00:54:54.000",

"sys_id": "2b535ab3dbc988506d7550d3dc96190e",

"CreationDate": "2019-11-18 00:54:54.000",

"Col1": "",

"Col2": "",

"Col3": "",

"Col4": "",

"Col5": "",

"iAutomate_CreatedDateInGMT": "2020-05-08 09:28:45.703",

"iAutomate_UpdatedDateInGMT": "2020-05-08 09:28:45.703"

}

]

}
Column Column Type Expected/Sample value Remarks
TicketNumber string INC0303863 This field contains ticket number
Summary string testing This field contains summary of ticket
Description string testing This field contains summary of ticket
AssignedGroup string 123456 This field contains assignment group of ticket
StatusCode string 1 This field contains status of ticket
CreationDate string 2019-11-18 06:24:52 This field contains creation date of ticket
LastModifiedDate string 2019-11-18 07:24:52 This field contains date whenever updating happen on ticket
ClosedDate string 2019-11-18 07:24:52 This field contains date whenever ticket gets resolved
sys_id string 2b535ab3dbc988506d7550d3dc96190e This field contains unique number
Col1 string You can use it for any custom value
Col2 string You can use it for any custom value
Col3 string You can use it for any custom value
Col4 string You can use it for any custom value
Col5 string You can use it for any custom value
iAutomate_CreatedDateInGMT string 2020-05-04 05:25:36.350 It return date in GMT
iAutomate_UpdatedDateInGMT string 2020-05-04 05:25:36.350 It return date in GMT

API version V2.0

API: GetChangeTicketData
Purpose: To get data of change tasks that are dumped using Save Change Request Task API.
API URL: http://<API URL>:<API Port>/v2/changeRequests/orgentityid/1
Authentication type: Basic
Method Type: GET
Input Params in Query string:

You can pass the following filters in the URL to get desired data:

  • start_date
  • end_date
  • ticktet_number
  • assignment_group
  • sys_id
Filter field Supported Filter operator
start_date >= ,< , >, <=, =
end_date >= ,< , >, <=, =
Ticket_number =
assignment_group =
sys_id =
Example: http://<API URL>:<API Port>/v2/changeRequests/orgentityid/1?start_date>=2020-01-29 07:12:23.607&end_date<=2019-11-18 06:24:52&

Output:

{

"Count": 1,

"Result": [

{

"TicketNumber": "CRT0303863",

"Summary": "testing",

"Description": "testing data",

"AssignedGroup": "02cc6a39376e4f00c72b2b2943990e68",

"StatusCode": "1",

"CreationDate": "2019-11-18 06:24:54.000",

"LastModifiedDate": "2019-11-18 06:24:54.000",

"ClosedDate": null,

"sys_id": "2b535ab3dbc988506d7550d3dc96190e",

"Col1": "",

"Col2": "",

"Col3": "",

"Col4": "",

"Col5": "",

"Col6": "",

"Col7": "",

"Col8": "",

"Col9": "",

"Col10": "",

"Col11": "",

"Col12": "",

"Col13": "",

"Col14": "",

"Col15": "",

"Col16": "",

"Col17": "",

"Col18": "",

"Col19": "",

"Col20": "",

"iAutomate_CreatedDateInGMT": "2023-06-12 08:37:09.490",

"iAutomate_UpdatedDateInGMT": "2023-06-12 08:37:09.490"

}

],

"Status": "Success",

"Message": "Success"

}
Column Column Type Expected/Sample value Remarks
Count int 1 Total number of tickets returned in Result key
Result Collection [{}] Tickets returned based on filters
Status string Success/Fail This field provide status
Message string message Success/Fail message

Result Key data Description

Column Column Type Expected/Sample value Remarks
TicketNumber string INC0303863 This field contains ticket number
Summary string testing This field contains summary of ticket
Description string testing This field contains summary of ticket
AssignedGroup string 123456 This field contains assignment group of ticket
StatusCode string 1 This field contains status of ticket
CreationDate string 2019-11-18 06:24:52 This field contains creation date of ticket
LastModifiedDate string 2019-11-18 07:24:52 This field contains date whenever updating happen on ticket
ClosedDate string 2019-11-18 07:24:52 This field contains date whenever ticket gets resolved
sys_id string 2b535ab3dbc988506d7550d3dc96190e This field contains unique number
Col1 string You can use it for any custom value
Col2 string You can use it for any custom value
Col3 string You can use it for any custom value
Col4 string You can use it for any custom value
Col5 string You can use it for any custom value
iAutomate_CreatedDateInGMT string 2020-05-04 05:25:36.350 It return date in GMT
iAutomate_UpdatedDateInGMT string 2020-05-04 05:25:36.350 It return date in GMT