Get the Change Request Item Data

API Change requests tickets
Purpose Fetches change request Item data for a specified organization within a given date range.
API URL https://<API URL>:<API Port>/v2/changeRequests/actionable/orgentityid/{orgentityid}?startdate={startdate}&enddate={enddate}
Authentication type Basic/Token
Method Type GET
Input Params in Query String:

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

· orgentityid (URL)

· startdate (query params)

· enddate (query params)

Parameters Required in API

Column Column type Remarks
orgentityid string The organization entity ID.
startdate string It defines the beginning of the time window used to calculate the count of tickets that were resolved. The startdate in the format YYYY-MM-DD hh:mm:ss.
enddate string It specifies the end of the date range for counting resolved tickets. The enddate in the format YYYY-MM-DD hh:mm:ss.
Note:
If no dates are provided, data from the past year is considered. If only the start date is given, the end date defaults to today. If only the end date is given, the start date defaults to one year before it.

Output:

          {{ 
          "Count": 1, 
          "Result": 
          [ { 
          "TicketId": 1, 
          "ServiceId": 1, 
          "DataSourceId": 1, 
          "TicketNumber": "CTask", 
          "RunbookId": 1, 
          "RunbookRBAUniqueId": "my_runbook_id", 
          "Summary": "my ticket summary", "Description": "my ticket description", "CreationDate": "2025-03-21T05:51:00", 
          "LastModifiedDate": "2025-03-25T10:34:51", 
          "AssignedGroup": "1", 
          "AssignedGroupUniqueId": null, 
          "AssignedTo": null, 
          "AssigneeUniqueId": null, 
          "Priority": null, 
          "PriorityCode": null, 
          "Status": null, 
          "StatusCode": "-5", 
          "AffectedCI": null, 
          "AffectedCIUniqueId": null, 
          "Col1": "1", 
          "Col2": null, 
          "Col3": null, 
          "Col4": null, 
          "Col5": null, 
          "Col6": null, 
          "Col7": null, 
          "Col8": null, 
          "Col9": null, 
          "Col10": null, 
          "Col11": null, 
          "Col12": null, 
          "Col13": null, 
          "Col14": null, 
          "Col15": null, 
          "Col16": null, 
          "Col17": null, 
          "Col18": null, 
          "Col19": null, 
          "Col20": null, 
          "ModuleType": "CHANGETASK", 
          "SchType": "TICKET", 
          "QueuedOn": "2025-03-23T08:46:46", 
          "CompletedOn": "2025-03-23T08:52:13", 
          "RunbookToolId": 16, 
          "RunbookToolTenantId": null, 
          "MaxRecommendationThreshold": 0.72, 
          "MaxThresholdRunbookId": 1, 
          "MaxThresholdRBRBAUniqueId": "my_runbook_id", 
          "MaxThresholdRBN": "my_runbook_id", 
          "ExecRunbookRecommendationThreshold": null, 
          "ExecutedRunbookId": null, 
          "ExecutedRunbookRBAUniqueId": null, 
          "ExecutedRBN": null, 
          "IsSMEApprovedRunbook": null, 
          "ExecutionId": null, 
          "LastPickedByUser": "myuser@hcl.com", 
          "NoOfInitiations": 0, 
          "IsAutoPicked": "N", 
          "IsManualPicked": "N", 
          "IsExecutionSuccessful": "N", 
          "IsExecutionUnSuccessful": "N", 
          "IsResolved": "N", 
          "IsTransferred": "N", 
          "IsTransferredDueToiAutomate": "N", 
          "IsTransferredDueToRunbook": "N", 
          "CouldntProcessAsExitCriteriaMet": "Y", 
          "RecordCreatedDate": "2025-03-24T12:08:29.143", 
          "TicketReassignationCount": 0, 
          "ManualExecutionTimeInMinutes": null, 
          "AutoExecutionTimeInMinutes": null, 
          "RunbookCategory": null, 
          "RunbookSubCategory": null, 
          "EstStartDate": null, 
          "EstEndDate": null, 
          "ActualStartDate": null, 
          "ActualEndDate": null, 
          "RequestedBy": null, 
          "ChangeId": "1", 
          "SubCategory": null 
          } ], 
          "Status": "Success", 
          "Message": "Success" 
          }

Parameters Returned in Response of API

Column Column type Value Remarks
Result JSON All Ticket between the given date range Provides all processed tickets for the module.
Count String Count of tickets Total count of the tickets.
Status String Success/Fail This field provides status.
Message String Success Request status info.