FindItems (emails) restricted to date

Question

I tried to search emails depending on "received" or "sent" date.

This is my request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <MailboxCulture xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://schemas.microsoft.com/exchange/services/2006/types">de-AT</MailboxCulture>
    <RequestServerVersion xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://schemas.microsoft.com/exchange/services/2006/types" Version="Exchange2013" />
  </soap:Header>
  <soap:Body>
    <ns2:FindItem xmlns="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" Traversal="Shallow">
      <ns2:ItemShape>
        <BaseShape>IdOnly</BaseShape>
      </ns2:ItemShape>
      <ns2:Restriction>
        <And>
          <IsEqualTo>
            <Path xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="PathToUnindexedFieldType" FieldURI="item:ItemClass" />
            <FieldURIOrConstant>
              <Constant Value="IPM.NOTE" />
            </FieldURIOrConstant>
          </IsEqualTo>
          <IsGreaterThanOrEqualTo>
            <Path xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="PathToUnindexedFieldType" FieldURI="item:DateTimeReceived" />
            <FieldURIOrConstant>
              <Constant Value="2013-03-13T09:00:00Z" />
            </FieldURIOrConstant>
          </IsGreaterThanOrEqualTo>
          <IsLessThanOrEqualTo>
            <Path xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="PathToUnindexedFieldType" FieldURI="item:DateTimeReceived" />
            <FieldURIOrConstant>
              <Constant Value="2013-12-13T09:00:00Z" />
            </FieldURIOrConstant>
          </IsLessThanOrEqualTo>
        </And>
      </ns2:Restriction>
      <ns2:ParentFolderIds>
        <DistinguishedFolderId Id="inbox" />
      </ns2:ParentFolderIds>
    </ns2:FindItem>
  </soap:Body>
</soap:Envelope>

But I just get back following error:

WARNING: Interceptor for {http://schemas.microsoft.com/exchange/services/2006/messages}ExchangeService#{http://schemas.microsoft.com/exchange/services/2006/messages}FindItem has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Could not send Message.
..
Caused by: org.apache.cxf.transport.http.HTTPException: HTTP response '503: Service Unavailable' when communicating with https://mail.rbes.local/ews/exchange.asmx

If I omit the restriction I get a valid response.

Anyone can help me?

Other request same error:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <MailboxCulture xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://schemas.microsoft.com/exchange/services/2006/types">de-AT</MailboxCulture>
    <RequestServerVersion xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns="http://schemas.microsoft.com/exchange/services/2006/types" Version="Exchange2013" />
  </soap:Header>
  <soap:Body>
    <ns2:FindItem xmlns="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ns2="http://schemas.microsoft.com/exchange/services/2006/messages" Traversal="Shallow">
        <ns2:ItemShape>
            <BaseShape>IdOnly</BaseShape>
        </ns2:ItemShape>
        <ns2:Restriction>
            <IsLessThanOrEqualTo>
                <Path xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="PathToUnindexedFieldType" FieldURI="item:DateTimeReceived" />
                <FieldURIOrConstant>
                    <Constant Value="2013-12-13T09:00:00Z" />
                </FieldURIOrConstant>
            </IsLessThanOrEqualTo>
        </ns2:Restriction>
        <ns2:ParentFolderIds>
            <DistinguishedFolderId Id="inbox" />
        </ns2:ParentFolderIds>
    </ns2:FindItem>
  </soap:Body>
</soap:Envelope>

What are these nested SearchExpression tags doing? Look weird to me. BTW The book "Inside Microsoft Exchange Server 2007 Web Services" (David Sterling; Ben Spain; Michael Mainer; Mark Taylor; Huw Upshall) is a great reference. — Jan Doggen
You are right! I have corrected the request now, but still the same error — y0dA

Janus Janus · Accepted Answer · 2013-11-26T06:15:27

Sending request with JWebServices for Exchange valid request is generated as:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"  xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types">
<soap:Header>
  <t:RequestServerVersion Version="Exchange2013"/>
</soap:Header>
<soap:Body>
  <FindItem Traversal="Shallow" xmlns="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types">
    <ItemShape>
      <t:BaseShape>IdOnly
      </t:BaseShape>
    </ItemShape>
    <Restriction>
      <t:And>
        <t:IsEqualTo>
          <t:FieldURI FieldURI="item:ItemClass" />
          <t:FieldURIOrConstant>
             <t:Constant Value="IPM.Note"/>
          </t:FieldURIOrConstant>
        </t:IsEqualTo>
        <t:IsGreaterThanOrEqualTo>
          <t:FieldURI FieldURI="item:DateTimeReceived" />
          <t:FieldURIOrConstant>
             <t:Constant Value="2013-03-12T23:00:00Z"/>
          </t:FieldURIOrConstant>
        </t:IsGreaterThanOrEqualTo>
        <t:IsLessThanOrEqualTo>
          <t:FieldURI FieldURI="item:DateTimeReceived" />
          <t:FieldURIOrConstant>
             <t:Constant Value="2013-03-12T23:00:00Z"/>
          </t:FieldURIOrConstant>
        </t:IsLessThanOrEqualTo>
      </t:And>
    </Restriction>
    <ParentFolderIds>
      <t:DistinguishedFolderId Id="inbox">
      </t:DistinguishedFolderId>
    </ParentFolderIds>
  </FindItem>
</soap:Body>
</soap:Envelope>

FindItems (emails) restricted to date

1 Answers