get_vendor_directory_report
Retrieve a directory of vendors filtered by insurance expirations, tags, visibility, and payment type. Generate a customizable vendor report for property management.
Instructions
Retrieves a directory of vendors. IMPORTANT: All ID parameters must be numeric strings (e.g. '123'), NOT names.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workers_comp_expiration_to | No | Optional. Filter vendors whose Workers Comp expires on or before this date (YYYY-MM-DD). | |
| liability_expiration_to | No | Optional. Filter vendors whose Liability Insurance expires on or before this date (YYYY-MM-DD). | |
| epa_expiration_to | No | Optional. Filter vendors whose EPA Certification expires on or before this date (YYYY-MM-DD). | |
| auto_insurance_expiration_to | No | Optional. Filter vendors whose Auto Insurance expires on or before this date (YYYY-MM-DD). | |
| state_license_expiration_to | No | Optional. Filter vendors whose State License expires on or before this date (YYYY-MM-DD). | |
| contract_expiration_to | No | Optional. Filter vendors whose Contract expires on or before this date (YYYY-MM-DD). | |
| tags | No | Optional. Filter by a comma-separated list of tags (e.g., "plumbing,hvac"). | |
| vendor_visibility | No | Filter vendors by status. Defaults to "active" | active |
| payment_type | No | Optional. Filter by payment type (eCheck, Check, or all). Defaults to all if not specified. | |
| created_by | No | Filter by who created the vendor. Defaults to "All". | All |
| vendor_type | No | Filter by vendor type. Defaults to "All". | All |
| columns | No | Array of specific columns to include in the report |