Get SR Ticket Data
The Get SR Ticket Data API allows users to retrieve data about Service Request Tasks. The API supports filtering by various parameters such as start_date, end_date, ticket_number, assignment_group, and sys_id. The API returns information about the ticket number, summary, description, assigned group, status, creation date, last modified date, and other custom fields.
API version V1.0
API: | GetSRTicketData |
Purpose: | To get data of Service Request Tasks that are dumped Save Service Request Task API. |
API URL: | http://<API URL>:<API Port>/iAutomateAPI/Request/GetSRTicketData/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:
|
Filter field | Supported Filter operator |
start_date | >= ,< , >, <=, = |
end_date | >= ,< , >, <=, = |
Ticket_number | = |
assignment_group | = |
sys_id | = |
Example: |
http://localhost:26240/iAutomateAPI/Request/GetSRTicketData/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": "SRTask0303863", "Summary": "testing", "Description": "testing data", "RequestItemId": "12345", "SRId": "2b535ab3dbc988506d7550d3dc96190e", "AssignedGroup": "", "StatusCode": "1", "CreationDate": "2020-05-07 05:06:05.000", "LastModifiedDate": "2020-05-07 05:54:54.000", "sys_id": "", "Col1": "", "Col2": "", "Col3": "", "Col4": "", "Col5": "", "iAutomate_CreatedDateInGMT": "2020-05-08 09:14:24.903", "iAutomate_UpdatedDateInGMT": "2020-05-08 09:14:24.903" } ]} |
Column | Column Type | Expected/Sample value | Remarks |
---|---|---|---|
TicketNumber | string | CRT0303863 | This field contains Service Request Task number |
Summary | string | testing | This field contains summary of Service Request Task |
Description | string | testing | This field contains description of Service Request Task |
sys_id | string | 2b535ab3dbc988506d7550d3dc96190e | This field contains unique number |
RequestItemId | string | 12648887dbec9810e3bbde06f496196f | This field contains unique number of Service Request Item |
SRid | string | 2b535ab3dbc988506d7550d3dc96190e | This field contains unique number of Service Request |
AssignedGroup | string | 123456 | This field contains assignment group of Service Request Task |
StatusCode | string | 1 | This field contains status of Service Request Task |
CreationDate | string | 2019-11-18 06:24:52 | This field contains creation date of Service Request Task |
LastModifiedDate | string | 2019-11-18 07:24:52 | This field contains date whenever updating happen on Service Request Task |
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 returns date in GMT |
iAutomate_UpdatedDateInGMT | string | 2020-05-04 05:25:36.350 | It returns date in GMT |
API version V2.0
API: | GetSRTicketData |
Purpose: | To get data of Service Request Tasks that are dumped Save Service Request Task API. |
API URL: | http://<API URL>:<API Port>/v2/serviceRequests/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:
|
Filter field | Supported Filter operator |
start_date | >= ,< , >, <=, = |
end_date | >= ,< , >, <=, = |
Ticket_number | = |
assignment_group | = |
sys_id | = |
Example: |
http://localhost:26240/v2/serviceRequests/orgentityid/1?start_date>=2020-01-29 07:12:23.607&end_date<=2019-11-18 06:24:52& |
Output: |
{ "Count": 1, "Result": [ { "TicketNumber": "SCTASK0010992", "Summary": "testing", "Description": "testing data", "RequestItemId": " 12648887dbec9810e3bbde06f496196f ", "SRId": "2b535ab3dbc988506d7550d3dc96190e", "AssignedGroup": "9365b4e90592c81e3b7a024555a6c0094ba77e8773", "StatusCode": "1", "CreationDate": "2020-05-07 05:06:05.000", "LastModifiedDate": "2020-05-07 05:54:54.000", "sys_id": "945eb78e6a0ad872186c8c41c6aa42476a9d051042", "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 09:30:16.390", "iAutomate_UpdatedDateInGMT": "2023-06-12 09:30:16.390" } ], "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 | CRT0303863 | This field contains Service Request Task number |
Summary | string | testing | This field contains summary of Service Request Task |
Description | string | testing | This field contains description of Service Request Task |
sys_id | string | 2b535ab3dbc988506d7550d3dc96190e | This field contains unique number |
RequestItemId | string | 12648887dbec9810e3bbde06f496196f | This field contains unique number of Service Request Item |
SRid | string | 2b535ab3dbc988506d7550d3dc96190e | This field contains unique number of Service Request |
AssignedGroup | string | 123456 | This field contains assignment group of Service Request Task |
StatusCode | string | 1 | This field contains status of Service Request Task |
CreationDate | string | 2019-11-18 06:24:52 | This field contains creation date of Service Request Task |
LastModifiedDate | string | 2019-11-18 07:24:52 | This field contains date whenever updating happen on Service Request Task |
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 returns date in GMT |
iAutomate_UpdatedDateInGMT | string | 2020-05-04 05:25:36.350 | It returns date in GMT |