Egress Endpoints

Egress endpoints are used to pull data via Querying TLDCRM or TLDialer for information using TQL ( Total Query Language ). TQL Parameters and uses can be seen mimicked in Explore Sections in TLDCRM Itself, where you can prepare a query and columns manually for day to day use outside of the API.

1 List of Egress Endpoints Available
2 List of TLDialer Egress API Endpoints
3 Programmatic List of Egress Endpoints
4 Egress Endpoint Documentation
- 4.1 Get Schema Builder
- 4.2 Get All Base Columns
- 4.3 Get Specific Column
- 4.4 Get Base Columns
- 4.5 Get Base Pseudo Columns
- 4.6 Get Base Pseudo / Non-Aggregate Columns
- 4.7 Get Base Aggregate Columns
- 4.8 Get Base PHI Columns
- 4.9 Get Base PCI Columns
- 4.10 Get Base PHI Sensitive Columns
- 4.11 Get Base PCI Sensitive Columns
5 Docs Examples

List of Egress Endpoints Available

/api/egress/agentcpa
/api/egress/callbacks
/api/egress/carriers
/api/egress/change_logs
/api/egress/commission_alignments
/api/egress/commission_paid
/api/egress/commission_received
/api/egress/csr
/api/egress/dependent_fields
/api/egress/dependents
/api/egress/dialer_leads
/api/egress/dnc
/api/egress/document_downloads
/api/egress/documents
/api/egress/documents/{document_id}
/api/egress/documents/{document_id}/download
/api/egress/esign
/api/egress/esign_events
/api/egress/fema
/api/egress/filters
/api/egress/fpg
/api/egress/lead_dependents
/api/egress/lead_dialer_leads
/api/egress/lead_fields
/api/egress/lead_logs
/api/egress/lead_notes
/api/egress/lead_policies
/api/egress/lead_protected_view_logs
/api/egress/lead_view_logs
/api/egress/leads
/api/egress/messaging
/api/egress/note_field
/api/egress/note_fields
/api/egress/notes
/api/egress/notifications
/api/egress/policies
/api/egress/policy_fields
/api/egress/products
/api/egress/protected_view_logs
/api/egress/survey_answers
/api/egress/survey_questions
/api/egress/surveys
/api/egress/tag_logs
/api/egress/tag_members
/api/egress/tags
/api/egress/user_contracts
/api/egress/user_group_members
/api/egress/user_groups
/api/egress/user_licenses
/api/egress/users
/api/egress/vendor_logs
/api/egress/vendorperformance
/api/egress/vendors
/api/egress/view_logs

List of TLDialer Egress API Endpoints

