All the endpoints that can be called on the Raw controller.
All the endpoints require the API_RAW_TABLE_READ permission.
The actual data can be fetched with this endpoint. Use the data of the method above to generate a valid URL with valid columns and filters.
The table to get the data from, sample: telephone_calls_inbound
^([a-z_]+)$Comma separated list of the columns you want data from.
^([a-z_,]+)$Array of filters you want to apply. Availability is dependent per table.
Simply give the filter name as key, and the parameter as value.
Timestamp of when the data should start
""Pattern: ^(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})$Timestamp of when the data should end
""Pattern: ^(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})$The record that should be started at.
0Amount of records to return.
1000GET /api/v2/raw/tableData?table=text&columns=text HTTP/1.1
Host: {{base_url}}
apiKey: YOUR_API_KEY
Accept: */*
tableData tickets
{
"itemLimit": 1,
"itemStart": 1,
"itemTotal": 1,
"items": [
{
"brand_id": 1,
"channel_id": 1,
"created_at": "text",
"customer_external_id": "text",
"direction": "text",
"grade_by_customer": null,
"id": 1,
"last_update": "text",
"priority": "text",
"status": "text",
"title": "text"
}
]
}Returns the raw data of the full table.
Uses the table parameter to get the raw_fulltable_crons entry and serves the given file.
^([a-z_]+)$GET /api/v2/raw/fullTable HTTP/1.1
Host: {{base_url}}
apiKey: YOUR_API_KEY
Accept: */*
No content