Query https://data.cityofnewyork.us/resource/6y5g-5hkj.json with $where on applicant_name or waiting_list_application
Read priority_number and application_order_number to gauge queue position
Read waiting_list_status for current state, e.g. 'Awaiting Waitlist Selection'
Once a license is issued, cross-reference w7w3-xahh by business_name to confirm the applicant converted from waitlisted to licensed
Known gotchas
The General Vendor waiting list has been subject to legislative caps and reopenings over the years - priority_number order does not guarantee a selection timeline
Matching by applicant_name alone can hit multiple rows for common names; prefer the waiting_list_application identifier when available
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?