/api/egress/tldialer/agency_call_log
/api/egress/tldialer/audio_store_details
/api/egress/tldialer/call_log
/api/egress/tldialer/call_log_archive
/api/egress/tldialer/conferences
/api/egress/tldialer/join_campaigns
/api/egress/tldialer/join_dids
/api/egress/tldialer/join_ingroups
/api/egress/tldialer/join_list
/api/egress/tldialer/join_lists
/api/egress/tldialer/join_statuses
/api/egress/tldialer/join_user_groups
/api/egress/tldialer/join_users
/api/egress/tldialer/join_users_nogroup
/api/egress/tldialer/leave_vm_message_groups
/api/egress/tldialer/leave_vm_message_groups_entries
/api/egress/tldialer/live_channels
/api/egress/tldialer/live_inbound_log
/api/egress/tldialer/live_sip_channels
/api/egress/tldialer/park_log
/api/egress/tldialer/parked_channels
/api/egress/tldialer/parked_channels_recent
/api/egress/tldialer/phones
/api/egress/tldialer/phones_alias
/api/egress/tldialer/recording_log
/api/egress/tldialer/report_agentcpa
/api/egress/tldialer/servers
/api/egress/tldialer/servers_join
/api/egress/tldialer/system_settings
/api/egress/tldialer/tldialer_backup_logs
/api/egress/tldialer/tldialer_call_log
/api/egress/tldialer/tldialer_call_log_costs
/api/egress/tldialer/tldialer_call_log_dupes
/api/egress/tldialer/tldialer_campaigns_meta
/api/egress/tldialer/tldialer_cid_history
/api/egress/tldialer/tldialer_closer_log
/api/egress/tldialer/tldialer_external_xfer_log
/api/egress/tldialer/tldialer_first_contacts
/api/egress/tldialer/tldialer_fpg_log
/api/egress/tldialer/tldialer_inbound_block_log
/api/egress/tldialer/tldialer_inbound_dids_pricing
/api/egress/tldialer/tldialer_lists_meta
/api/egress/tldialer/tldialer_live_agents
/api/egress/tldialer/tldialer_meta
/api/egress/tldialer/tldialer_meta_definitions
/api/egress/tldialer/tldialer_queue_logs
/api/egress/tldialer/tldialer_reset_log_details
/api/egress/tldialer/tldialer_reset_logs
/api/egress/tldialer/tldialer_users_meta
/api/egress/tldialer/tldialer_whitelist
/api/egress/tldialer/tldialer_xfer_presets
/api/egress/tldialer/twoday_vicidial_log
/api/egress/tldialer/user_call_log
/api/egress/tldialer/user_call_log_archive
/api/egress/tldialer/vicidial_admin_log
/api/egress/tldialer/vicidial_agent_function_log
/api/egress/tldialer/vicidial_agent_function_log_archive
/api/egress/tldialer/vicidial_agent_log
/api/egress/tldialer/vicidial_agent_vmm_overrides
/api/egress/tldialer/vicidial_amd_log
/api/egress/tldialer/vicidial_amd_log_archive
/api/egress/tldialer/vicidial_api_log
/api/egress/tldialer/vicidial_api_urls
/api/egress/tldialer/vicidial_auto_calls
/api/egress/tldialer/vicidial_automated_reports
/api/egress/tldialer/vicidial_avatar_audio
/api/egress/tldialer/vicidial_avatars
/api/egress/tldialer/vicidial_bench_agent_log
/api/egress/tldialer/vicidial_call_menu
/api/egress/tldialer/vicidial_call_menu_options
/api/egress/tldialer/vicidial_call_time_holidays
/api/egress/tldialer/vicidial_call_times
/api/egress/tldialer/vicidial_campaign_agents
/api/egress/tldialer/vicidial_campaign_cid_areacodes
/api/egress/tldialer/vicidial_campaign_dnc
/api/egress/tldialer/vicidial_campaign_server_stats
/api/egress/tldialer/vicidial_campaign_stats
/api/egress/tldialer/vicidial_campaign_stats_debug
/api/egress/tldialer/vicidial_campaigns
/api/egress/tldialer/vicidial_carrier_log
/api/egress/tldialer/vicidial_carrier_log_archive
/api/egress/tldialer/vicidial_cid_groups
/api/egress/tldialer/vicidial_closer_log
/api/egress/tldialer/vicidial_closer_log_archive
/api/egress/tldialer/vicidial_conf_templates
/api/egress/tldialer/vicidial_conferences
/api/egress/tldialer/vicidial_custom_reports
/api/egress/tldialer/vicidial_daily_max_stats
/api/egress/tldialer/vicidial_dial_log
/api/egress/tldialer/vicidial_dial_log_archive
/api/egress/tldialer/vicidial_did_log
/api/egress/tldialer/vicidial_dnc
/api/egress/tldialer/vicidial_dnc_log
/api/egress/tldialer/vicidial_filter_phone_groups
/api/egress/tldialer/vicidial_filter_phone_numbers
/api/egress/tldialer/vicidial_grab_call_log
/api/egress/tldialer/vicidial_hopper
/api/egress/tldialer/vicidial_inbound_callback_queue
/api/egress/tldialer/vicidial_inbound_callback_queue_archive
/api/egress/tldialer/vicidial_inbound_dids
/api/egress/tldialer/vicidial_inbound_group_agents
/api/egress/tldialer/vicidial_inbound_groups
/api/egress/tldialer/vicidial_ip_list_entries
/api/egress/tldialer/vicidial_ip_lists
/api/egress/tldialer/vicidial_lead_call_quota_counts
/api/egress/tldialer/vicidial_lead_call_quota_counts_archive
/api/egress/tldialer/vicidial_lead_filters
/api/egress/tldialer/vicidial_lead_recycle
/api/egress/tldialer/vicidial_list
/api/egress/tldialer/vicidial_list_archive
/api/egress/tldialer/vicidial_lists
/api/egress/tldialer/vicidial_lists_custom
/api/egress/tldialer/vicidial_live_agents
/api/egress/tldialer/vicidial_live_inbound_agents
/api/egress/tldialer/vicidial_log
/api/egress/tldialer/vicidial_log_archive
/api/egress/tldialer/vicidial_log_extended_sip
/api/egress/tldialer/vicidial_log_extended_sip_archive
/api/egress/tldialer/vicidial_log_noanswer
/api/egress/tldialer/vicidial_log_noanswer_archive
/api/egress/tldialer/vicidial_manager
/api/egress/tldialer/vicidial_manual_dial_queue
/api/egress/tldialer/vicidial_outbound_ivr_log
/api/egress/tldialer/vicidial_outbound_ivr_log_archive
/api/egress/tldialer/vicidial_pause_codes
/api/egress/tldialer/vicidial_phone_codes
/api/egress/tldialer/vicidial_postal_codes
/api/egress/tldialer/vicidial_process_trigger_log
/api/egress/tldialer/vicidial_queue_groups
/api/egress/tldialer/vicidial_remote_agents
/api/egress/tldialer/vicidial_report_log
/api/egress/tldialer/vicidial_rt_monitor_log
/api/egress/tldialer/vicidial_scripts
/api/egress/tldialer/vicidial_session_data
/api/egress/tldialer/vicidial_sessions_recent
/api/egress/tldialer/vicidial_sessions_recent_archive
/api/egress/tldialer/vicidial_settings_containers
/api/egress/tldialer/vicidial_shifts
/api/egress/tldialer/vicidial_sip_action_log
/api/egress/tldialer/vicidial_sip_action_log_archive
/api/egress/tldialer/vicidial_sip_event_archive_details
/api/egress/tldialer/vicidial_sip_event_log
/api/egress/tldialer/vicidial_sip_event_recent
/api/egress/tldialer/vicidial_state_call_times
/api/egress/tldialer/vicidial_status_categories
/api/egress/tldialer/vicidial_status_groups
/api/egress/tldialer/vicidial_statuses
/api/egress/tldialer/vicidial_territories
/api/egress/tldialer/vicidial_url_log
/api/egress/tldialer/vicidial_url_multi
/api/egress/tldialer/vicidial_urls
/api/egress/tldialer/vicidial_user_closer_log
/api/egress/tldialer/vicidial_user_groups
/api/egress/tldialer/vicidial_user_log
/api/egress/tldialer/vicidial_user_territories
/api/egress/tldialer/vicidial_users
/api/egress/tldialer/vicidial_vmm_counts
/api/egress/tldialer/vicidial_vmm_counts_archive
/api/egress/tldialer/vicidial_voicemail
/api/egress/tldialer/vicidial_webservers
/api/egress/tldialer/vicidial_xfer_log
/api/egress/tldialer/vicidial_xfer_log_archive
/api/egress/tldialer/vicidial_xfer_presets
/api/egress/tldialer/vicidial_xfer_stats
/api/egress/tldialer/web_client_sessions

Programmatic List of Egress Endpoints

You can also get all Egress endpoints available via API. For Example if we want to get all TLDCRM endpoints available we would query /api/egress/endpoints. This would give us the list to the right. but with shortened keys and values of the endpoint. For a list of TLDialer Egress Endpoints you would use /api/egress/tldialer/endpoints with similar results.

Egress Endpoint Documentation

To find more Detailed information about Egress API Endpoints such as their structure and columns available you can query any endpoint and append /docs to the end. This works with TLDialer Egress endpoints as well! Lets look at an example with the Tags Endpoint. Remember this still requires an API ID and Key.

These Egress Endpoints are meant to be used with the TQL Query Language please see the documentation regarding this to understand it a bit more.

Lets use the Tags Schema as an Example

/api/egress/tags/docs

As you can see in the output on the right this will give us the basic structure of the table with it’s base table columns.

Here you can find the TQL Modifiers, Aggregates, and Tags used by the TQL Query Language to help you build complex and joined data queries.

If you want to Test what columns will be available after the import use the following Docs endpoint with your import and columns selector to see what will show up.

Get Schema Builder

/api/egress/tags/docs/build

Get All Base Columns

To get a list of all columns available with your parameters use:

/api/egress/tags/docs/columns

Get Specific Column

To see information related to a specific columns only use:

/api/egress/tags/docs/column/{column_name}

Get Base Columns

To get a list of all base level columns available for this endpoint use:

/api/egress/tags/docs/column/{column_name}

