Executing SQL Joins in REST APIs Using DreamFactory
As a follow up to our previous blog post about retrieving related data from that REST API, I wanted to dive deeper into the power of the “related records” feature of DreamFactory’s database-backed APIs. One of the powerful features of SQL databases is the ability to relate separate data records and perform queries that retrieve that related data all at once. One problem is that this requires a fairly in-depth knowledge of your database, it’s schema, and SQL syntax.