Add Bulk Product Inventory
Use this operation to add Inventory to an existing Products object.
Parameters
Body Params | |
---|---|
JSON: | json Products Inventory details needs to be passed as body parameter,it should be in JSON format. |
XML: | string Products Inventory details needs to be passed as body parameter,it should be in XML format. |
Path Params | |
---|---|
yourCompany: | string The Company name need to passed in the base URL.For eg. if you enter xyzcompany name, the url https://{yourCompany}.agiliron.net/agiliron/api-40.php/Bulk-ProductsInventory will change to https://xyzcompany.agiliron.net/agiliron/api-40.php/Bulk-ProductsInventory |
callback_url | string The callback URL need to passed in the base URL , which means after the code execution this file gets called.For eg. https://abc.php, the url https://{yourCompany}.agiliron.net/agiliron/api-40.php/Bulk-ProductsInventory?callback_url=https://abc.php&key=xyzkey In this case after execution of code the curl call will made on https://abc.php. |
sendRecordNo | string The value as true or false need to passed for this parameter in the base URL.For eg. if you want record number with response then send value as true ,For eg. https://xyzcompany.agiliron.net/agiliron/api-40.php/Bulk-ProductsInventory&key=xyzkey&sendRecordNo=true. By default it will be false. |
Header Params | |
---|---|
Accept: | string Response header need to be passed for eg. application/json or application/xml. |
Query Auth | |
---|---|
key: | string API key needs to be passed in this variable.The option to enter API key will appear when you click on Try it button.This will be the first option in AUTHENTICATION block.Default is SET to 0. |
Header Auth | |
---|---|
apiKey: | string Dedicated API key needs to be passed in this variable via header.The option to enter API key will appear when you click on Try it button.This will be the second option in AUTHENTICATION block.Default is SET to 0. |
Sample Code
{
"ProductInventory": {
"StockLocationInventory": [
{
"ProductCode": "ProductCode1",
"StockLocation": "OAK",
"QtyInStock": "51",
"UnitCost": "14",
"QtyOnPO": "10",
"QtyOnSO": "20",
"BinLocation": "Test Bin2"
},
{
"ProductCode": "ProductCode2",
"StockLocation": "SAN",
"QtyInStock": "52",
"UnitCost": "14",
"QtyOnPO": "20",
"QtyOnSO": "30",
"BinLocation": "Test Bin2"
}
]
}
}
<ProductInventory>
<StockLocationInventory>
<ProductCode>ProductCode1</ProductCode>
<StockLocation>OAK</StockLocation>
<QtyInStock>51</QtyInStock>
<UnitCost>14</UnitCost>
<QtyOnPO>10</QtyOnPO>
<QtyOnSO>20</QtyOnSO>
<BinLocation>Test Bin2</BinLocation>
</StockLocationInventory>
<StockLocationInventory>
<ProductCode>ProductCode2</ProductCode>
<StockLocation>SAN</StockLocation>
<QtyInStock>52</QtyInStock>
<UnitCost>14</UnitCost>
<QtyOnPO>20</QtyOnPO>
<QtyOnSO>30</QtyOnSO>
<BinLocation>Test Bin2</BinLocation>
</StockLocationInventory>
</ProductInventory>
Sample Response
{
"MCM": {
"response": {
"objectType": "Products",
"syncTime": "2021-06-11 04:13:24"
},
"parameters": {
"results": {
"message": {
"status": "Success",
"success_message": "Bulk Product Inventory Initiated Successfully.",
"batch_id": "thggii1212kjkl"
}
}
}
}
}
<MCM>
<response>
<objectType>Products</objectType>
<syncTime>2021-06-11 04:13:24</syncTime>
</response>
<parameters>
<results>
<message>
<status>Success</status>
<success_message> Bulk Product Inventory Initiated Successfully. </success_message>
<batch_id>thggii1212kjkl</batch_id>
</message>
</results>
</parameters>
</MCM>
WADL
<?xml version="1.0" encoding="utf-8"?>
<application>
<resources base="https://{yourCompany}.agiliron.net/agiliron/api-40/">
<resource path="Bulk-ProductsInventory">
<method name="POST">
<request>
<param name="key" type="xsd:string" style="query" required="true"/>
<param name="ProductCode" type="xsd:string" style="body" required="true"/>
<param name="StockLocation" type="xsd:string" style="body" required="true"/>
<param name="QtyInStock" type="xsd:string" style="body"/>
<param name="UnitCost" type="xsd:decimal" style="body"/>
<param name="QtyOnPO" type="xsd:int" style="body"/>
<param name="QtyOnSO" type="xsd:int" style="body"/>
<param name="BinLocation" type="xsd:string" style="body"/>
</request>
<response status="200">
<representation mediaType="application/xml" element="yn:ResultSet"/>
</response>
<response status="400">
<representation mediaType="application/xml" element="ya:Error"/>
</response>
</method>
</resource>
</resources>
</application>
Sample Webhook
<?php
$url = "https://{your_custom_url}"; //this custom url will be called after the code is executed
$curlConn = curl_init();
curl_setopt($curlConn, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($curlConn, CURLOPT_POSTFIELDS,$results); //$results contain the result set
curl_setopt($curlConn,CURLOPT_URL,$url);
curl_setopt($curlConn, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($curlConn, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curlConn, CURLOPT_RETURNTRANSFER, 1);
$ret = curl_exec($curlConn);
?>
<result>
<SuccessNumber>1</SuccessNumber>
<FailureNumber>1</FailureNumber>
<Success>
<ProductInventory>
<ProductCode>TNP1234</ProductCode>
<StockLocation>OAK</StockLocation>
<Quantity>20</Quantity>
</ProductInventory>
</Success>
<Failure>
<ProductInventory>
<ProductCode>TNP123</ProductCode>
<StockLocation>FBA</StockLocation>
<Message>Invalid Stock Location</Message>
</ProductInventory>
</Failure>
</result>
{
"result": {
"SuccessNumber": "1",
"FailureNumber": "1",
"Success": {
"ProductInventory": {
"ProductCode": "TNP1234",
"StockLocation": "OAK",
"Quantity": "20"
}
},
"Failure": {
"ProductInventory": {
"ProductCode": "TNP123",
"StockLocation": "FBA",
"Message": "Invalid Stock Location"
}
}
}
}
<result>
<SuccessNumber>1</SuccessNumber>
<FailureNumber>1</FailureNumber>
<Success>
<ProductInventory>
<ProductCode>TNP1234</ProductCode>
<StockLocation>OAK</StockLocation>
<Quantity>20</Quantity>
<Record>1</Record>
</ProductInventory>
</Success>
<Failure>
<ProductInventory>
<ProductCode>TNP123</ProductCode>
<StockLocation>FBA</StockLocation>
<Message>Invalid Stock Location</Message>
<Record>2</Record>
</ProductInventory>
</Failure>
</result>
{
"result": {
"SuccessNumber": "1",
"FailureNumber": "1",
"Success": {
"ProductInventory": {
"ProductCode": "TNP1234",
"StockLocation": "OAK",
"Quantity": "20",
"Record": "1"
}
},
"Failure": {
"ProductInventory": {
"ProductCode": "TNP123",
"StockLocation": "FBA",
"Message": "Invalid Stock Location",
"Record": "2"
}
}
}
}
Updated over 1 year ago