Custom Data View Example

GET {{httptype}}://{{IP}}/mot/{{miralixAccount}}/views/{{CustomWebApi}}

Returns data from the MS SQL View as a JSON Array.
HTTP GET: /views/{CustomWebApi}

ParameterValueDescription
CustomWebApiStringName of the MS SQL View that starts with WebApi

Example

https://192.168.1.10/mot/greenbox/views/WebApi_CustomCallLog - Data is returned from the Custom Data View.

Result

  • 200 OK - Data is returned from the Custom Data View.
  • 403 Forbidden - Missing required License to access this request.
  • 404 Not Found - Custom Data View not found.
  • 500 Internal Server Error - Internal processing error.

JSON result

Data is returned from the Custom Data View, as a JSON Array. Each row in the table, is returned as an object in the JSON Array. Each column value is represented as a name/value pair in that object. Where the column name is the name, and the value of that particular column and row, is the value.

RESPONSES

status: OK

[[{"Global_call_id":"c96fb81d-37f9-492c-a406-be9230b7507e","Date_time":"2023-02-15T13:03:18.6836665","Initials":"ES87","Time":"13:03","Caller":"+4523456789","Call_duration":"0:00:33.000","Extra_calldata":"No extra call data","Data_1":null,"Data_2":null,"Data_3":null,"Data_4":null,"Data_group_1":null,"Data_type_1":null},{"Global_call_id":"c96fb81d-37f9-492c-a406-be9230b7507e","Date_time":"2023-02-15T13:03:18.7109497","Initials":"ES87","Time":"13:03","Caller":"+4572311780","Call_duration":"0:00:33.000","Extra_calldata":"No extra call data","Data_1":null,"Data_2":null,"Data_3":null,"Data_4":null,"Data_group_1":null,"Data_type_1":null},{"Global_call_id":"01e429ea-c62d-47aa-8cfb-846ea4a1aab0","Date_time":"2023-02-22T06:32:33.4042635","Initials":"ES87","Time":"06:32","Caller":"+4572311784","Call_duration":"0:00:25.000","Extra_calldata":"No extra call data","Data_1":null,"Data_2":null,"Data_3":null,"Data_4":null,"Data_group_1":null,"Data_type_1":null},{"Global_call_id":"01e429ea-c62d-47aa-8cfb-846ea4a1aab0","Date_time":"2023-02-22T06:32:33.4803056","Initials":"ES87","Time":"06:32","Caller":"+4572311780","Call_duration":"0:00:25.000","Extra_calldata":"No extra call data","Data_1":null,"Data_2":null,"Data_3":null,"Data_4":null,"Data_group_1":null,"Data_type_1":null}]]