Prev: All text in a field is erased when you add certain Latvian charact
Next: Cannot Post Purchase Invoice from PO
From: Tribaal on 14 Sep 2010 08:17
Hi all,

I am curently interfacing a custom solution (in Python) with Microsoft
Navision through a SOAP webservice.

I am unable to filter using "complex" criteria - everything works as
expected if I submit the Criteria as a String with only "2010-06-15",
but the exact same call fails with a
Microsoft.Dynamics.Nav.Types.Exceptions.NavFilterException if I supply
the Criteria as being "=2010-06-15", or anything as complicated, such
as ">2010-06-14" or "2010-06-14|2010-06-15" or "2010-06-14 .."

Here is the generated XML enveloppe:

<SOAP-ENV:Envelope xmlns:ns0="http://schemas.xmlsoap.org/soap/
envelope/" xmlns:ns1="urn:microsoft-dynamics-schemas/page/navitem"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-
ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/
><ns0:Body><ns1:ReadMultiple><ns1:filter><ns1:Field>Last_Date_Modified</
ns1:Field><ns1:Criteria>2010-06-15 ..</ns1:Criteria></
ns1:filter><ns1:setSize>10</ns1:setSize></ns1:ReadMultiple></
ns0:Body></SOAP-ENV:Envelope>

Does anybody know how to filter navision results by date via
navision's SOAP webservice?
Thanks a lot for your help

- Trib'
 | 
Pages: 1
Prev: All text in a field is erased when you add certain Latvian charact
Next: Cannot Post Purchase Invoice from PO