Querying records with an ID list

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with an ID list
Line 1: Line 1:
 
### Tutorial
 
### Tutorial
  
Query a set of records in a SQL or NoSQL database with a list of IDs. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.
+
Query a SQL or NoSQL database with an ID list.. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.
  
 
### API Endpoint
 
### API Endpoint

Revision as of 07:09, 18 September 2015

      1. Tutorial

Query a SQL or NoSQL database with an ID list.. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

      1. API Endpoint
GET https://your-url/api/v2/your-api-name/_table/{table_name}?ids=your-id-list
      1. API Docs Screenshot

Swagger-ids.png

      1. Example - Fetch contact records with IDs of 1, 2, and 3
  • Table name: contact
  • IDs paramater in API call:
    1, 2, 3
  • Request URL:
    https://your-url/api/v2/db/_table/contact?ids=1%2C%202%2C%203