Get Base Pseudo Columns

To get a list of all base level columns available that are considered pseudo columns use:

/api/egress/tags/docs/pseudo

Get Base Pseudo / Non-Aggregate Columns

To get a list of all base level columns available that are considered pseudo columns but excludes aggregate columns use:

/api/egress/tags/docs/pseudo/only

Get Base Aggregate Columns

To get a list of all native aggregate columns available use:

/api/egress/tags/docs/aggregates

Get Base PHI Columns

To get a list of all native PHI flagged columns available use:

/api/egress/tags/docs/phi

Get Base PCI Columns

To get a list of all native PCI flagged columns available use:

/api/egress/tags/docs/pci

Get Base PHI Sensitive Columns

To get a list of all native PHI Sensitive flagged columns available use:

/api/egress/tags/docs/phi_sensitive

Get Base PCI Sensitive Columns

To get a list of all native PCI Sensitive flagged columns available use:

/api/egress/tags/docs/pci_sensitive

Docs Examples

{
    "response": {
        "results": {
            "agentcpa": "https:\/\/dev.tldcrm.dev\/api\/egress\/agentcpa",
            "carriers": "https:\/\/dev.tldcrm.dev\/api\/egress\/carriers",
            "change_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/change_logs",
            "commission_alignments": "https:\/\/dev.tldcrm.dev\/api\/egress\/commission_alignments",
            "commission_paid": "https:\/\/dev.tldcrm.dev\/api\/egress\/commission_paid",
            "commission_received": "https:\/\/dev.tldcrm.dev\/api\/egress\/commission_received",
            "csr": "https:\/\/dev.tldcrm.dev\/api\/egress\/csr",
            "dependent_field": "https:\/\/dev.tldcrm.dev\/api\/egress\/dependent_field",
            "dependent_fields": "https:\/\/dev.tldcrm.dev\/api\/egress\/dependent_fields",
            "dependents": "https:\/\/dev.tldcrm.dev\/api\/egress\/dependents",
            "dialer_leads": "https:\/\/dev.tldcrm.dev\/api\/egress\/dialer_leads",
            "dnc": "https:\/\/dev.tldcrm.dev\/api\/egress\/dnc",
            "document_downloads": "https:\/\/dev.tldcrm.dev\/api\/egress\/document_downloads",
            "documents": "https:\/\/dev.tldcrm.dev\/api\/egress\/documents",
            "documents\/{document_id}": "https:\/\/dev.tldcrm.dev\/api\/egress\/documents\/{document_id}",
            "documents\/{document_id}\/download": "https:\/\/dev.tldcrm.dev\/api\/egress\/documents\/{document_id}\/download",
            "esign": "https:\/\/dev.tldcrm.dev\/api\/egress\/esign",
            "esign_events": "https:\/\/dev.tldcrm.dev\/api\/egress\/esign_events",
            "fema": "https:\/\/dev.tldcrm.dev\/api\/egress\/fema",
            "filters": "https:\/\/dev.tldcrm.dev\/api\/egress\/filters",
            "fpg": "https:\/\/dev.tldcrm.dev\/api\/egress\/fpg",
            "lead_dependents": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_dependents",
            "lead_dialer_leads": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_dialer_leads",
            "lead_field": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_field",
            "lead_fields": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_fields",
            "lead_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_logs",
            "lead_notes": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_notes",
            "lead_policies": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_policies",
            "lead_protected_view_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_protected_view_logs",
            "lead_view_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/lead_view_logs",
            "leads": "https:\/\/dev.tldcrm.dev\/api\/egress\/leads",
            "note_field": "https:\/\/dev.tldcrm.dev\/api\/egress\/note_field",
            "note_fields": "https:\/\/dev.tldcrm.dev\/api\/egress\/note_fields",
            "notes": "https:\/\/dev.tldcrm.dev\/api\/egress\/notes",
            "notifications": "https:\/\/dev.tldcrm.dev\/api\/egress\/notifications",
            "policies": "https:\/\/dev.tldcrm.dev\/api\/egress\/policies",
            "policy_field": "https:\/\/dev.tldcrm.dev\/api\/egress\/policy_field",
            "policy_fields": "https:\/\/dev.tldcrm.dev\/api\/egress\/policy_fields",
            "products": "https:\/\/dev.tldcrm.dev\/api\/egress\/products",
            "protected_view_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/protected_view_logs",
            "tag_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/tag_logs",
            "tag_members": "https:\/\/dev.tldcrm.dev\/api\/egress\/tag_members",
            "tags": "https:\/\/dev.tldcrm.dev\/api\/egress\/tags",
            "user_contracts": "https:\/\/dev.tldcrm.dev\/api\/egress\/user_contracts",
            "user_group_members": "https:\/\/dev.tldcrm.dev\/api\/egress\/user_group_members",
            "user_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/user_groups",
            "user_licenses": "https:\/\/dev.tldcrm.dev\/api\/egress\/user_licenses",
            "users": "https:\/\/dev.tldcrm.dev\/api\/egress\/users",
            "vendor_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/vendor_logs",
            "vendorperformance": "https:\/\/dev.tldcrm.dev\/api\/egress\/vendorperformance",
            "vendors": "https:\/\/dev.tldcrm.dev\/api\/egress\/vendors",
            "view_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/view_logs"
        }
    },
    "debug": {
        "time": "0.1011s",
        "memory": "918.22 KB",
        "peak": "1.15 MB",
        "method": "GET",
        "code": 200
    }
}

