Add Bulk Products to PriceBook
Use this operation to add an existing Products object to a Pricebook.
Parameters
| Body Params | |
|---|---|
| JSON: | json | 
| XML: | string | 
| Path Params | |
|---|---|
| yourCompany: | string | 
| callback_url | string | 
| sendRecordNo | string 
 | 
| Header Params | |
|---|---|
| Accept: | string | 
| Query Auth | |
|---|---|
| key: | string | 
| Header Auth | |
|---|---|
| apiKey: | string | 
Sample Code
{
	"ProductPricebooks": {
		"ProductPricebook": [
			{
				"ProductCode": "TNP1",
				"PriceBook": "Retail - OAK1",
				"Price": "55"
			},
			{
				"ProductCode": "TNP2",
				"PriceBook": "Bargains",
				"Price": "44"
			}
		]
	}
}<ProductPricebooks>
 <ProductPricebook>
   <ProductCode>TNP1</ProductCode>
   <PriceBook>Retail - OAK1</PriceBook>
   <Price>55</Price>
 </ProductPricebook>
 <ProductPricebook>
   <ProductCode>TNP2</ProductCode>
   <PriceBook>Bargains</PriceBook>
   <Price>44</Price>
 </ProductPricebook>
<ProductPricebooks>Sample Response
{
  "MCM": {
    "response": {
      "objectType": "Products",
      "syncTime": "2021-06-11 04:13:24"
    },
    "parameters": {
      "results": {
        "message": {
          "status": "Success",
          "success_message": "Bulk Product Pricing 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 Pricing 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-ProductsPriceBook">
       <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="PriceBook" type="xsd:string" style="body" required="true"/>
           <param name="Price" type="xsd:decimal" 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>
		<ProductPriceBook>
			<ProductCode>TNP1234</ProductCode>
			<PriceBook>Pricebook 1</PriceBook>
			<Price>20</Price>
		</ProductPriceBook>
	</Success>
	<Failure>
		<ProductPriceBook>
			<ProductCode>TNP123</ProductCode>
			<PriceBook>Pricebook 2</PriceBook>
			<Message>Invalid PriceBook name</Message>
		</ProductPriceBook>
	</Failure>
</result>{
	"result": {
		"SuccessNumber": "1",
		"FailureNumber": "1",
		"Success": {
			"ProductPriceBook": {
				"ProductCode": "TNP1234",
				"PriceBook": "Pricebook 1",
				"Price": "20"
			}
		},
		"Failure": {
			"ProductPriceBook": {
				"ProductCode": "TNP123",
				"PriceBook": "Pricebook 2",
				"Message": "Invalid PriceBook name"
			}
		}
	}
}<result>
	<SuccessNumber>1</SuccessNumber>
	<FailureNumber>1</FailureNumber>
	<Success>
		<ProductPriceBook>
			<ProductCode>TNP1234</ProductCode>
			<PriceBook>Pricebook 1</PriceBook>
			<Price>20</Price>
      <Record>1</Record>
		</ProductPriceBook>
	</Success>
	<Failure>
		<ProductPriceBook>
			<ProductCode>TNP123</ProductCode>
			<PriceBook>Pricebook 2</PriceBook>
			<Message>Invalid PriceBook name</Message>
      <Record>2</Record>
		</ProductPriceBook>
	</Failure>
</result>{
	"result": {
		"SuccessNumber": "1",
		"FailureNumber": "1",
		"Success": {
			"ProductPriceBook": {
				"ProductCode": "TNP1234",
				"PriceBook": "Pricebook 1",
				"Price": "20",
				"Record": "1"
			}
		},
		"Failure": {
			"ProductPriceBook": {
				"ProductCode": "TNP123",
				"PriceBook": "Pricebook 2",
				"Message": "Invalid PriceBook name",
				"Record": "2"
			}
		}
	}
}Updated 5 months ago
