Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 56: Line 56:
  
 
### Screenshot
 
### Screenshot
 +
 +
[[File:Swagger-filter.png|thumbnail]]

Revision as of 22:58, 16 September 2015

      1. Tutorial

Query a SQL or NoSQL database by appending filter strings 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}?filter=

      1. Supported SQL Databases
  • PostgreSQL
  • MySQL
  • SQLite
  • SQLite 2
  • MS SQL Server
  • Sybase
  • Oracle
  • IBM DB2
      1. Supported NoSQL Databases
  • MongoDB
  • CouchDB
  • DynamoDB
  • Azure Tables
      1. Example - Fetch contact records whose last name starts with 'Y'
      1. Example - Query contact records whose last name is 'Yang'
      1. Example - Query contact records whose first name is 'Jon' and last name is 'Yang'
      1. Example - Query contact records whose first name starts with 'J' and last name starts with 'Y'
      1. Example - Query contact records whose Twitter handle contains 'jon' or whose Skype handle contains 'jon'
      1. Screenshot
Swagger-filter.png