Querying records with an ID list

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with an ID list
(Created page with "### 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 DreamFactor...")
Line 9: Line 9:
 
### API Docs Screenshot
 
### API Docs Screenshot
  
[[File:Swagger-filter.png|1000px]]
+
[[File:Swagger-ids.png|1000px]]
  
 
### Example - Fetch contact records with IDs of 1, 2, and 3
 
### Example - Fetch contact records with IDs of 1, 2, and 3

Revision as of 23:26, 17 September 2015

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

      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