Querying SQL views

1. 1. 1. Tutorial

GET records in a SQL view. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

Note that querying a view is the same as querying a table with DreamFactory.

1. 1. 1. API Endpoint

GET https://{url}/api/v2/{api_name}/_table/{view_name}

### API Docs Screenshot

[[File:Swagger-view.png|1000px]]

### Example - GET records in a view called special_contacts

* View name: special_contacts
* Table_name in API call (note that this would be a view in your database): <pre>special_contacts

• Request URL:

  https://foo.com/api/v2/db/_table/special_contacts