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-logical-filters)
• [Querying records with an ID list]()
• [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]()
• [Push notification workflow rule]()
• [Calculator]()