Search visits approved (server-side table query: paging, sorting, filters)
singleops_read_search_visits_approvedSearch approved visits with server-side paging, sorting, and filters. Returns JSON with total and filtered record counts for data tables.
Instructions
Search visits approved (server-side table query: paging, sorting, filters). (GET /visits/approved/data_table) Inferred from the SingleOps web app's own traffic; confirm results. Query params seen: draw, columns[0][data], columns[0][name], columns[0][searchable], columns[0][orderable], columns[0][search][value], columns[0][search][regex], columns[1][data], columns[1][name], columns[1][searchable], columns[1][orderable], columns[1][search][value], columns[1][search][regex], columns[2][data], columns[2][name], columns[2][searchable], columns[2][orderable], columns[2][search][value], columns[2][search][regex], columns[3][data], columns[3][name], columns[3][searchable], columns[3][orderable], columns[3][search][value], columns[3][search][regex], columns[4][data], columns[4][name], columns[4][searchable], columns[4][orderable], columns[4][search][value], columns[4][search][regex], columns[5][data], columns[5][name], columns[5][searchable], columns[5][orderable], columns[5][search][value], columns[5][search][regex], columns[6][data], columns[6][name], columns[6][searchable], columns[6][orderable], columns[6][search][value], columns[6][search][regex], columns[7][data], columns[7][name], columns[7][searchable], columns[7][orderable], columns[7][search][value], columns[7][search][regex], order[0][column], order[0][dir], start, length, search[value], search[regex], table_filter_start, table_filter_end, report_range_cache, colReorder[], settings_initialized. Returns JSON with keys: draw, recordsTotal, recordsFiltered, data, meta, table_id, settings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| draw | No | Query parameter "draw". | |
| start | No | Query parameter "start". | |
| length | No | Query parameter "length". | |
| extra_query | No | Any additional query parameters. | |
| colReorder[] | No | Query parameter "colReorder[]". | |
| order[0][dir] | No | Query parameter "order[0][dir]". | |
| search[regex] | No | Query parameter "search[regex]". | |
| search[value] | No | Query parameter "search[value]". | |
| response_format | No | Output format: "markdown" (default, readable tables) or "json" (full raw response). | |
| columns[0][data] | No | Query parameter "columns[0][data]". | |
| columns[0][name] | No | Query parameter "columns[0][name]". | |
| columns[1][data] | No | Query parameter "columns[1][data]". | |
| columns[1][name] | No | Query parameter "columns[1][name]". | |
| columns[2][data] | No | Query parameter "columns[2][data]". | |
| columns[2][name] | No | Query parameter "columns[2][name]". | |
| columns[3][data] | No | Query parameter "columns[3][data]". | |
| columns[3][name] | No | Query parameter "columns[3][name]". | |
| columns[4][data] | No | Query parameter "columns[4][data]". | |
| columns[4][name] | No | Query parameter "columns[4][name]". | |
| columns[5][data] | No | Query parameter "columns[5][data]". | |
| columns[5][name] | No | Query parameter "columns[5][name]". | |
| columns[6][data] | No | Query parameter "columns[6][data]". | |
| columns[6][name] | No | Query parameter "columns[6][name]". | |
| columns[7][data] | No | Query parameter "columns[7][data]". | |
| columns[7][name] | No | Query parameter "columns[7][name]". | |
| order[0][column] | No | Query parameter "order[0][column]". | |
| table_filter_end | No | Query parameter "table_filter_end". | |
| report_range_cache | No | Query parameter "report_range_cache". | |
| table_filter_start | No | Query parameter "table_filter_start". | |
| settings_initialized | No | Query parameter "settings_initialized". | |
| columns[0][orderable] | No | Query parameter "columns[0][orderable]". | |
| columns[1][orderable] | No | Query parameter "columns[1][orderable]". | |
| columns[2][orderable] | No | Query parameter "columns[2][orderable]". | |
| columns[3][orderable] | No | Query parameter "columns[3][orderable]". | |
| columns[4][orderable] | No | Query parameter "columns[4][orderable]". | |
| columns[5][orderable] | No | Query parameter "columns[5][orderable]". | |
| columns[6][orderable] | No | Query parameter "columns[6][orderable]". | |
| columns[7][orderable] | No | Query parameter "columns[7][orderable]". | |
| columns[0][searchable] | No | Query parameter "columns[0][searchable]". | |
| columns[1][searchable] | No | Query parameter "columns[1][searchable]". | |
| columns[2][searchable] | No | Query parameter "columns[2][searchable]". | |
| columns[3][searchable] | No | Query parameter "columns[3][searchable]". | |
| columns[4][searchable] | No | Query parameter "columns[4][searchable]". | |
| columns[5][searchable] | No | Query parameter "columns[5][searchable]". | |
| columns[6][searchable] | No | Query parameter "columns[6][searchable]". | |
| columns[7][searchable] | No | Query parameter "columns[7][searchable]". | |
| columns[0][search][regex] | No | Query parameter "columns[0][search][regex]". | |
| columns[0][search][value] | No | Query parameter "columns[0][search][value]". | |
| columns[1][search][regex] | No | Query parameter "columns[1][search][regex]". | |
| columns[1][search][value] | No | Query parameter "columns[1][search][value]". | |
| columns[2][search][regex] | No | Query parameter "columns[2][search][regex]". | |
| columns[2][search][value] | No | Query parameter "columns[2][search][value]". | |
| columns[3][search][regex] | No | Query parameter "columns[3][search][regex]". | |
| columns[3][search][value] | No | Query parameter "columns[3][search][value]". | |
| columns[4][search][regex] | No | Query parameter "columns[4][search][regex]". | |
| columns[4][search][value] | No | Query parameter "columns[4][search][value]". | |
| columns[5][search][regex] | No | Query parameter "columns[5][search][regex]". | |
| columns[5][search][value] | No | Query parameter "columns[5][search][value]". | |
| columns[6][search][regex] | No | Query parameter "columns[6][search][regex]". | |
| columns[6][search][value] | No | Query parameter "columns[6][search][value]". | |
| columns[7][search][regex] | No | Query parameter "columns[7][search][regex]". | |
| columns[7][search][value] | No | Query parameter "columns[7][search][value]". |