Search jobs progress billing (server-side table query: paging, sorting, filters)
singleops_read_search_jobs_progress_billingSearch jobs progress billing data with server-side paging, sorting, and filters to locate billing progress and status for specific jobs or clients.
Instructions
Search jobs progress billing (server-side table query: paging, sorting, filters). (GET /jobs/progress_billing_datatable) 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], columns[8][data], columns[8][name], columns[8][searchable], columns[8][orderable], columns[8][search][value], columns[8][search][regex], columns[9][data], columns[9][name], columns[9][searchable], columns[9][orderable], columns[9][search][value], columns[9][search][regex], columns[10][data], columns[10][name], columns[10][searchable], columns[10][orderable], columns[10][search][value], columns[10][search][regex], order[0][column], order[0][dir], start, length, search[value], search[regex], all_stage_ids_dropdown, operation_id, client_id, assignee_id, sales_rep_id, from_date, to_date, date_filter_on, search_custom_input_id, search_custom_input_term, include_tag_ids, exclude_tag_ids, tags_any, manual_progress_type, milestone_progress_type, items, item_groups, include_recurring, include_one_offs, include_proposal_groups, include_on_hold, include_off_hold, include_unlimited_job, include_pickups, include_deliveries, requires_deposit, deposit_paid, unpaid_deposit, flyout, 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". | |
| items | No | Query parameter "items". | |
| start | No | Query parameter "start". | |
| flyout | No | Query parameter "flyout". | |
| length | No | Query parameter "length". | |
| to_date | No | Query parameter "to_date". | |
| tags_any | No | Query parameter "tags_any". | |
| client_id | No | Query parameter "client_id". | |
| from_date | No | Query parameter "from_date". | |
| assignee_id | No | Query parameter "assignee_id". | |
| extra_query | No | Any additional query parameters. | |
| item_groups | No | Query parameter "item_groups". | |
| colReorder[] | No | Query parameter "colReorder[]". | |
| deposit_paid | No | Query parameter "deposit_paid". | |
| operation_id | No | Query parameter "operation_id". | |
| sales_rep_id | No | Query parameter "sales_rep_id". | |
| order[0][dir] | No | Query parameter "order[0][dir]". | |
| search[regex] | No | Query parameter "search[regex]". | |
| search[value] | No | Query parameter "search[value]". | |
| date_filter_on | No | Query parameter "date_filter_on". | |
| unpaid_deposit | No | Query parameter "unpaid_deposit". | |
| exclude_tag_ids | No | Query parameter "exclude_tag_ids". | |
| include_on_hold | No | Query parameter "include_on_hold". | |
| include_pickups | No | Query parameter "include_pickups". | |
| include_tag_ids | No | Query parameter "include_tag_ids". | |
| 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]". | |
| columns[8][data] | No | Query parameter "columns[8][data]". | |
| columns[8][name] | No | Query parameter "columns[8][name]". | |
| columns[9][data] | No | Query parameter "columns[9][data]". | |
| columns[9][name] | No | Query parameter "columns[9][name]". | |
| include_off_hold | No | Query parameter "include_off_hold". | |
| include_one_offs | No | Query parameter "include_one_offs". | |
| order[0][column] | No | Query parameter "order[0][column]". | |
| requires_deposit | No | Query parameter "requires_deposit". | |
| columns[10][data] | No | Query parameter "columns[10][data]". | |
| columns[10][name] | No | Query parameter "columns[10][name]". | |
| include_recurring | No | Query parameter "include_recurring". | |
| include_deliveries | No | Query parameter "include_deliveries". | |
| manual_progress_type | No | Query parameter "manual_progress_type". | |
| 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[8][orderable] | No | Query parameter "columns[8][orderable]". | |
| columns[9][orderable] | No | Query parameter "columns[9][orderable]". | |
| include_unlimited_job | No | Query parameter "include_unlimited_job". | |
| all_stage_ids_dropdown | No | Query parameter "all_stage_ids_dropdown". | |
| columns[0][searchable] | No | Query parameter "columns[0][searchable]". | |
| columns[10][orderable] | No | Query parameter "columns[10][orderable]". | |
| 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[8][searchable] | No | Query parameter "columns[8][searchable]". | |
| columns[9][searchable] | No | Query parameter "columns[9][searchable]". | |
| search_custom_input_id | No | Query parameter "search_custom_input_id". | |
| columns[10][searchable] | No | Query parameter "columns[10][searchable]". | |
| include_proposal_groups | No | Query parameter "include_proposal_groups". | |
| milestone_progress_type | No | Query parameter "milestone_progress_type". | |
| search_custom_input_term | No | Query parameter "search_custom_input_term". | |
| 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]". | |
| columns[8][search][regex] | No | Query parameter "columns[8][search][regex]". | |
| columns[8][search][value] | No | Query parameter "columns[8][search][value]". | |
| columns[9][search][regex] | No | Query parameter "columns[9][search][regex]". | |
| columns[9][search][value] | No | Query parameter "columns[9][search][value]". | |
| columns[10][search][regex] | No | Query parameter "columns[10][search][regex]". | |
| columns[10][search][value] | No | Query parameter "columns[10][search][value]". |