Run in Enrichment Spreadsheet
Use this function as a column step in deepline enrich.
deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=opensosdata_business_lookup:{"entity_name":"{{entity_name}}","state":"AL"}' --json
Map payload values to spreadsheet columns with {{column_name}} placeholders.
Required Fields
| Name | Type | Required | Default | Description |
|---|
payload.entity_name | string | Yes | | Business or restaurant name to look up (e.g. ‘Noble Beast Brewing’). Fuzzy matching is applied by OpenSOSData. |
payload.state | "AL" | "AK" | "AZ" | "AR" | "CA" | "CO" | "CT" | "DE" | "FL" | "GA" | "HI" | "ID" | "IL" | "IN" | "IA" | "KS" | "KY" | "LA" | "ME" | "MD" | "MA" | "MI" | "MN" | "MS" | "MO" | "MT" | "NE" | "NV" | "NH" | "NJ" | "NM" | "NY" | "NC" | "ND" | "OH" | "OK" | "OR" | "PA" | "RI" | "SC" | "SD" | "TN" | "TX" | "UT" | "VT" | "VA" | "WA" | "WV" | "WI" | "WY" | "DC" | "PR" | Yes | | Two-letter US state code (e.g. ‘OH’, ‘FL’). All 52 US jurisdictions are supported. Note: OH, CA, MI, WA do NOT expose officer names in their SOS records. The entity is found but officers[] will be empty for these states. |
Allowed values
| Field | Allowed values |
|---|
payload.state | AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, DC, PR |
Advanced: Direct CLI
Use direct execution for single payload debugging.
deepline tools execute opensosdata_business_lookup --payload '{
"entity_name": "string",
"state": "AL"
}' --json
CLI flags
| Flag | Description |
|---|
--json | Print machine-readable output. |
--wait | Wait for terminal provider status when supported. |
--debug | Enable wait mode with additional status/log output. |
--wait-timeout SECONDS | Max seconds to wait in wait mode. |
--poll-interval SECONDS | Polling interval in seconds during wait mode. |
--timeout SECONDS | Request timeout in seconds. |
--connect-timeout SECONDS | Connection timeout in seconds. |
Cost
- Pricing model:
per_result (per result).
- Estimated Deepline credits:
0.44 per pricing unit.
- Billing mode:
post_deduct.
