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 |