Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 1: Line 1:
 
### Tutorial
 
### 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.
+
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.
  
 
### API Endpoint
 
### API Endpoint

Revision as of 22:49, 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'