Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

I can connect to magento, but i can’t get Invoices throught filters. VS2010 C#.NET and Magento Core API with WS-I Compliance enabled
Jr. Member
Total Posts:  1
Joined:  2011-03-11

I need export invoices to magento using my ERP.
I am using VS2010 C#.NET, magento 1.6.2, Magento Core API with WS-I Compliance enabled
I can connect to magento, the crew works great, but i can\’t get Invoices throught filters.

The code below does not work. What´s wrong? Any clue, I will really appreciate.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \’from = \’2012-12-01\’)\’ at line 1

using (Mage_Api_Model_Server_Wsi_HandlerPortTypeClient proxy = new Mage_Api_Model_Server_Wsi_HandlerPortTypeClient())
                string sessionId 
filters listFilters = new filters();
complexFilter orderFilterTo = new complexFilter();
associativeEntity orderFilterToValue = new associativeEntity();
orderFilterTo.key \"created_at\";
orderFilterToValue.key \"to\";
orderFilterToValue.value \"2012-01-01\";
orderFilterTo.value orderFilterToValue;

complexFilter orderFilterFrom = new complexFilter();
associativeEntity orderFilterFromValue = new associativeEntity();

orderFilterFrom.key \"created_at\";
orderFilterFromValue.key \"from\";
orderFilterFromValue.value \"2012-12-01\";
orderFilterFrom.value orderFilterFromValue;

complexFilter[] listaOrderFilter =  new complexFilter[2];
listaOrderFilter[0] orderFilterTo;
listaOrderFilter[1] orderFilterFrom;

listFilters.complex_filter listaOrderFilter;
salesOrderInvoiceEntity[] lista proxy.salesOrderInvoiceList(sessionIdlistFilters);
Magento Community Magento Community
Magento Community
Magento Community
Jr. Member
Total Posts:  16
Joined:  2011-12-26

Hmm.... I am puzzled.... I don’t know what to do.....

Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top