Bulk insert to inventory
curl --request POST \
--url https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert \
--header 'Content-Type: application/json' \
--header 'x-site-context: <x-site-context>' \
--data '
[
{
"sku": "1597422",
"itemId": 1597422,
"totalQuantity": 25,
"reservedQuantity": 0,
"locationId": 175,
"type": "Stock",
"channelId": 12,
"transitRef": "wo-2002",
"transitOrderDate": "2019-12-14",
"transitStockDate": "2019-12-14"
}
]
'import requests
url = "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert"
payload = [
{
"sku": "1597422",
"itemId": 1597422,
"totalQuantity": 25,
"reservedQuantity": 0,
"locationId": 175,
"type": "Stock",
"channelId": 12,
"transitRef": "wo-2002",
"transitOrderDate": "2019-12-14",
"transitStockDate": "2019-12-14"
}
]
headers = {
"x-site-context": "<x-site-context>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-site-context': '<x-site-context>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
sku: '1597422',
itemId: 1597422,
totalQuantity: 25,
reservedQuantity: 0,
locationId: 175,
type: 'Stock',
channelId: 12,
transitRef: 'wo-2002',
transitOrderDate: '2019-12-14',
transitStockDate: '2019-12-14'
}
])
};
fetch('https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
[
'sku' => '1597422',
'itemId' => 1597422,
'totalQuantity' => 25,
'reservedQuantity' => 0,
'locationId' => 175,
'type' => 'Stock',
'channelId' => 12,
'transitRef' => 'wo-2002',
'transitOrderDate' => '2019-12-14',
'transitStockDate' => '2019-12-14'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-site-context: <x-site-context>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert"
payload := strings.NewReader("[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-site-context", "<x-site-context>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert")
.header("x-site-context", "<x-site-context>")
.header("Content-Type", "application/json")
.body("[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-site-context"] = '<x-site-context>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]"
response = http.request(request)
puts response.read_body{
"messages": [
"Import Inventory job started: Mon Nov 02 2020 22:26:10 GMT+0000 (Coordinated Universal Time)"
],
"keyId": "api-1604355970096",
"type": "api",
"status": "FINISHED",
"totalItems": 1,
"totalItemsUploaded": 1,
"totalRows": 2,
"totalRowsErrors": 2,
"__v": 0,
"_id": "5fee9d59f2f08a1b3cbdea08",
"createdAt": "2020-12-31T02:09:53.914Z",
"updatedAt": "2020-12-31T02:09:53.914Z"
}{
"code": "INVENTORY_INSERT_FAILED",
"message": "Inventory insert failed: Row 1: Cannot find \"Location Id\" 999."
}{
"message": "Forbidden"
}{
"code": "<string>",
"message": "<string>"
}Inventory
Bulk insert to inventory
Bulk insert to inventory
POST
/
api-inventory
/
inventory
/
bulk-insert
Bulk insert to inventory
curl --request POST \
--url https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert \
--header 'Content-Type: application/json' \
--header 'x-site-context: <x-site-context>' \
--data '
[
{
"sku": "1597422",
"itemId": 1597422,
"totalQuantity": 25,
"reservedQuantity": 0,
"locationId": 175,
"type": "Stock",
"channelId": 12,
"transitRef": "wo-2002",
"transitOrderDate": "2019-12-14",
"transitStockDate": "2019-12-14"
}
]
'import requests
url = "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert"
payload = [
{
"sku": "1597422",
"itemId": 1597422,
"totalQuantity": 25,
"reservedQuantity": 0,
"locationId": 175,
"type": "Stock",
"channelId": 12,
"transitRef": "wo-2002",
"transitOrderDate": "2019-12-14",
"transitStockDate": "2019-12-14"
}
]
headers = {
"x-site-context": "<x-site-context>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-site-context': '<x-site-context>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
sku: '1597422',
itemId: 1597422,
totalQuantity: 25,
reservedQuantity: 0,
locationId: 175,
type: 'Stock',
channelId: 12,
transitRef: 'wo-2002',
transitOrderDate: '2019-12-14',
transitStockDate: '2019-12-14'
}
])
};
fetch('https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
[
'sku' => '1597422',
'itemId' => 1597422,
'totalQuantity' => 25,
'reservedQuantity' => 0,
'locationId' => 175,
'type' => 'Stock',
'channelId' => 12,
'transitRef' => 'wo-2002',
'transitOrderDate' => '2019-12-14',
'transitStockDate' => '2019-12-14'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-site-context: <x-site-context>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert"
payload := strings.NewReader("[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-site-context", "<x-site-context>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert")
.header("x-site-context", "<x-site-context>")
.header("Content-Type", "application/json")
.body("[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]")
.asString();require 'uri'
require 'net/http'
url = URI("https://prod01-apigw.{customer_name}.fabric.zone/api-inventory/inventory/bulk-insert")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-site-context"] = '<x-site-context>'
request["Content-Type"] = 'application/json'
request.body = "[\n {\n \"sku\": \"1597422\",\n \"itemId\": 1597422,\n \"totalQuantity\": 25,\n \"reservedQuantity\": 0,\n \"locationId\": 175,\n \"type\": \"Stock\",\n \"channelId\": 12,\n \"transitRef\": \"wo-2002\",\n \"transitOrderDate\": \"2019-12-14\",\n \"transitStockDate\": \"2019-12-14\"\n }\n]"
response = http.request(request)
puts response.read_body{
"messages": [
"Import Inventory job started: Mon Nov 02 2020 22:26:10 GMT+0000 (Coordinated Universal Time)"
],
"keyId": "api-1604355970096",
"type": "api",
"status": "FINISHED",
"totalItems": 1,
"totalItemsUploaded": 1,
"totalRows": 2,
"totalRowsErrors": 2,
"__v": 0,
"_id": "5fee9d59f2f08a1b3cbdea08",
"createdAt": "2020-12-31T02:09:53.914Z",
"updatedAt": "2020-12-31T02:09:53.914Z"
}{
"code": "INVENTORY_INSERT_FAILED",
"message": "Inventory insert failed: Row 1: Cannot find \"Location Id\" 999."
}{
"message": "Forbidden"
}{
"code": "<string>",
"message": "<string>"
}Headers
The x-site-context header is a JSON object that contains information about the source you wish to pull from. The mandatory account is the 24 character identifier found in Copilot. The channel (Sales channel ID), stage (environment name), and date attributes can be used to further narrow the scope of your data source.
Example:
"{\"date\": \"2023-01-01T00:00:00.000Z\", \"channel\": 12, \"account\": \"1234abcd5678efgh9ijklmno\",\"stage\":\"production\"}"
Body
application/json
Minimum array length:
1- Option 1
- Option 2
Response
Inventory bulk insert
Was this page helpful?
