Posting data to multiple tables with joins

POST records to multiple SQL tables related by foreign key. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

'''Note''' When using a 'Many to Many' relationship to POST you must use an array for the related data.

Note that this example also applies to updating records.

=== API Endpoint ===

<pre>POST https://{url}/api/v2/{api_name}/_table/{table_name}</pre>

=== API Docs Screenshot ===

[[File:Swagger-post-related-records.png|1000px]]

=== Example - POST contact records (parent table) and contact_info_by_contact_id records (child table) ===

* Table name: contact
* Body parameter in API call: 
<pre>
{
 "resource": [
   {
     "first_name": "Alice",
     "last_name": "Jones",
     "contact_info_by_contact_id": [
        {
          "info_type": "home",
          "phone": "701-555-5555",
          "email": "alice@home.com",
          "address": "3761 N. 14th St",
          "city": "MEDINA",
          "state": "ND",
          "zip": "58467",
          "country": "USA"
        },
        {
          "info_type": "work",
          "phone": "701-555-5556",
          "email": "alice@work.com",
          "address": "2243 W St.",
          "city": "MEDINA",
          "state": "ND",
          "zip": "58467",
          "country": "USA"
        }
    ]
   },
   {
     "first_name": "Bob",
     "last_name": "Simpson",
     "contact_info_by_contact_id": [
        {
          "info_type": "home",
          "phone": "701-555-0162",
          "email": "bob@home.com",
          "address": "3762 N. 14th St",
          "city": "MEDINA",
          "state": "ND",
          "zip": "58467",
          "country": "USA"
        },
        {
          "info_type": "work",
          "phone": "701-555-0110",
          "email": "bob@work.com",
          "address": "2244 W St.",
          "city": "MEDINA",
          "state": "ND",
          "zip": "58467",
          "country": "USA"
        }
    ]
   }
 ]
} </pre>
* Request URL: <pre>https://foo.com/api/v2/db/_table/contact</pre>