Tutorials
From DreamFactory
(→SQL-Specific Data) |
|||
| Line 51: | Line 51: | ||
* [[DreamFactory/Tutorials/Querying multiple tables with joins|Querying multiple tables with joins]] | * [[DreamFactory/Tutorials/Querying multiple tables with joins|Querying multiple tables with joins]] | ||
* [[DreamFactory/Tutorials/Posting data to multiple tables with joins|Posting data to multiple tables with joins]] | * [[DreamFactory/Tutorials/Posting data to multiple tables with joins|Posting data to multiple tables with joins]] | ||
| + | * [[DreamFactory/Tutorials/Using virtual foreign keys|Combining data from unrelated tables and databases with virtual foreign keys]] | ||
* [[DreamFactory/Tutorials/Querying SQL views|Querying SQL views]] | * [[DreamFactory/Tutorials/Querying SQL views|Querying SQL views]] | ||
* [[DreamFactory/Tutorials/Querying stored procedures|Calling stored procedures]] | * [[DreamFactory/Tutorials/Querying stored procedures|Calling stored procedures]] | ||
Revision as of 21:49, 17 March 2016
This section consists of short, example-based tutorials for the most common DreamFactory use cases.
Topics in this section include:
Contents
Setting up API Services
- Database and server side scripting support by host type
- Connecting to SQL
- Connecting to NoSQL
- Connecting to File Storage
- Connecting to Email Services
- Connecting to Push Notification Services
- Connecting to Remote Web Services (REST)
- Connecting to SOAP Services
Using the REST API
Upgrading your app
Users
- Creating users
- Logging in
- Logging out
- Open registration
- Confirming new users
- Setting up guest access
- Basic auth
- Access using API key
- Access using JWT
- Access using JWT and API key
- Refreshing a JWT
- Forever sessions
- Using forever sessions
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
SQL-Specific Data
- Querying multiple tables with joins
- Posting data to multiple tables with joins
- Combining data from unrelated tables and databases with virtual foreign keys
- Querying SQL views
- Calling stored procedures
- Calling SQL functions
Files
Push Notifications
Remote Web Services (REST)
SOAP Services
Scripting
V8 Javascript
Node.js
- Field validation
- Push notification workflow rule
- Custom scripting service 'math'
- Call API from script
PHP
Python
User Management & Security Settings
Role-Based Access Control
- Setting up user roles
- Setting up application default role
- Accessing SQL tables
- Accessing NoSQL collections
- Record-level access control with server-side filters
- Accessing documents
- Accessing email services
- Accessing push notifications
- Accessing remote web services
- Enabling script access
- Using role lookup keys
Single Sign On
Active Directory
- Importing Groups as Roles
- Mapping Roles to AD Groups
- Retrieving AD Groups
- Retrieving AD Users
- Retrieving AD Computers
