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>
