How to add total_time_spent in worklog using API
Please use milli-seconds as value to the attribute
URL: <URL>/api/v3/worklog?OPERATION_NAME=add&TECHNICIAN_KEY=XXXXXXXXXXXXX
JSON:
input_date={
"worklog": {
"request": {
"id": "6"
},
"description": "Adding a worklog",
"technician": {
"name": "administrator"
},
"total_time_spent": 720000,
"start_time": {
"value": 1421042555857
},
"end_time": {
"value": 1421042555857
}
}
}
"worklog": {
"request": {
"id": "6"
},
"description": "Adding a worklog",
"technician": {
"name": "administrator"
},
"total_time_spent": 720000,
"start_time": {
"value": 1421042555857
},
"end_time": {
"value": 1421042555857
}
}
}
New to ADSelfService Plus?
Related Articles
Query to get total worklog time spent on a request. (PGSQL)
Tested in build PGSQL (14300) Scenario: Request1 worklog1-Total time taken to resolve=1 hr 20 mins. worklog2- Total time taken to resolve=1hr 10mins. While generating a report the total time taken to resolve for request1 should be 2 hrs 30mins. ...Query to show total time spent for a ticket ( PGSQL)
Tested in PGSQL build (14300) Database: PGSQL SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", rtdef.NAME AS "Request Type", ti.FIRST_NAME AS ...Script to add worklog using custom schedule
What is a Custom Schedule? Custom Schedules are actions scheduled on a specific date and time with or without repeat frequency. The actions are specified in a customized script file. Any data from ServiceDesk Plus can be sent to the script through ...Problem time spent
SELECT prob.PROBLEMID "Problem ID", prob.TITLE "Title", catadef.CATEGORYNAME "Category", LONGTODATE(prob.REPORTEDTIME) "Reported Date", ownaaa.FIRST_NAME "Technician", priodef.PRIORITYNAME "Priority", statdef.STATUSNAME "Status", ...Add attachments using API
Attachment cannot be added when a request is created, it can be only added after request creation URL : http://localhost:8080/api/v3/attachments?TECHNICIAN_KEY=XXXXXXXXX Body