Specifying fields

Select which fields to return in a SQL or NoSQL GET request. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

API Endpoint

GET https://{url}/api/v2/{api_name}/_table/{table_name}?fields={field_list}

API Docs Screenshot

Example - GET the first names and last names from contact table

• Table name: contact
• Fields parameter in API call:

  first_name, last_name

• Request URL:

  https://foo.com/api/v2/db/_table/contact?fields=first_name%2C%20last_name