Tutorials

This section provides short tutorials by example. These tutorials cover the most common DreamFactory use cases.

Topics in this section include:

1. 1. Setting up Services

• [Connecting to SQL]()
• [Connecting to NoSQL]()
• [Connecting to file storage]()
• [Connecting to email services]()
• [Connecting to push notification services]()
• [Connecting to remote web services]()

1. 1. Using the REST API

1. 1. 1. Users

• [Creating users]()
• [Logging in]()
• [Logging out]()

1. 1. 1. Data

• Querying records with logical filters
• Querying records with an ID list
• [Querying for a single record by ID]()
• [Querying records in a date range]()
• [Querying multiple tables with joins]()
• [Querying stored procedures]()
• [Querying SQL views]()
• [Querying SQL functions]()
• [Specifying fields]()
• [Limiting records]()
• [Sorting records]()
• [Offsetting records]()
• [Paginating records]()
• [Specifying rollback policy]()
• [Posting records]()
• [Posting data to multiple tables with joins]()
• [Updating records]()
• [Deleting records]()

1. 1. 1. Files

• [Reading binary files]()
• [Writing binary files]()

1. 1. 1. Email

• [Sending email]()

1. 1. 1. Push notifications

• [Sending push notifications]()

1. 1. 1. Remote web services

• [Edmunds API]()
• [Rotten Tomatoes API]()

1. 1. Scripting

• [Field validation with V8 Javascript]()
• [Field validation with Node.js]()
• [Field validation with PHP]()
• [Push notification workflow rule with V8 Javascript]()
• [Push notification workflow rule with Node.js]()
• [Push notification workflow rule with PHP]()
• [Calculator with V8 Javascript]()
• [Calculator with Node.js]()
• [Calculator with PHP]()

1. 1. User Management & Security Settings

• [Setting up user roles]()
• [Access control with LDAP]()
• [Access control with Active Directory]()
• [Access control with OAuth]()
• [Accessing system resources]()
• [Accessing SQL tables]()
• [Accessing NoSQL collections]()
• [Accessing folders]()
• [Accessing email services]()
• [Accessing push notifications]()
• [Accessing remote web services]()
• [Accessing scripts]()
• [Using role lookup keys]()
• [Record-level access control with server-side filters]()

1. 1. Configuration Settings

• [Clearing the Swagger cache]()
• [Enabling CORS Access]()
• [Setting up email templates]()
• [Setting up lookup keys]()