Egress Endpoints

{
    "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": {
        "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
    }
}