Querying records with logical filters

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsQuerying records with logical filters
Line 7: Line 7:
 
GET https://your-url/api/v2/your-api-name/_table/{table_name}?filter=
 
GET https://your-url/api/v2/your-api-name/_table/{table_name}?filter=
  
### Supported SQL Databases
+
### API Docs Screenshot
  
* PostgreSQL
+
[[File:Swagger-filter.png|1000px]]
* MySQL
+
* SQLite
+
* SQLite 2
+
* MS SQL Server
+
* Sybase
+
* Oracle
+
* IBM DB2
+
 
+
### Supported NoSQL Databases
+
 
+
* MongoDB
+
* CouchDB
+
* DynamoDB
+
* Azure Tables
+
  
 
### Example - Fetch contact records whose last name starts with 'Y'
 
### Example - Fetch contact records whose last name starts with 'Y'
Line 55: Line 41:
 
* Request URL: https://your-url/api/v2/db/_table/contact?filter=twitter%20like%20%25jon%25%20or%20skype%20like%20%25jon%25
 
* Request URL: https://your-url/api/v2/db/_table/contact?filter=twitter%20like%20%25jon%25%20or%20skype%20like%20%25jon%25
  
### Screenshot
+
### Supported SQL Databases
  
[[File:Swagger-filter.png|1000px]]
+
* PostgreSQL
 +
* MySQL
 +
* SQLite
 +
* SQLite 2
 +
* MS SQL Server
 +
* Sybase
 +
* Oracle
 +
* IBM DB2
 +
 
 +
### Supported NoSQL Databases
 +
 
 +
* MongoDB
 +
* CouchDB
 +
* DynamoDB
 +
* Azure Tables

Revision as of 23:02, 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. 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