Updating records

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsUpdating records
Line 1: Line 1:
### Tutorial
+
=== Tutorial ===
  
 
Update (PUT) multiple records in a SQL or NoSQL database. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.
 
Update (PUT) multiple records in a SQL or NoSQL database. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.
  
### API Endpoint
+
=== API Endpoint ===
  
 
<pre>POST https://{url}/api/v2/{api_name}/_table/{table_name}</pre>
 
<pre>POST https://{url}/api/v2/{api_name}/_table/{table_name}</pre>
  
### API Docs Screenshot
+
=== API Docs Screenshot ===
  
 
[[File:Swagger-update-records.png|1000px]]
 
[[File:Swagger-update-records.png|1000px]]
  
### Example - PUT (update) multiple contact records
+
=== Example - PUT (update) multiple contact records ===
  
 
* Table name: contact
 
* Table name: contact

Revision as of 17:49, 3 February 2016

Tutorial

Update (PUT) multiple records in a SQL or NoSQL database. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

API Endpoint

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

API Docs Screenshot

Swagger-update-records.png

Example - PUT (update) multiple contact records

  • Table name: contact
  • Body parameter in API call:
    {
"resource": [ { "id": 107, "first_name": "Alice", "last_name": "Jones" }, { "id": 108, "first_name": "Bob", "last_name": "Simpson" } ] }
  • Request URL:
    https://foo.com/api/v2/db/_table/contact