ManagedEngine ServiceDesk Plus (Zoho) Connector Examples

List requests    [ Read more... ]

This example shows how to list requests.

SELECT * FROM Requests

Read request details by ID    [ Read more... ]

This example shows how to read extended information about a single request

SELECT * FROM Requests Where id=111112345

Delete request    [ Read more... ]

This example shows how to delete a request by ID.

DELETE FROM Requests Where id=111112345

List request tasks    [ Read more... ]

This example shows how to read all tasks for a single Request ID

SELECT * FROM get_Request_Tasks WITH (RequestId=111112345)

Read request task details    [ Read more... ]

This example shows how to read request task details by single Request ID and Task ID

SELECT * FROM get_Request_Task_Details  (RequestId=111112345, TaskId=222212345)

List request task comments    [ Read more... ]

This example shows how to read all comment for specific task

SELECT * FROM get_Request_Task_Comments  (RequestId=111112345, TaskId=222212345)

Read request task comment details    [ Read more... ]

This example shows how to read a single comment details for a specific task

SELECT * FROM get_Request_Task_Comment_Details (RequestId=111112345, TaskId=222212345, CommentId=333312345)

List request notes    [ Read more... ]

This example shows how to read all notes for a single Request ID

SELECT * FROM get_Request_Notes WITH (RequestId=111112345)

Read request note details    [ Read more... ]

This example shows how to read request note details by single Request ID and Note ID

SELECT * FROM get_Request_Note_Details (RequestId=111112345, NoteId=222212345)

List request worklog    [ Read more... ]

This example shows how to read all worklogs for a single Request ID

SELECT * FROM get_Request_Worklogs WITH (RequestId=111112345)

Read request worklog details    [ Read more... ]

This example shows how to read request worklog details by single Request ID and Worklog ID

SELECT * FROM get_Request_Worklog_Details (RequestId=111112345, WorklogId=222212345)

List request task worklog    [ Read more... ]

This example shows how to read all worklogs for a single Request Task ID

SELECT * FROM get_Request_Task_Worklogs WITH (RequestId=111112345, TaskId=22222345)

Read request task worklog details    [ Read more... ]

This example shows how to read request task worklog details by single Request Task ID and Worklog ID

SELECT * FROM get_Request_Task_Worklog_Details (RequestId=111112345, TaskId=22222345, WorklogId=333312345)

List projects    [ Read more... ]

This example shows how to list projects.

SELECT * FROM Projects

Read project details by ID    [ Read more... ]

This example shows how to read extended information about a single project

SELECT * FROM Projects Where id=111112345

List assets    [ Read more... ]

This example shows how to list assets.

SELECT * FROM Assets

Read asset by ID    [ Read more... ]

This example shows how to read extended information about an asset

SELECT * FROM Assets Where id=111112345

List purchase orders    [ Read more... ]

This example shows how to list purchase orders.

SELECT * FROM PurchaseOrders

Read purchase order details by ID    [ Read more... ]

This example shows how to read extended information about a single purchase order

SELECT * FROM PurchaseOrders Where id=111112345

List changes    [ Read more... ]

This example shows how to list changes.

SELECT * FROM Changes

Read change details by ID    [ Read more... ]

This example shows how to read extended information about a change

SELECT * FROM Changes Where id=111112345

List contracts    [ Read more... ]

This example shows how to list contracts.

SELECT * FROM Contracts

Read contract details by ID    [ Read more... ]

This example shows how to read extended information about a contract

SELECT * FROM Contracts Where id=111112345

List tasks    [ Read more... ]

This example shows how to list tasks.

SELECT * FROM Tasks

Read task details by ID    [ Read more... ]

This example shows how to read extended information about a task

SELECT * FROM Tasks Where id=111112345