Querying SQL views

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying SQL views
      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. API Endpoint
GET https://{url}/api/v2/{api_name}/_table/{view_name}
      1. API Docs Screenshot


      1. 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 SQL database):
  • Request URL: