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_empThis 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"
}
]
},Written by Jason Gilmore
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Api
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#