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}
Parameter | Value | Description |
---|---|---|
CustomWebApi | String | Name 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}]]