The API allows a caller to run a named report via an HTTPS request and returns the report output in a structured JSON format.

Using a one-off URL, from an external application

?A=HttpApiReportJson&Login=login&Password=password&R=report+name

Or, from a logged-in session, for example, from a form component

[System:Action]HttpApiReportJsonAuth&R=report+name

Runs the named report in the context of the supplied login and returns the output of the report in JSON format. Output is a JSON array of report rows. Each row is a set of heading/value pairs for each column in the report.

For example:

[

{

“Reference”:”IN007338″,

“Subject”:”I am having trouble with using nordic characters (ASCII  # 228, 229 and 246), in SupportDesk FM.  Using these characters in the organization or contact fields creates an database error message. The error  appears when trying to call back a earlier organization or contact through the drop-down menus, and the item contains a nordic characters, or when opening a  call where either of the stated fields contain a nordic character.”,

“Type”:”Issue”,

“Status”:”Open”,

“Priority”:”1 High”,

“Assignee”:”John”

},

{

“Reference”:”IN007339″,

“Subject”:”We’ve been experiencing a few problems with supportdesk over the las few weeks.  Emails that are being sent to the helpdesk are not automatically being received by supportdesk, and the tickets are not being created/updated.”,

“Type”:”Investigation”,

“Status”:”Closed – Info Not Received”,

“Priority”:”3 Medium”,

“Assignee”:”Dave”

},

]

Still haven’t found what you’re looking for? Contact documentation@houseonthehill.com

Previous – Webhooks APINext – HotH Powershell