Tutorials

This section consists of short, example-based tutorials for the most common DreamFactory use cases.

Topics in this section include:

1. 1. Setting up API 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]()
• Using the API Docs

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
• Specifying fields
• Sorting records
• Paginating records with limits and offsets
• Posting records
• [Posting data to multiple tables with joins]()
• [Updating records]()
• [Deleting records]()
• [Querying stored procedures]()
• [Querying SQL views]()
• [Querying SQL functions]()

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

1. 1. 1. V8 Javascript

• [Field validation example]()
• [Push notification workflow rule example]()
• [Calculator example]()

1. 1. 1. Node.js

• [Field validation example]()
• [Push notification workflow rule example]()
• [Calculator example]()

1. 1. 1. PHP

• [Field validation example]()
• [Push notification workflow rule example]()
• [Calculator example]()

1. 1. User Management & Security Settings

1. 1. 1. Role-Based Access Control

• [Setting up user roles]()
• [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. 1. Single Sign On

• Using LDAP
• Using Active Directory
• Using OAuth

1. 1. Configuration Settings

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