Chilkat Online Tools

PowerBuilder / PrestaShop Webservice Product Resource / Update product - complete update

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Xml
oleobject loo_SbRequestBody
oleobject loo_Resp

// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.BasicAuth = 1
loo_Http.Login = "{{webservice_key}}"
loo_Http.Password = "password"

// Use this online tool to generate code from sample XML: Generate Code to Create XML

// The following XML is sent in the request body.

// <?xml version="1.0" encoding="UTF-8"?>
// <prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
//     <product>
//         <id>{{product_id}}</id>
//         <id_manufacturer><![CDATA[1]]></id_manufacturer>
//         <id_supplier><![CDATA[1]]></id_supplier>
//         <id_category_default><![CDATA[1]]></id_category_default>
//         <new><![CDATA[1]]></new>
//         <cache_default_attribute><![CDATA[1]]></cache_default_attribute>
//         <id_default_image><![CDATA[1]]></id_default_image>
//         <id_default_combination><![CDATA[1]]></id_default_combination>
//         <id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>
//         <type><![CDATA[1]]></type>
//         <id_shop_default><![CDATA[1]]></id_shop_default>
//         <reference><![CDATA[123456]]></reference>
//         <supplier_reference><![CDATA[ABCDEF]]></supplier_reference>
//         <location><![CDATA[123]]></location>
//         <width><![CDATA[12]]></width>
//         <height><![CDATA[24]]></height>
//         <depth><![CDATA[36]]></depth>
//         <weight><![CDATA[48]]></weight>
//         <quantity_discount><![CDATA[0]]></quantity_discount>
//         <ean13><![CDATA[1231231231231]]></ean13>
//         <isbn/>
//         <upc/>
//         <mpn><![CDATA[123456]]></mpn>
//         <cache_is_pack><![CDATA[0]]></cache_is_pack>
//         <cache_has_attachments><![CDATA[0]]></cache_has_attachments>
//         <is_virtual/>
//         <state><![CDATA[1]]></state>
//         <additional_delivery_times/>
//         <delivery_in_stock>
//             <language id="1"/>
//             <language id="2"/>
//         </delivery_in_stock>
//         <delivery_out_stock>
//             <language id="1"/>
//             <language id="2"/>
//         </delivery_out_stock>
//         <product_type><![CDATA[standard]]></product_type>
//         <on_sale><![CDATA[0]]></on_sale>
//         <online_only><![CDATA[0]]></online_only>
//         <ecotax><![CDATA[0]]></ecotax>
//         <minimal_quantity><![CDATA[0]]></minimal_quantity>
//         <low_stock_threshold><![CDATA[0]]></low_stock_threshold>
//         <low_stock_alert><![CDATA[0]]></low_stock_alert>
//         <price><![CDATA[123.45]]></price>
//         <wholesale_price><![CDATA[200]]></wholesale_price>
//         <unity/>
//         <unit_price><![CDATA[123.45]]></unit_price>
//         <unit_price_ratio/>
//         <additional_shipping_cost/>
//         <customizable/>
//         <text_fields/>
//         <uploadable_files/>
//         <active><![CDATA[1]]></active>
//         <redirect_type/>
//         <id_type_redirected/>
//         <available_for_order><![CDATA[1]]></available_for_order>
//         <available_date/>
//         <show_condition/>
//         <condition/>
//         <show_price/>
//         <indexed/>
//         <visibility/>
//         <advanced_stock_management/>
//         <pack_stock_type/>
//         <meta_description>
//             <language id="1"><![CDATA[Description]]></language>
//             <language id="2"><![CDATA[Description]]></language>
//         </meta_description>
//         <meta_keywords>
//             <language id="1"/>
//             <language id="2"/>
//         </meta_keywords>
//         <meta_title>
//             <language id="1"/>
//             <language id="2"/>
//         </meta_title>
//         <link_rewrite>
//             <language id="1"/>
//             <language id="2"/>
//         </link_rewrite>
//         <name>
//             <language id="1"><![CDATA[Product Name]]></language>
//             <language id="2"><![CDATA[Product Name]]></language>
//         </name>
//         <description>
//             <language id="1"><![CDATA[Description]]></language>
//             <language id="2"><![CDATA[Description]]></language>
//         </description>
//         <description_short>
//             <language id="1"/>
//             <language id="2"/>
//         </description_short>
//         <available_now>
//             <language id="1"/>
//             <language id="2"/>
//         </available_now>
//         <available_later>
//             <language id="1"/>
//             <language id="2"/>
//         </available_later>
//         <associations>
//             <categories>
//                 <category>
//                     <id><![CDATA[1]]></id>
//                 </category>
//             </categories>
//             <images>
//                 <image>
//                     <id><![CDATA[1]]></id>
//                 </image>
//             </images>
//         </associations>
//     </product>
// </prestashop>
// 

