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]()

1. 1. Using the REST API

1. 1. 1. Users

• Creating users
• Logging in
• Logging out
• Open registration
• Basic auth
• Access using API key
• Access using JWT
• Access using JWT and API key
• Refreshing a JWT

1. 1. 1. SQL and NoSQL 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
• Specifying fields
• Sorting records
• Paginating records with limits and offsets
• Posting records
• Updating records
• Deleting records

1. 1. 1. SQL-Specific Data

• Querying multiple tables with joins
• Posting data to multiple tables with joins
• Querying SQL views
• Calling stored procedures
• Calling 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
• Setting up application default role
• [[[DreamFactory/Tutorials/Accessing SQL tables|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]()