API -Listing Open Requests of a specific Requester
{
"list_info": {
"row_count": 20,
"start_index": 1,
"sort_field": "subject",
"sort_order": "asc",
"get_total_count": true,
"search_fields": {
"requester.name": "CustomREQ1"
},
"filter_by": {
"name": "Open_System"
}
}
}
2. Make sure to include input_data at the beginning of the parameter as highlighted below:
New to ADSelfService Plus?
Related Articles
How to send periodic notifications to requester(s) about their pending requests and accordingly update their status.
This post describes the use of a python script to notify requester(s) about their requests through email and move those to a specific status. Use Case: Let us assume a scenario where the technicians reply to a request and put it in a custom status ...API - Listing of Worklogtype
1. Go to Admin > API > Reports > Execute Query: select * from worklogtypedefinition 2. Sharing screenshot for your reference:Query report to show Open requests without open tasks
PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", ti.FIRST_NAME AS "Technician", aau.FIRST_NAME AS "Requester", wotodesc.FULLDESCRIPTION AS "Description", std.STATUSNAME AS "Request ...API -Listing requests based on Additional Field Values
This can be met through V3 API. Go to Admin > Incident Additional Fields and make a note of the "API Field Name" as highlighted below: Please follow the below mentioned to pull the requests based on the additional field values: 1. Use the Input as ...Requests that are open for more than 7 days (PGSQL)
Tested in Build PGSQL (14300) PGSQL: select wo.workorderid as "RequestID", wo.Title as "Title", reqaaa.First_Name as "Requester", aaa.first_name as "Technician", sd.StatusName as "Status", wo.CreatedTime as "CreatedTime", wos.AssignedTime as ...