loo_Xml = create oleobject
// Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")

loo_Xml.Tag = "prestashop"
loo_Xml.AddAttribute("xmlns:xlink","http://www.w3.org/1999/xlink")
loo_Xml.UpdateChildContent("product|id","{{product_id}}")
loo_Xml.UpdateChildContentInt("product|id_manufacturer",1)
loo_Xml.UpdateChildContentInt("product|id_supplier",1)
loo_Xml.UpdateChildContentInt("product|id_category_default",1)
loo_Xml.UpdateChildContentInt("product|new",1)
loo_Xml.UpdateChildContentInt("product|cache_default_attribute",1)
loo_Xml.UpdateChildContentInt("product|id_default_image",1)
loo_Xml.UpdateChildContentInt("product|id_default_combination",1)
loo_Xml.UpdateChildContentInt("product|id_tax_rules_group",1)
loo_Xml.UpdateChildContentInt("product|type",1)
loo_Xml.UpdateChildContentInt("product|id_shop_default",1)
loo_Xml.UpdateChildContentInt("product|reference",123456)
loo_Xml.UpdateChildContent("product|supplier_reference","ABCDEF")
loo_Xml.UpdateChildContentInt("product|location",123)
loo_Xml.UpdateChildContentInt("product|width",12)
loo_Xml.UpdateChildContentInt("product|height",24)
loo_Xml.UpdateChildContentInt("product|depth",36)
loo_Xml.UpdateChildContentInt("product|weight",48)
loo_Xml.UpdateChildContentInt("product|quantity_discount",0)
loo_Xml.UpdateChildContent("product|ean13","1231231231231")
loo_Xml.UpdateChildContent("product|isbn","")
loo_Xml.UpdateChildContent("product|upc","")
loo_Xml.UpdateChildContentInt("product|mpn",123456)
loo_Xml.UpdateChildContentInt("product|cache_is_pack",0)
loo_Xml.UpdateChildContentInt("product|cache_has_attachments",0)
loo_Xml.UpdateChildContent("product|is_virtual","")
loo_Xml.UpdateChildContentInt("product|state",1)
loo_Xml.UpdateChildContent("product|additional_delivery_times","")
loo_Xml.UpdateAttrAt("product|delivery_in_stock|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|delivery_in_stock|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|delivery_out_stock|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|delivery_out_stock|language[1]",1,"id","2")
loo_Xml.UpdateChildContent("product|product_type","standard")
loo_Xml.UpdateChildContentInt("product|on_sale",0)
loo_Xml.UpdateChildContentInt("product|online_only",0)
loo_Xml.UpdateChildContentInt("product|ecotax",0)
loo_Xml.UpdateChildContentInt("product|minimal_quantity",0)
loo_Xml.UpdateChildContentInt("product|low_stock_threshold",0)
loo_Xml.UpdateChildContentInt("product|low_stock_alert",0)
loo_Xml.UpdateChildContent("product|price","123.45")
loo_Xml.UpdateChildContentInt("product|wholesale_price",200)
loo_Xml.UpdateChildContent("product|unity","")
loo_Xml.UpdateChildContent("product|unit_price","123.45")
loo_Xml.UpdateChildContent("product|unit_price_ratio","")
loo_Xml.UpdateChildContent("product|additional_shipping_cost","")
loo_Xml.UpdateChildContent("product|customizable","")
loo_Xml.UpdateChildContent("product|text_fields","")
loo_Xml.UpdateChildContent("product|uploadable_files","")
loo_Xml.UpdateChildContentInt("product|active",1)
loo_Xml.UpdateChildContent("product|redirect_type","")
loo_Xml.UpdateChildContent("product|id_type_redirected","")
loo_Xml.UpdateChildContentInt("product|available_for_order",1)
loo_Xml.UpdateChildContent("product|available_date","")
loo_Xml.UpdateChildContent("product|show_condition","")
loo_Xml.UpdateChildContent("product|condition","")
loo_Xml.UpdateChildContent("product|show_price","")
loo_Xml.UpdateChildContent("product|indexed","")
loo_Xml.UpdateChildContent("product|visibility","")
loo_Xml.UpdateChildContent("product|advanced_stock_management","")
loo_Xml.UpdateChildContent("product|pack_stock_type","")
loo_Xml.UpdateAttrAt("product|meta_description|language",1,"id","1")
loo_Xml.UpdateChildContent("product|meta_description|language","Description")
loo_Xml.UpdateAttrAt("product|meta_description|language[1]",1,"id","2")
loo_Xml.UpdateChildContent("product|meta_description|language[1]","Description")
loo_Xml.UpdateAttrAt("product|meta_keywords|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|meta_keywords|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|meta_title|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|meta_title|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|link_rewrite|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|link_rewrite|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|name|language",1,"id","1")
loo_Xml.UpdateChildContent("product|name|language","Product Name")
loo_Xml.UpdateAttrAt("product|name|language[1]",1,"id","2")
loo_Xml.UpdateChildContent("product|name|language[1]","Product Name")
loo_Xml.UpdateAttrAt("product|description|language",1,"id","1")
loo_Xml.UpdateChildContent("product|description|language","Description")
loo_Xml.UpdateAttrAt("product|description|language[1]",1,"id","2")
loo_Xml.UpdateChildContent("product|description|language[1]","Description")
loo_Xml.UpdateAttrAt("product|description_short|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|description_short|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|available_now|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|available_now|language[1]",1,"id","2")
loo_Xml.UpdateAttrAt("product|available_later|language",1,"id","1")
loo_Xml.UpdateAttrAt("product|available_later|language[1]",1,"id","2")
loo_Xml.UpdateChildContentInt("product|associations|categories|category|id",1)
loo_Xml.UpdateChildContentInt("product|associations|images|image|id",1)

