Yelp Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Yelp Tables
| Name | Description |
| AutocompleteBusinesses | A list of business autocomplete suggestions based on the input text. |
| AutocompleteTerms | A list of term autocomplete suggestions based on the input text. |
| BusinessDetails | Returns detailed business content. |
| BusinessMatch | This table lets you match business data from other sources against businesses on Yelp, based on provided business information. For example, if you know a business's exact address and name, and you want to find that business and only that business on Yelp. |
| BusinessSearch | Returns up to 1000 businesses based on the provided search criteria. It has some basic information about the business. |
| Categories | returns all Yelp business categories across all locales by default. |
| EventSearch | Returns events based on the provided search criteria. |
| FeaturedEvent | Returns the featured event for a given location. Featured events are chosen by Yelp's community managers. |
| PhoneSearch | Returns a list of businesses based on the provided phone number. |
| Reviews | Returns up to three review excerpts for a given business ordered by Yelp's default sort order. |
| TransactionSearch | Returns a list of businesses which support food delivery transactions. Currently, this table only supports food delivery in the US. |