HTTPS Report API

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 JSON array of report rows, each row is an array of column values indexed by field id.

For example:

[
{
“1” : {
“Title” : “Reference”,
“Value” : “IN007338”
},
“10” : {
“Title” : “Subject”,
“Value” : “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.”
},
“2” : {
“Title” : “Type”,
“Value” : “Issue”
},
“3” : {
“Title” : “Status”,
“Value” : “Closed – Info Not Received”
},
“4” : {
“Title” : “Priority”,
“Value” : “3 Medium”
},
“8” : {
“Title” : “Assignee”,
“Value” : “Customer”
}
},
{
“1” : {
“Title” : “Reference”,
“Value” : “IN007339”
},
“10” : {
“Title” : “Subject”,
“Value” : “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.”
},
“2” : {
“Title” : “Type”,
“Value” : “Investigation”
},
“3” : {
“Title” : “Status”,
“Value” : “Closed – Info Not Received”
},
“4” : {
“Title” : “Priority”,
“Value” : “3 Medium”
},
“8” : {
“Title” : “Assignee”,
“Value” : “Dave”
}
},

PreviousNext