loo_SbRequestBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbRequestBody.ConnectToNewObject("Chilkat.StringBuilder")

loo_Xml.GetXmlSb(loo_SbRequestBody)

loo_Resp = loo_Http.PTextSb("PUT","https://localhost:8080/api/products/1",loo_SbRequestBody,"utf-8","application/xml",0,0)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Xml
    destroy loo_SbRequestBody
    return
end if

Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp


destroy loo_Http
destroy loo_Xml
destroy loo_SbRequestBody

Curl Command

curl -X PUT
	-u '{{webservice_key}}:password'
	-d '<?xml version="1.0" encoding="UTF-8"?>
<prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
<product>
    <id>{{product_id}}</id>
	<id_manufacturer><![CDATA[1]]></id_manufacturer>
	<id_supplier><![CDATA[1]]></id_supplier>
	<id_category_default><![CDATA[1]]></id_category_default>
	<new><![CDATA[1]]></new>
	<cache_default_attribute><![CDATA[1]]></cache_default_attribute>
	<id_default_image><![CDATA[1]]></id_default_image>
	<id_default_combination><![CDATA[1]]></id_default_combination>
	<id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>
	<type><![CDATA[1]]></type>
	<id_shop_default><![CDATA[1]]></id_shop_default>
	<reference><![CDATA[123456]]></reference>
	<supplier_reference><![CDATA[ABCDEF]]></supplier_reference>
	<location><![CDATA[123]]></location>
	<width><![CDATA[12]]></width>
	<height><![CDATA[24]]></height>
	<depth><![CDATA[36]]></depth>
	<weight><![CDATA[48]]></weight>
	<quantity_discount><![CDATA[0]]></quantity_discount>
	<ean13><![CDATA[1231231231231]]></ean13>
	<isbn><![CDATA[]]></isbn>
	<upc><![CDATA[]]></upc>
	<mpn><![CDATA[123456]]></mpn>
	<cache_is_pack><![CDATA[0]]></cache_is_pack>
	<cache_has_attachments><![CDATA[0]]></cache_has_attachments>
	<is_virtual><![CDATA[]]></is_virtual>
	<state><![CDATA[1]]></state>
	<additional_delivery_times><![CDATA[]]></additional_delivery_times>
	<delivery_in_stock><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></delivery_in_stock>
	<delivery_out_stock><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></delivery_out_stock>
	<product_type><![CDATA[standard]]></product_type>
	<on_sale><![CDATA[0]]></on_sale>
	<online_only><![CDATA[0]]></online_only>
	<ecotax><![CDATA[0]]></ecotax>
	<minimal_quantity><![CDATA[0]]></minimal_quantity>
	<low_stock_threshold><![CDATA[0]]></low_stock_threshold>
	<low_stock_alert><![CDATA[0]]></low_stock_alert>
	<price><![CDATA[123.45]]></price>
	<wholesale_price><![CDATA[200]]></wholesale_price>
	<unity><![CDATA[]]></unity>
	<unit_price><![CDATA[123.45]]></unit_price>
	<unit_price_ratio><![CDATA[]]></unit_price_ratio>
	<additional_shipping_cost><![CDATA[]]></additional_shipping_cost>
	<customizable><![CDATA[]]></customizable>
	<text_fields><![CDATA[]]></text_fields>
	<uploadable_files><![CDATA[]]></uploadable_files>
	<active><![CDATA[1]]></active>
	<redirect_type><![CDATA[]]></redirect_type>
	<id_type_redirected><![CDATA[]]></id_type_redirected>
	<available_for_order><![CDATA[1]]></available_for_order>
	<available_date><![CDATA[]]></available_date>
	<show_condition><![CDATA[]]></show_condition>
	<condition><![CDATA[]]></condition>
	<show_price><![CDATA[]]></show_price>
	<indexed><![CDATA[]]></indexed>
	<visibility><![CDATA[]]></visibility>
	<advanced_stock_management><![CDATA[]]></advanced_stock_management>
	<pack_stock_type><![CDATA[]]></pack_stock_type>
	<meta_description><language id="1"><![CDATA[Description]]></language><language id="2"><![CDATA[Description]]></language></meta_description>
	<meta_keywords><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></meta_keywords>
	<meta_title><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></meta_title>
	<link_rewrite><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></link_rewrite>
	<name><language id="1"><![CDATA[Product Name]]></language><language id="2"><![CDATA[Product Name]]></language></name>
	<description><language id="1"><![CDATA[Description]]></language><language id="2"><![CDATA[Description]]></language></description>
	<description_short><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></description_short>
	<available_now><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></available_now>
	<available_later><language id="1"><![CDATA[]]></language><language id="2"><![CDATA[]]></language></available_later>
