- Created by Alexander Conroy , last modified by Eric Solomon on May 29, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 11 Current »
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.
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/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_no
group/api/egress/tldialer/leave_vm_message_gro
ups/api/egress/tldialer/leave_vm_message_groups_e
ntries/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 } }
{ "response": { "schema": "tags", "table": "tags", "params": { "import": [ "tag_fields", "users", "user_meta" ] }, "results": { "name": "tag_id", "label": "Tag ID", "attributes": [ "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": "" } }, "debug": { "time": "0.1249s", "memory": "3.13 MB", "peak": "4.58 MB", "method": "GET", "code": 200 } }
{ "response": { "schema": "tags", "table": "tags", "params": { "import": [ "tag_fields", "users", "user_meta" ] }, "results": [ "tag_id", "account_id", "date_created", "date_modified", "creator_id", "modifier_id", "manual_id", "status_id", "name", "description", "category_id", "type_id", "ids", "names", "descriptions", "is_active", "is_addable", "is_removable", "is_droppable", "is_addable_manual", "is_removable_manual", "category_ids", "creator_user_id", "creator_date_created", "creator_date_modified", "creator_date_activated", "creator_date_deactivated", "creator_date_password_updated", "creator_date_email_changed", "creator_date_email_verified", "creator_date_hired", "creator_agency_id", "creator_vendor_id", "creator_employee_id", "creator_username", "creator_email", "creator_email_verified", "creator_first_name", "creator_middle_name", "creator_last_name", "creator_nick_name", "creator_alias", "creator_icon", "creator_status_id", "creator_extension", "creator_modifier_id", "creator_import_id", "creator", "creator_name", "creator_full_name", "creator_short_name", "creator_creator", "creator_modifier", "creator_level", "creator_role_ids", "creator_role_names", "creator_role_descriptions", "creator_ability_ids", "creator_ability_names", "creator_ability_descriptions", "creator_group_ids", "creator_group_names", "creator_group_descriptions", "modifier_user_id", "modifier_date_created", "modifier_date_modified", "modifier_date_activated", "modifier_date_deactivated", "modifier_date_password_updated", "modifier_date_email_changed", "modifier_date_email_verified", "modifier_date_hired", "modifier_agency_id", "modifier_vendor_id", "modifier_employee_id", "modifier_creator_id", "modifier_username", "modifier_email", "modifier_email_verified", "modifier_first_name", "modifier_middle_name", "modifier_last_name", "modifier_nick_name", "modifier_alias", "modifier_icon", "modifier_status_id", "modifier_extension", "modifier_import_id", "modifier", "modifier_name", "modifier_full_name", "modifier_short_name", "modifier_creator", "modifier_modifier", "modifier_level", "modifier_role_ids", "modifier_role_names", "modifier_role_descriptions", "modifier_ability_ids", "modifier_ability_names", "modifier_ability_descriptions", "modifier_group_ids", "modifier_group_names", "modifier_group_descriptions", "manual_name", "manual_description", "manual", "status_name", "status_description", "status", "category_date_created", "category_date_modified", "category_creator_id", "category_modifier_id", "category_name", "category_description", "category_tags", "type_name", "type_description", "type", "category_creator_user_id", "category_creator_date_created", "category_creator_date_modified", "category_creator_date_activated", "category_creator_date_deactivated", "category_creator_date_password_updated", "category_creator_date_email_changed", "category_creator_date_email_verified", "category_creator_date_hired", "category_creator_agency_id", "category_creator_vendor_id", "category_creator_employee_id", "category_creator_username", "category_creator_email", "category_creator_email_verified", "category_creator_first_name", "category_creator_middle_name", "category_creator_last_name", "category_creator_nick_name", "category_creator_alias", "category_creator_icon", "category_creator_status_id", "category_creator_extension", "category_creator_modifier_id", "category_creator_import_id", "category_creator", "category_creator_name", "category_creator_full_name", "category_creator_short_name", "category_creator_creator", "category_creator_modifier", "category_creator_level", "category_creator_role_ids", "category_creator_role_names", "category_creator_role_descriptions", "category_creator_ability_ids", "category_creator_ability_names", "category_creator_ability_descriptions", "category_creator_group_ids", "category_creator_group_names", "category_creator_group_descriptions", "category_modifier_user_id", "category_modifier_date_created", "category_modifier_date_modified", "category_modifier_date_activated", "category_modifier_date_deactivated", "category_modifier_date_password_updated", "category_modifier_date_email_changed", "category_modifier_date_email_verified", "category_modifier_date_hired", "category_modifier_agency_id", "category_modifier_vendor_id", "category_modifier_employee_id", "category_modifier_creator_id", "category_modifier_username", "category_modifier_email", "category_modifier_email_verified", "category_modifier_first_name", "category_modifier_middle_name", "category_modifier_last_name", "category_modifier_nick_name", "category_modifier_alias", "category_modifier_icon", "category_modifier_status_id", "category_modifier_extension", "category_modifier_import_id", "category_modifier", "category_modifier_name", "category_modifier_full_name", "category_modifier_short_name", "category_modifier_creator", "category_modifier_modifier", "category_modifier_level", "category_modifier_role_ids", "category_modifier_role_names", "category_modifier_role_descriptions", "category_modifier_ability_ids", "category_modifier_ability_names", "category_modifier_ability_descriptions", "category_modifier_group_ids", "category_modifier_group_names", "category_modifier_group_descriptions", "creator_agent_of_record", "modifier_agent_of_record", "category_modifier_agent_of_record", "creator_brokerengage_agent_id", "modifier_brokerengage_agent_id", "category_modifier_brokerengage_agent_id", "creator_agencybloc_agent_id", "modifier_agencybloc_agent_id", "category_modifier_agencybloc_agent_id", "creator_cms_password", "modifier_cms_password", "category_modifier_cms_password", "creator_cms_username", "modifier_cms_username", "category_modifier_cms_username", "creator_ffm_id", "modifier_ffm_id", "category_modifier_ffm_id", "creator_genesys", "modifier_genesys", "category_modifier_genesys", "creator_genesys_cid", "modifier_genesys_cid", "category_modifier_genesys_cid", "creator_genesys_id", "modifier_genesys_id", "category_modifier_genesys_id", "creator_genesys_phone_id", "modifier_genesys_phone_id", "category_modifier_genesys_phone_id", "creator_healthsherpa_user_id", "modifier_healthsherpa_user_id", "category_modifier_healthsherpa_user_id", "creator_healthsherpa_username", "modifier_healthsherpa_username", "category_modifier_healthsherpa_username", "creator_healthsherpa_password", "modifier_healthsherpa_password", "category_modifier_healthsherpa_password", "creator_npn", "modifier_npn", "category_modifier_npn", "creator_enforce_ca_login", "modifier_enforce_ca_login", "category_modifier_enforce_ca_login", "creator_paylocity_id", "modifier_paylocity_id", "category_modifier_paylocity_id", "creator_personal_address", "modifier_personal_address", "category_modifier_personal_address", "creator_personal_email", "modifier_personal_email", "category_modifier_personal_email", "creator_personal_phone", "modifier_personal_phone", "category_modifier_personal_phone", "creator_portal_status", "modifier_portal_status", "category_modifier_portal_status", "creator_timeclock_id", "modifier_timeclock_id", "category_modifier_timeclock_id", "creator_vicidial", "modifier_vicidial", "category_modifier_vicidial", "creator_vicidial_outbound_cid", "modifier_vicidial_outbound_cid", "category_modifier_vicidial_outbound_cid", "creator_vicidial_phone_extension", "modifier_vicidial_phone_extension", "category_modifier_vicidial_phone_extension", "creator_vicidial_user", "modifier_vicidial_user", "category_modifier_vicidial_user", "creator_vicidial_user_id", "modifier_vicidial_user_id", "category_modifier_vicidial_user_id", "creator_vtiger_id", "modifier_vtiger_id", "category_modifier_vtiger_id", "creator_webflow_id", "modifier_webflow_id", "category_modifier_webflow_id" ] }, "debug": { "time": "0.1177s", "memory": "3.14 MB", "peak": "4.58 MB", "method": "GET", "code": 200 } }
- No labels