Last Updated: September 10, 2020
·
139
· wjgilmore

DreamFactory REST endpoints that JOIN table data

To join tables exposed through a DreamFactory-generated database API, use the related parameter:

/api/v2/mysql/_table/employees?related=departments_by_dept_emp

This will return records that look like this:

{
  "emp_no": 10001,
  "birth_date": "1953-09-02",
  "first_name": "Georgi",
  "last_name": "Facello",
  "gender": "M",
  "hire_date": "1986-06-26",
  "departments_by_dept_emp": [
    {
      "dept_no": "d005",
      "dept_name": "Development"
    }
  ]
},