Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
      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.

Note that filter strings are simply SQL queries with ordinary SQL operators, including <, <=, >, >=, =, or, and, like.

      1. API Endpoint

GET https://your-url/api/v2/your-api-name/_table/{table_name}?filter=

      1. API Docs Screenshot

Swagger-filter.png

      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. Supported SQL Databases
  • PostgreSQL
  • MySQL
  • SQLite
  • SQLite 2
  • MS SQL Server
  • Sybase
  • Oracle
  • IBM DB2
      1. Supported NoSQL Databases
  • MongoDB
  • CouchDB
  • DynamoDB
  • Azure Tables