{
    "response": {
        "results": {
            "agency_call_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/agency_call_log",
            "audio_store_details": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/audio_store_details",
            "call_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/call_log",
            "call_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/call_log_archive",
            "conferences": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/conferences",
            "join_campaigns": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_campaigns",
            "join_dids": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_dids",
            "join_ingroups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_ingroups",
            "join_list": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_list",
            "join_lists": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_lists",
            "join_statuses": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_statuses",
            "join_user_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_user_groups",
            "join_users": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_users",
            "join_users_nogroup": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/join_users_nogroup",
            "leave_vm_message_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/leave_vm_message_groups",
            "leave_vm_message_groups_entries": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/leave_vm_message_groups_entries",
            "live_channels": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/live_channels",
            "live_inbound_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/live_inbound_log",
            "live_sip_channels": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/live_sip_channels",
            "park_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/park_log",
            "parked_channels": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/parked_channels",
            "parked_channels_recent": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/parked_channels_recent",
            "phones": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/phones",
            "phones_alias": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/phones_alias",
            "recording_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/recording_log",
            "report_agentcpa": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/report_agentcpa",
            "servers": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/servers",
            "servers_join": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/servers_join",
            "system_settings": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/system_settings",
            "tldialer_backup_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_backup_logs",
            "tldialer_call_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_call_log",
            "tldialer_call_log_costs": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_call_log_costs",
            "tldialer_call_log_dupes": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_call_log_dupes",
            "tldialer_campaigns_meta": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_campaigns_meta",
            "tldialer_cid_history": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_cid_history",
            "tldialer_closer_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_closer_log",
            "tldialer_external_xfer_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_external_xfer_log",
            "tldialer_first_contacts": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_first_contacts",
            "tldialer_fpg_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_fpg_log",
            "tldialer_inbound_block_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_inbound_block_log",
            "tldialer_inbound_dids_pricing": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_inbound_dids_pricing",
            "tldialer_lists_meta": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_lists_meta",
            "tldialer_live_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_live_agents",
            "tldialer_meta": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_meta",
            "tldialer_meta_definitions": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_meta_definitions",
            "tldialer_queue_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_queue_logs",
            "tldialer_reset_log_details": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_reset_log_details",
            "tldialer_reset_logs": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_reset_logs",
            "tldialer_users_meta": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_users_meta",
            "tldialer_whitelist": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_whitelist",
            "tldialer_xfer_presets": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/tldialer_xfer_presets",
            "twoday_vicidial_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/twoday_vicidial_log",
            "user_call_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/user_call_log",
            "user_call_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/user_call_log_archive",
            "vicidial_admin_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_admin_log",
            "vicidial_agent_function_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_agent_function_log",
            "vicidial_agent_function_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_agent_function_log_archive",
            "vicidial_agent_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_agent_log",
            "vicidial_agent_vmm_overrides": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_agent_vmm_overrides",
            "vicidial_amd_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_amd_log",
            "vicidial_amd_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_amd_log_archive",
            "vicidial_api_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_api_log",
            "vicidial_api_urls": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_api_urls",
            "vicidial_auto_calls": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_auto_calls",
            "vicidial_automated_reports": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_automated_reports",
            "vicidial_avatar_audio": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_avatar_audio",
            "vicidial_avatars": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_avatars",
            "vicidial_bench_agent_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_bench_agent_log",
            "vicidial_call_menu": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_call_menu",
            "vicidial_call_menu_options": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_call_menu_options",
            "vicidial_call_time_holidays": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_call_time_holidays",
            "vicidial_call_times": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_call_times",
            "vicidial_campaign_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_agents",
            "vicidial_campaign_cid_areacodes": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_cid_areacodes",
            "vicidial_campaign_dnc": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_dnc",
            "vicidial_campaign_server_stats": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_server_stats",
            "vicidial_campaign_stats": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_stats",
            "vicidial_campaign_stats_debug": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaign_stats_debug",
            "vicidial_campaigns": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_campaigns",
            "vicidial_carrier_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_carrier_log",
            "vicidial_carrier_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_carrier_log_archive",
            "vicidial_cid_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_cid_groups",
            "vicidial_closer_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_closer_log",
            "vicidial_closer_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_closer_log_archive",
            "vicidial_conf_templates": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_conf_templates",
            "vicidial_conferences": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_conferences",
            "vicidial_custom_reports": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_custom_reports",
            "vicidial_daily_max_stats": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_daily_max_stats",
            "vicidial_dial_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_dial_log",
            "vicidial_dial_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_dial_log_archive",
            "vicidial_did_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_did_log",
            "vicidial_dnc": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_dnc",
            "vicidial_dnc_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_dnc_log",
            "vicidial_filter_phone_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_filter_phone_groups",
            "vicidial_filter_phone_numbers": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_filter_phone_numbers",
            "vicidial_grab_call_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_grab_call_log",
            "vicidial_hopper": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_hopper",
            "vicidial_inbound_callback_queue": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_inbound_callback_queue",
            "vicidial_inbound_callback_queue_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_inbound_callback_queue_archive",
            "vicidial_inbound_dids": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_inbound_dids",
            "vicidial_inbound_group_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_inbound_group_agents",
            "vicidial_inbound_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_inbound_groups",
            "vicidial_ip_list_entries": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_ip_list_entries",
            "vicidial_ip_lists": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_ip_lists",
            "vicidial_lead_call_quota_counts": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lead_call_quota_counts",
            "vicidial_lead_call_quota_counts_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lead_call_quota_counts_archive",
            "vicidial_lead_filters": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lead_filters",
            "vicidial_lead_recycle": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lead_recycle",
            "vicidial_list": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_list",
            "vicidial_list_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_list_archive",
            "vicidial_lists": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lists",
            "vicidial_lists_custom": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_lists_custom",
            "vicidial_live_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_live_agents",
            "vicidial_live_inbound_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_live_inbound_agents",
            "vicidial_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log",
            "vicidial_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log_archive",
            "vicidial_log_extended_sip": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log_extended_sip",
            "vicidial_log_extended_sip_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log_extended_sip_archive",
            "vicidial_log_noanswer": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log_noanswer",
            "vicidial_log_noanswer_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_log_noanswer_archive",
            "vicidial_manager": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_manager",
            "vicidial_manual_dial_queue": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_manual_dial_queue",
            "vicidial_outbound_ivr_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_outbound_ivr_log",
            "vicidial_outbound_ivr_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_outbound_ivr_log_archive",
            "vicidial_pause_codes": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_pause_codes",
            "vicidial_phone_codes": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_phone_codes",
            "vicidial_postal_codes": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_postal_codes",
            "vicidial_process_trigger_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_process_trigger_log",
            "vicidial_queue_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_queue_groups",
            "vicidial_remote_agents": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_remote_agents",
            "vicidial_report_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_report_log",
            "vicidial_rt_monitor_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_rt_monitor_log",
            "vicidial_scripts": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_scripts",
            "vicidial_session_data": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_session_data",
            "vicidial_sessions_recent": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sessions_recent",
            "vicidial_sessions_recent_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sessions_recent_archive",
            "vicidial_settings_containers": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_settings_containers",
            "vicidial_shifts": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_shifts",
            "vicidial_sip_action_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_action_log",
            "vicidial_sip_action_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_action_log_archive",
            "vicidial_sip_event_archive_details": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_archive_details",
            "vicidial_sip_event_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log",
            "vicidial_sip_event_log_0": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_0",
            "vicidial_sip_event_log_1": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_1",
            "vicidial_sip_event_log_2": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_2",
            "vicidial_sip_event_log_3": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_3",
            "vicidial_sip_event_log_4": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_4",
            "vicidial_sip_event_log_5": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_5",
            "vicidial_sip_event_log_6": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_log_6",
            "vicidial_sip_event_recent": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_sip_event_recent",
            "vicidial_state_call_times": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_state_call_times",
            "vicidial_status_categories": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_status_categories",
            "vicidial_status_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_status_groups",
            "vicidial_statuses": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_statuses",
            "vicidial_territories": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_territories",
            "vicidial_url_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_url_log",
            "vicidial_url_multi": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_url_multi",
            "vicidial_urls": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_urls",
            "vicidial_user_closer_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_user_closer_log",
            "vicidial_user_groups": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_user_groups",
            "vicidial_user_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_user_log",
            "vicidial_user_territories": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_user_territories",
            "vicidial_users": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_users",
            "vicidial_vmm_counts": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_vmm_counts",
            "vicidial_vmm_counts_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_vmm_counts_archive",
            "vicidial_voicemail": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_voicemail",
            "vicidial_webservers": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_webservers",
            "vicidial_xfer_log": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_xfer_log",
            "vicidial_xfer_log_archive": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_xfer_log_archive",
            "vicidial_xfer_presets": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_xfer_presets",
            "vicidial_xfer_stats": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/vicidial_xfer_stats",
            "web_client_sessions": "https:\/\/dev.tldcrm.dev\/api\/egress\/tldialer\/web_client_sessions"
        }
    },
    "debug": {
        "time": "0.1015s",
        "memory": "948.37 KB",
        "peak": "1.15 MB",
        "method": "GET",
        "code": 200
    }
}

