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 magento.stackexchange.com, 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 community@magento.com.

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
 
benrainir
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.

Error:
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 
proxy.login(\"ws\"\"123456789\");
                
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
 
way2fabulous
Jr. Member
 
Avatar
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