cancel
Showing results for 
Search instead for 
Did you mean: 

catalogProductList SOAP API category_ids

catalogProductList SOAP API category_ids

Please help me out in this issue. Folloiwng reference link from magento.

http://devdocs.magento.com/guides/m1x/api/soap/catalog/catalogProduct/catalog_product.list.html

I am calling this catalogProductList. It is working fine but when I apply category_ids filter then I'm getting following error.

<h1>There has been an error processing your request</h1>
<pre>SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`category_ids` = '52')


here is SOAP Envelop..

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:Magento" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<soapenv:Header/>
<soapenv:Body>
<urn:catalogProductList soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<sessionId xsi:type="xsd:string">d9ded1503965a8eb4ff4b2b0dfee3577</sessionId>
<filters xsi:type="urn:filters">
<!--You may enter the following 2 items in any order-->
<!--Optional:-->
<filter xsi:type="urn:associativeArray" soapenc:arrayType="urn:associativeEntity[]">
<item><!-- this is missing on your side -->
<key xsi:type="xsd:string">category_ids</key>
<value xsi:type="xsd:string">52</value>
</item>
</filter>
</filters>
<storeView xsi:type="xsd:string"></storeView>
</urn:catalogProductList>
</soapenv:Body>
</soapenv:Envelope>

1 REPLY

Re: catalogProductList SOAP API category_ids

@danishjee

 

Are you passing category id as array or string?

 

you need to pass category Id as array as per doc.