<associations>
<categories>
	<category>
	<id><![CDATA[1]]></id>
	</category>
</categories>
<images>
	<image>
	<id><![CDATA[1]]></id>
	</image>
</images>
</associations>
</product>
</prestashop>'
https://localhost:8080/api/products/1

Postman Collection Item JSON

{
  "name": "Update product - complete update",
  "request": {
    "method": "PUT",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<prestashop xmlns:xlink=\"http://www.w3.org/1999/xlink\">\n<product>\n    <id>{{product_id}}</id>\n\t<id_manufacturer><![CDATA[1]]></id_manufacturer>\n\t<id_supplier><![CDATA[1]]></id_supplier>\n\t<id_category_default><![CDATA[1]]></id_category_default>\n\t<new><![CDATA[1]]></new>\n\t<cache_default_attribute><![CDATA[1]]></cache_default_attribute>\n\t<id_default_image><![CDATA[1]]></id_default_image>\n\t<id_default_combination><![CDATA[1]]></id_default_combination>\n\t<id_tax_rules_group><![CDATA[1]]></id_tax_rules_group>\n\t<type><![CDATA[1]]></type>\n\t<id_shop_default><![CDATA[1]]></id_shop_default>\n\t<reference><![CDATA[123456]]></reference>\n\t<supplier_reference><![CDATA[ABCDEF]]></supplier_reference>\n\t<location><![CDATA[123]]></location>\n\t<width><![CDATA[12]]></width>\n\t<height><![CDATA[24]]></height>\n\t<depth><![CDATA[36]]></depth>\n\t<weight><![CDATA[48]]></weight>\n\t<quantity_discount><![CDATA[0]]></quantity_discount>\n\t<ean13><![CDATA[1231231231231]]></ean13>\n\t<isbn><![CDATA[]]></isbn>\n\t<upc><![CDATA[]]></upc>\n\t<mpn><![CDATA[123456]]></mpn>\n\t<cache_is_pack><![CDATA[0]]></cache_is_pack>\n\t<cache_has_attachments><![CDATA[0]]></cache_has_attachments>\n\t<is_virtual><![CDATA[]]></is_virtual>\n\t<state><![CDATA[1]]></state>\n\t<additional_delivery_times><![CDATA[]]></additional_delivery_times>\n\t<delivery_in_stock><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></delivery_in_stock>\n\t<delivery_out_stock><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></delivery_out_stock>\n\t<product_type><![CDATA[standard]]></product_type>\n\t<on_sale><![CDATA[0]]></on_sale>\n\t<online_only><![CDATA[0]]></online_only>\n\t<ecotax><![CDATA[0]]></ecotax>\n\t<minimal_quantity><![CDATA[0]]></minimal_quantity>\n\t<low_stock_threshold><![CDATA[0]]></low_stock_threshold>\n\t<low_stock_alert><![CDATA[0]]></low_stock_alert>\n\t<price><![CDATA[123.45]]></price>\n\t<wholesale_price><![CDATA[200]]></wholesale_price>\n\t<unity><![CDATA[]]></unity>\n\t<unit_price><![CDATA[123.45]]></unit_price>\n\t<unit_price_ratio><![CDATA[]]></unit_price_ratio>\n\t<additional_shipping_cost><![CDATA[]]></additional_shipping_cost>\n\t<customizable><![CDATA[]]></customizable>\n\t<text_fields><![CDATA[]]></text_fields>\n\t<uploadable_files><![CDATA[]]></uploadable_files>\n\t<active><![CDATA[1]]></active>\n\t<redirect_type><![CDATA[]]></redirect_type>\n\t<id_type_redirected><![CDATA[]]></id_type_redirected>\n\t<available_for_order><![CDATA[1]]></available_for_order>\n\t<available_date><![CDATA[]]></available_date>\n\t<show_condition><![CDATA[]]></show_condition>\n\t<condition><![CDATA[]]></condition>\n\t<show_price><![CDATA[]]></show_price>\n\t<indexed><![CDATA[]]></indexed>\n\t<visibility><![CDATA[]]></visibility>\n\t<advanced_stock_management><![CDATA[]]></advanced_stock_management>\n\t<pack_stock_type><![CDATA[]]></pack_stock_type>\n\t<meta_description><language id=\"1\"><![CDATA[Description]]></language><language id=\"2\"><![CDATA[Description]]></language></meta_description>\n\t<meta_keywords><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></meta_keywords>\n\t<meta_title><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></meta_title>\n\t<link_rewrite><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></link_rewrite>\n\t<name><language id=\"1\"><![CDATA[Product Name]]></language><language id=\"2\"><![CDATA[Product Name]]></language></name>\n\t<description><language id=\"1\"><![CDATA[Description]]></language><language id=\"2\"><![CDATA[Description]]></language></description>\n\t<description_short><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></description_short>\n\t<available_now><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></available_now>\n\t<available_later><language id=\"1\"><![CDATA[]]></language><language id=\"2\"><![CDATA[]]></language></available_later>\n<associations>\n<categories>\n\t<category>\n\t<id><![CDATA[1]]></id>\n\t</category>\n</categories>\n<images>\n\t<image>\n\t<id><![CDATA[1]]></id>\n\t</image>\n</images>\n</associations>\n</product>\n</prestashop>"
    },
    "url": {
      "raw": "{{webservice_url}}/api/products/{{product_id}}",
      "host": [
        "{{webservice_url}}"
      ],
      "path": [
        "api",
        "products",
        "{{product_id}}"
      ]
    }
  },
  "response": [
  ]
}