{
    "response": {
        "schema": "tags",
        "table": "tags",
        "params": [],
        "results": {
            "tag_id": {
                "name": "tag_id",
                "label": "Tag ID",
                "attributes": [
                    "base",
                    "primary",
                    "increment"
                ],
                "keys": [
                    "tag_id",
                    "tag_id_has",
                    "tag_id_greater",
                    "tag_id_less",
                    "tag_id_less_equal",
                    "tag_id_greater_equal",
                    "tag_id_in",
                    "tag_id_not",
                    "tag_id_in_not",
                    "tag_id_end",
                    "tag_id_end_not",
                    "tag_id_between",
                    "tag_id_not_between",
                    "tag_id_between_not"
                ],
                "modifiers": {
                    "key": "tag_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_tag_id",
                    "count_unique": "tql_cnu_tag_id",
                    "compiled": "tql_cmp_tag_id",
                    "compiled_unique": "tql_cmu_tag_id",
                    "compiled_last": "tql_cml_tag_id",
                    "compiled_first": "tql_cmf_tag_id",
                    "minimum": "tql_min_tag_id",
                    "maximum": "tql_max_tag_id",
                    "sum": "tql_sum_tag_id",
                    "average": "tql_avg_tag_id"
                },
                "type": [
                    "number"
                ],
                "default": ""
            },
            "account_id": {
                "name": "account_id",
                "label": "Account ID",
                "attributes": [
                    "base"
                ],
                "keys": [
                    "account_id",
                    "account_id_has",
                    "account_id_greater",
                    "account_id_less",
                    "account_id_less_equal",
                    "account_id_greater_equal",
                    "account_id_in",
                    "account_id_not",
                    "account_id_in_not",
                    "account_id_end",
                    "account_id_end_not",
                    "account_id_between",
                    "account_id_not_between",
                    "account_id_between_not"
                ],
                "modifiers": {
                    "key": "account_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_account_id",
                    "count_unique": "tql_cnu_account_id",
                    "compiled": "tql_cmp_account_id",
                    "compiled_unique": "tql_cmu_account_id",
                    "compiled_last": "tql_cml_account_id",
                    "compiled_first": "tql_cmf_account_id",
                    "minimum": "tql_min_account_id",
                    "maximum": "tql_max_account_id",
                    "sum": "tql_sum_account_id",
                    "average": "tql_avg_account_id"
                },
                "type": [
                    "number"
                ],
                "default": 0
            },
            "date_created": {
                "name": "date_created",
                "label": "Date Created",
                "attributes": [
                    "base"
                ],
                "keys": [
                    "date_created",
                    "date_created_has",
                    "date_created_greater",
                    "date_created_less",
                    "date_created_less_equal",
                    "date_created_greater_equal",
                    "date_created_not",
                    "date_created_end_not",
                    "date_created_future",
                    "date_created_past",
                    "date_created_today",
                    "date_created_yesterday",
                    "date_created_hour",
                    "date_created_day",
                    "date_created_week",
                    "date_created_month",
                    "date_created_quarter"
                ],
                "modifiers": {
                    "key": "date_created_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_date_created",
                    "count_unique": "tql_cnu_date_created",
                    "compiled": "tql_cmp_date_created",
                    "compiled_unique": "tql_cmu_date_created",
                    "compiled_last": "tql_cml_date_created",
                    "compiled_first": "tql_cmf_date_created",
                    "minimum": "tql_min_date_created",
                    "maximum": "tql_max_date_created",
                    "yearspan": "tql_spy_date_created",
                    "quarterspan": "tql_spq_date_created",
                    "monthspan": "tql_spm_date_created",
                    "weekspan": "tql_spw_date_created",
                    "dayspan": "tql_spd_date_created",
                    "minutespan": "tql_spi_date_created",
                    "secondspan": "tql_sps_date_created"
                },
                "type": [
                    "timestamp"
                ],
                "default": false
            },
            "date_modified": {
                "name": "date_modified",
                "label": "Date Modified",
                "attributes": [
                    "base"
                ],
                "keys": [
                    "date_modified",
                    "date_modified_has",
                    "date_modified_greater",
                    "date_modified_less",
                    "date_modified_less_equal",
                    "date_modified_greater_equal",
                    "date_modified_not",
                    "date_modified_end_not",
                    "date_modified_future",
                    "date_modified_past",
                    "date_modified_today",
                    "date_modified_yesterday",
                    "date_modified_hour",
                    "date_modified_day",
                    "date_modified_week",
                    "date_modified_month",
                    "date_modified_quarter"
                ],
                "modifiers": {
                    "key": "date_modified_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_date_modified",
                    "count_unique": "tql_cnu_date_modified",
                    "compiled": "tql_cmp_date_modified",
                    "compiled_unique": "tql_cmu_date_modified",
                    "compiled_last": "tql_cml_date_modified",
                    "compiled_first": "tql_cmf_date_modified",
                    "minimum": "tql_min_date_modified",
                    "maximum": "tql_max_date_modified",
                    "yearspan": "tql_spy_date_modified",
                    "quarterspan": "tql_spq_date_modified",
                    "monthspan": "tql_spm_date_modified",
                    "weekspan": "tql_spw_date_modified",
                    "dayspan": "tql_spd_date_modified",
                    "minutespan": "tql_spi_date_modified",
                    "secondspan": "tql_sps_date_modified"
                },
                "type": [
                    "timestamp"
                ],
                "default": false
            },
            "creator_id": {
                "name": "creator_id",
                "label": "Creator ID",
                "imports": {
                    "creator": {
                        "prefix": "creator_",
                        "label": "Creator",
                        "key": [
                            "creator_id"
                        ],
                        "tags": [
                            "users",
                            "tag_users",
                            "creator",
                            "tag_creator",
                            "all"
                        ],
                        "table": "users"
                    }
                },
                "attributes": [
                    "base",
                    "null"
                ],
                "keys": [
                    "creator_id",
                    "creator_id_has",
                    "creator_id_greater",
                    "creator_id_less",
                    "creator_id_less_equal",
                    "creator_id_greater_equal",
                    "creator_id_in",
                    "creator_id_not",
                    "creator_id_in_not",
                    "creator_id_end",
                    "creator_id_end_not",
                    "creator_id_between",
                    "creator_id_not_between",
                    "creator_id_between_not"
                ],
                "modifiers": {
                    "key": "creator_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_creator_id",
                    "count_unique": "tql_cnu_creator_id",
                    "compiled": "tql_cmp_creator_id",
                    "compiled_unique": "tql_cmu_creator_id",
                    "compiled_last": "tql_cml_creator_id",
                    "compiled_first": "tql_cmf_creator_id",
                    "minimum": "tql_min_creator_id",
                    "maximum": "tql_max_creator_id",
                    "sum": "tql_sum_creator_id",
                    "average": "tql_avg_creator_id"
                },
                "type": [
                    "number"
                ],
                "options": "users",
                "default": "NULL"
            },
            "modifier_id": {
                "name": "modifier_id",
                "label": "Modifier ID",
                "imports": {
                    "modifier": {
                        "prefix": "modifier_",
                        "label": "Modifier",
                        "key": [
                            "modifier_id"
                        ],
                        "tags": [
                            "users",
                            "tag_users",
                            "modifier",
                            "tag_modifier",
                            "all"
                        ],
                        "table": "users"
                    }
                },
                "attributes": [
                    "base",
                    "null"
                ],
                "keys": [
                    "modifier_id",
                    "modifier_id_has",
                    "modifier_id_greater",
                    "modifier_id_less",
                    "modifier_id_less_equal",
                    "modifier_id_greater_equal",
                    "modifier_id_in",
                    "modifier_id_not",
                    "modifier_id_in_not",
                    "modifier_id_end",
                    "modifier_id_end_not",
                    "modifier_id_between",
                    "modifier_id_not_between",
                    "modifier_id_between_not"
                ],
                "modifiers": {
                    "key": "modifier_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_modifier_id",
                    "count_unique": "tql_cnu_modifier_id",
                    "compiled": "tql_cmp_modifier_id",
                    "compiled_unique": "tql_cmu_modifier_id",
                    "compiled_last": "tql_cml_modifier_id",
                    "compiled_first": "tql_cmf_modifier_id",
                    "minimum": "tql_min_modifier_id",
                    "maximum": "tql_max_modifier_id",
                    "sum": "tql_sum_modifier_id",
                    "average": "tql_avg_modifier_id"
                },
                "type": [
                    "number"
                ],
                "options": "users",
                "default": "NULL"
            },
            "manual_id": {
                "name": "manual_id",
                "label": "Manual ID",
                "imports": {
                    "manual": {
                        "prefix": "manual_",
                        "label": "Manual",
                        "key": [
                            "id"
                        ],
                        "tags": [
                            "type",
                            "fields",
                            "tag_fields",
                            "tag_manual",
                            "all"
                        ],
                        "table": "meta"
                    }
                },
                "attributes": [
                    "base"
                ],
                "keys": [
                    "manual_id",
                    "manual_id_has",
                    "manual_id_greater",
                    "manual_id_less",
                    "manual_id_less_equal",
                    "manual_id_greater_equal",
                    "manual_id_in",
                    "manual_id_not",
                    "manual_id_in_not",
                    "manual_id_end",
                    "manual_id_end_not",
                    "manual_id_between",
                    "manual_id_not_between",
                    "manual_id_between_not"
                ],
                "modifiers": {
                    "key": "manual_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_manual_id",
                    "count_unique": "tql_cnu_manual_id",
                    "compiled": "tql_cmp_manual_id",
                    "compiled_unique": "tql_cmu_manual_id",
                    "compiled_last": "tql_cml_manual_id",
                    "compiled_first": "tql_cmf_manual_id",
                    "minimum": "tql_min_manual_id",
                    "maximum": "tql_max_manual_id",
                    "sum": "tql_sum_manual_id",
                    "average": "tql_avg_manual_id"
                },
                "type": [
                    "number"
                ],
                "options": "tag_manual",
                "default": 0
            },
            "status_id": {
                "name": "status_id",
                "label": "Status",
                "imports": {
                    "status": {
                        "prefix": "status_",
                        "label": "Status",
                        "key": [
                            "id"
                        ],
                        "tags": [
                            "type",
                            "fields",
                            "tag_fields",
                            "tag_status",
                            "all"
                        ],
                        "table": "meta"
                    }
                },
                "attributes": [
                    "base"
                ],
                "keys": [
                    "status_id",
                    "status_id_has",
                    "status_id_greater",
                    "status_id_less",
                    "status_id_less_equal",
                    "status_id_greater_equal",
                    "status_id_in",
                    "status_id_not",
                    "status_id_in_not",
                    "status_id_end",
                    "status_id_end_not",
                    "status_id_between",
                    "status_id_not_between",
                    "status_id_between_not"
                ],
                "modifiers": {
                    "key": "status_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_status_id",
                    "count_unique": "tql_cnu_status_id",
                    "compiled": "tql_cmp_status_id",
                    "compiled_unique": "tql_cmu_status_id",
                    "compiled_last": "tql_cml_status_id",
                    "compiled_first": "tql_cmf_status_id",
                    "minimum": "tql_min_status_id",
                    "maximum": "tql_max_status_id",
                    "sum": "tql_sum_status_id",
                    "average": "tql_avg_status_id"
                },
                "type": [
                    "number"
                ],
                "options": "tag_status",
                "default": 1
            },
            "name": {
                "name": "name",
                "label": "Name",
                "attributes": [
                    "base",
                    "null"
                ],
                "keys": [
                    "name",
                    "name_has",
                    "name_like",
                    "name_in",
                    "name_not",
                    "name_in_not",
                    "name_like_not"
                ],
                "modifiers": {
                    "key": "name_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_name",
                    "count_unique": "tql_cnu_name",
                    "compiled": "tql_cmp_name",
                    "compiled_unique": "tql_cmu_name",
                    "compiled_last": "tql_cml_name",
                    "compiled_first": "tql_cmf_name",
                    "minimum": "tql_min_name",
                    "maximum": "tql_max_name"
                },
                "type": [
                    "string"
                ],
                "default": "NULL"
            },
            "description": {
                "name": "description",
                "label": "Description",
                "attributes": [
                    "base",
                    "null"
                ],
                "keys": [
                    "description",
                    "description_has",
                    "description_like",
                    "description_in",
                    "description_not",
                    "description_in_not",
                    "description_like_not"
                ],
                "modifiers": {
                    "key": "description_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_description",
                    "count_unique": "tql_cnu_description",
                    "compiled": "tql_cmp_description",
                    "compiled_unique": "tql_cmu_description",
                    "compiled_last": "tql_cml_description",
                    "compiled_first": "tql_cmf_description",
                    "minimum": "tql_min_description",
                    "maximum": "tql_max_description"
                },
                "type": [
                    "string"
                ],
                "default": "NULL"
            },
            "category_id": {
                "name": "category_id",
                "label": "Category ID",
                "imports": {
                    "category": {
                        "prefix": "category_",
                        "label": "Category",
                        "key": [
                            "category_id",
                            "account_id"
                        ],
                        "tags": [
                            "type",
                            "fields",
                            "tag_fields",
                            "tag_category",
                            "tag_categories",
                            "all"
                        ],
                        "table": "tag_categories"
                    }
                },
                "attributes": [
                    "base",
                    "null"
                ],
                "keys": [
                    "category_id",
                    "category_id_has",
                    "category_id_greater",
                    "category_id_less",
                    "category_id_less_equal",
                    "category_id_greater_equal",
                    "category_id_in",
                    "category_id_not",
                    "category_id_in_not",
                    "category_id_end",
                    "category_id_end_not",
                    "category_id_between",
                    "category_id_not_between",
                    "category_id_between_not"
                ],
                "modifiers": {
                    "key": "category_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_category_id",
                    "count_unique": "tql_cnu_category_id",
                    "compiled": "tql_cmp_category_id",
                    "compiled_unique": "tql_cmu_category_id",
                    "compiled_last": "tql_cml_category_id",
                    "compiled_first": "tql_cmf_category_id",
                    "minimum": "tql_min_category_id",
                    "maximum": "tql_max_category_id",
                    "sum": "tql_sum_category_id",
                    "average": "tql_avg_category_id"
                },
                "type": [
                    "number"
                ],
                "options": "tag_categories",
                "default": "NULL"
            },
            "type_id": {
                "name": "type_id",
                "label": "Type ID",
                "imports": {
                    "type": {
                        "prefix": "type_",
                        "label": "Type",
                        "key": [
                            "id"
                        ],
                        "tags": [
                            "type",
                            "fields",
                            "tag_fields",
                            "tag_type",
                            "all"
                        ],
                        "table": "meta"
                    }
                },
                "attributes": [
                    "base"
                ],
                "keys": [
                    "type_id",
                    "type_id_has",
                    "type_id_greater",
                    "type_id_less",
                    "type_id_less_equal",
                    "type_id_greater_equal",
                    "type_id_in",
                    "type_id_not",
                    "type_id_in_not",
                    "type_id_end",
                    "type_id_end_not",
                    "type_id_between",
                    "type_id_not_between",
                    "type_id_between_not"
                ],
                "modifiers": {
                    "key": "type_id_tql",
                    "options": [
                        "not",
                        "greater",
                        "less",
                        "greater_equal",
                        "less_equal"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_type_id",
                    "count_unique": "tql_cnu_type_id",
                    "compiled": "tql_cmp_type_id",
                    "compiled_unique": "tql_cmu_type_id",
                    "compiled_last": "tql_cml_type_id",
                    "compiled_first": "tql_cmf_type_id",
                    "minimum": "tql_min_type_id",
                    "maximum": "tql_max_type_id",
                    "sum": "tql_sum_type_id",
                    "average": "tql_avg_type_id"
                },
                "type": [
                    "number"
                ],
                "options": "tag_type",
                "default": 0
            },
            "ids": {
                "name": "ids",
                "label": "IDs",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "ids",
                    "ids_has",
                    "ids_like",
                    "ids_in",
                    "ids_not",
                    "ids_in_not",
                    "ids_like_not"
                ],
                "modifiers": {
                    "key": "ids_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_ids",
                    "count_unique": "tql_cnu_ids",
                    "compiled": "tql_cmp_ids",
                    "compiled_unique": "tql_cmu_ids",
                    "compiled_last": "tql_cml_ids",
                    "compiled_first": "tql_cmf_ids",
                    "minimum": "tql_min_ids",
                    "maximum": "tql_max_ids"
                },
                "type": [
                    "string",
                    "aggregate"
                ],
                "default": ""
            },
            "names": {
                "name": "names",
                "label": "Names",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "names",
                    "names_has",
                    "names_like",
                    "names_in",
                    "names_not",
                    "names_in_not",
                    "names_like_not"
                ],
                "modifiers": {
                    "key": "names_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_names",
                    "count_unique": "tql_cnu_names",
                    "compiled": "tql_cmp_names",
                    "compiled_unique": "tql_cmu_names",
                    "compiled_last": "tql_cml_names",
                    "compiled_first": "tql_cmf_names",
                    "minimum": "tql_min_names",
                    "maximum": "tql_max_names"
                },
                "type": [
                    "string",
                    "aggregate"
                ],
                "default": ""
            },
            "descriptions": {
                "name": "descriptions",
                "label": "Descriptions",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "descriptions",
                    "descriptions_has",
                    "descriptions_like",
                    "descriptions_in",
                    "descriptions_not",
                    "descriptions_in_not",
                    "descriptions_like_not"
                ],
                "modifiers": {
                    "key": "descriptions_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_descriptions",
                    "count_unique": "tql_cnu_descriptions",
                    "compiled": "tql_cmp_descriptions",
                    "compiled_unique": "tql_cmu_descriptions",
                    "compiled_last": "tql_cml_descriptions",
                    "compiled_first": "tql_cmf_descriptions",
                    "minimum": "tql_min_descriptions",
                    "maximum": "tql_max_descriptions"
                },
                "type": [
                    "string",
                    "aggregate"
                ],
                "default": ""
            },
            "is_active": {
                "name": "is_active",
                "label": "Is Active?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_active",
                    "is_active_has",
                    "is_active_missing"
                ],
                "modifiers": {
                    "key": "is_active_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_active",
                    "count_unique": "tql_cnu_is_active",
                    "compiled": "tql_cmp_is_active",
                    "compiled_unique": "tql_cmu_is_active",
                    "compiled_last": "tql_cml_is_active",
                    "compiled_first": "tql_cmf_is_active",
                    "minimum": "tql_min_is_active",
                    "maximum": "tql_max_is_active",
                    "sum": "tql_sum_is_active",
                    "average": "tql_avg_is_active"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "is_addable": {
                "name": "is_addable",
                "label": "Is Addable?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_addable",
                    "is_addable_has",
                    "is_addable_missing"
                ],
                "modifiers": {
                    "key": "is_addable_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_addable",
                    "count_unique": "tql_cnu_is_addable",
                    "compiled": "tql_cmp_is_addable",
                    "compiled_unique": "tql_cmu_is_addable",
                    "compiled_last": "tql_cml_is_addable",
                    "compiled_first": "tql_cmf_is_addable",
                    "minimum": "tql_min_is_addable",
                    "maximum": "tql_max_is_addable",
                    "sum": "tql_sum_is_addable",
                    "average": "tql_avg_is_addable"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "is_removable": {
                "name": "is_removable",
                "label": "Is Removable?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_removable",
                    "is_removable_has",
                    "is_removable_missing"
                ],
                "modifiers": {
                    "key": "is_removable_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_removable",
                    "count_unique": "tql_cnu_is_removable",
                    "compiled": "tql_cmp_is_removable",
                    "compiled_unique": "tql_cmu_is_removable",
                    "compiled_last": "tql_cml_is_removable",
                    "compiled_first": "tql_cmf_is_removable",
                    "minimum": "tql_min_is_removable",
                    "maximum": "tql_max_is_removable",
                    "sum": "tql_sum_is_removable",
                    "average": "tql_avg_is_removable"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "is_droppable": {
                "name": "is_droppable",
                "label": "Is Droppable?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_droppable",
                    "is_droppable_has",
                    "is_droppable_missing"
                ],
                "modifiers": {
                    "key": "is_droppable_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_droppable",
                    "count_unique": "tql_cnu_is_droppable",
                    "compiled": "tql_cmp_is_droppable",
                    "compiled_unique": "tql_cmu_is_droppable",
                    "compiled_last": "tql_cml_is_droppable",
                    "compiled_first": "tql_cmf_is_droppable",
                    "minimum": "tql_min_is_droppable",
                    "maximum": "tql_max_is_droppable",
                    "sum": "tql_sum_is_droppable",
                    "average": "tql_avg_is_droppable"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "is_addable_manual": {
                "name": "is_addable_manual",
                "label": "Is Addable Manually?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_addable_manual",
                    "is_addable_manual_has",
                    "is_addable_manual_missing"
                ],
                "modifiers": {
                    "key": "is_addable_manual_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_addable_manual",
                    "count_unique": "tql_cnu_is_addable_manual",
                    "compiled": "tql_cmp_is_addable_manual",
                    "compiled_unique": "tql_cmu_is_addable_manual",
                    "compiled_last": "tql_cml_is_addable_manual",
                    "compiled_first": "tql_cmf_is_addable_manual",
                    "minimum": "tql_min_is_addable_manual",
                    "maximum": "tql_max_is_addable_manual",
                    "sum": "tql_sum_is_addable_manual",
                    "average": "tql_avg_is_addable_manual"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "is_removable_manual": {
                "name": "is_removable_manual",
                "label": "Is Removable Manually?",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "is_removable_manual",
                    "is_removable_manual_has",
                    "is_removable_manual_missing"
                ],
                "modifiers": {
                    "key": "is_removable_manual_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_is_removable_manual",
                    "count_unique": "tql_cnu_is_removable_manual",
                    "compiled": "tql_cmp_is_removable_manual",
                    "compiled_unique": "tql_cmu_is_removable_manual",
                    "compiled_last": "tql_cml_is_removable_manual",
                    "compiled_first": "tql_cmf_is_removable_manual",
                    "minimum": "tql_min_is_removable_manual",
                    "maximum": "tql_max_is_removable_manual",
                    "sum": "tql_sum_is_removable_manual",
                    "average": "tql_avg_is_removable_manual"
                },
                "type": [
                    "boolean"
                ],
                "default": false
            },
            "category_ids": {
                "name": "category_ids",
                "label": "Category IDs",
                "attributes": [
                    "pseudo"
                ],
                "keys": [
                    "category_ids",
                    "category_ids_has",
                    "category_ids_like",
                    "category_ids_in",
                    "category_ids_not",
                    "category_ids_in_not",
                    "category_ids_like_not"
                ],
                "modifiers": {
                    "key": "category_ids_tql",
                    "options": [
                        "not",
                        "in",
                        "in_not",
                        "like",
                        "like_left",
                        "like_right",
                        "like_not",
                        "like_left_not",
                        "like_right_not"
                    ]
                },
                "aggregates": {
                    "count": "tql_cnt_category_ids",
                    "count_unique": "tql_cnu_category_ids",
                    "compiled": "tql_cmp_category_ids",
                    "compiled_unique": "tql_cmu_category_ids",
                    "compiled_last": "tql_cml_category_ids",
                    "compiled_first": "tql_cmf_category_ids",
                    "minimum": "tql_min_category_ids",
                    "maximum": "tql_max_category_ids"
                },
                "type": [
                    "string",
                    "aggregate"
                ],
                "default": ""
            }
        }
    },
    "debug": {
        "time": "0.1005s",
        "memory": "1.03 MB",
        "peak": "1.15 MB",
        "method": "GET",
        "code": 200
    }
}