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 SQL or NoSQL database by appending a comma-delimited list of record IDs into a REST API call. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.
+
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.
  
 
### API Endpoint
 
### API Endpoint

Revision as of 07:06, 18 September 2015

      1. 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.

      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