Difference between revisions of "Create Items"
(→Summary) |
(→JSON As Body) |
||
| Line 129: | Line 129: | ||
"validate_only":"false", | "validate_only":"false", | ||
"update_existing":true, | "update_existing":true, | ||
| + | "duplicates":false, | ||
"items":[ | "items":[ | ||
{ | { | ||
| Line 143: | Line 144: | ||
} | } | ||
</source> | </source> | ||
| − | |||
== Example Curl Requests == | == Example Curl Requests == | ||
Latest revision as of 11:42, 12 March 2018
Contents |
[edit] Summary
An item can be created via two different methods - either as multi-part form data with a JSON file attached and the API key as a parameter, or as JSON content on it's own, with the API key supplied within the JSON.
The 'create item' method accepts an array of items to be added to the system. If the 'update_existing' parameter is set, then any existing items will be updated in the system. If set to false or not provided, then any item where the item name is not unique will be rejected.
If 'validate_only' is set, the items will only be validated but not actually inserted into the database. This can be used to check an entire dataset for errors before submitting.
The item name is the primary key so if the item already exists it will be updated rather than duplicated unless you add the 'duplicates' parameter to the call which will allow you to have the same item name in different categories.
[edit] Multi Part Form Data
| Create Item | ||
|---|---|---|
| URL | http://base_url/api_path/version/items | |
| Type | POST | |
| Params: | api_key | required |
| file | required | |
| update_existing | optional (default = false) | |
| validate_only | optional (default = false) | |
| duplicates | optional (default = false) | |
| Response | JSON | |
[edit] JSON As Body
| Create Item - JSON | ||
|---|---|---|
| URL | https://base_url/api_path/version/items | |
| Type | POST | |
| JSON {key, validate_only(optional), update_existing(optional), duplicates(optional), items[]} |
required | |
| Response | JSON | |
[edit] JSON Contents
| Standard Fields | ||
|---|---|---|
| Field | Expected Data | Required |
| external_id | varchar(45) | |
| category_id | {"name":"<categoryName>"} *nested JSON object |
✓ |
| name | varchar(255) * must be unique |
✓ |
| notes | text | |
| product_code | varchar(45) | |
| price | float(10,2) | |
| Standard Fields | ||
|---|---|---|
| Field | Expected Data | Required |
| key | string - company api key | ✓ |
| update_existing | boolean | |
| validate_only | boolean | |
[edit] Example Input
[edit] Multi Part Form Data
{"items":[{ "external_id":"ss303", "category_id":{"name":"Test1"}, "name":"darrenItem", "notes":"notesnotes", "product_code":"productCodeTest", "price":"2.50" }]}
[edit] JSON As Body
{ "key":"darrenwebapi", "validate_only":"false", "update_existing":true, "duplicates":false, "items":[ { "external_id":"ss303", "category_id":{ "name":"test2" }, "name":"darrenItem", "notes":"notesnotesnotes", "product_code":"productCodeTest", "price":"2.50" } ] }
[edit] Example Curl Requests
[edit] Multi Part Form Data
curl -F validate_only=false -F update_existing=true -F api_key=darrenwebapi -F file=@/Users/darrenatherton/Desktop/webAPICurling/create_item.txt https://api.mymobileworkers.com:8181/api/1/items
[edit] JSON As Body
curl -X POST -H "Content-Type: application/json" -d '{"key":"darrenwebapi", "validate_only":"false", "update_existing":true,"items":[{"external_id":"ss303","category_id":{"name":"test2"},"name":"darrenItem","notes":"notesnotesnotes","product_code":"productCodeTest","price":"2.50"}]}' https://api.mymobileworkers.com:8181/api/1/items
[edit] Responses
[edit] Example JSON
{ "successful": [ {"item_name":"testItem"}, {"item_name":"testItem2"} ], "failed": [ { "item_name":"testItem3", "errors": [ { "error_code":"ITE012", "error_msg":"name cannot be null." } ] } ] }