Skip to main content
Solved

SOAP API Upload Body

  • December 31, 2020
  • 1 reply
  • 35 views
warrendev
Enthusiast
Forum|alt.badge.img+26

I am new to SOAP API's and need to specify a query to return all records between two dates. I've been googling extensively and can't seem to figure out the correct way to build the request with the AndFilters. If anyone with SOAP and XML knowledge could help me out, I would greatly appreciate it.

 

So the SOAP request with the one filter for returning all records after a date works just fine, but I would like to filter for all records between two dates. Greater than or equal to date AND less than or equal to date.

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ais="http://ext.youraspire.com/AIS" xmlns:arr="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
   <soapenv:Header/>
   <soapenv:Body>
      <ais:GetWorkTickets>
         <!--Optional:-->
         <ais:OrFilters>
            <!--Zero or more repetitions:-->
            <ais:Filter>
               <!--Optional:-->
               <ais:AndFilters/>
               <!--Optional:-->
               <ais:Field>ModifiedDate</ais:Field>
               <!--Optional:-->
               <ais:InValues>
                  <!--Zero or more repetitions:-->
                  <arr:string>0</arr:string>
               </ais:InValues>
               <!--Optional:-->
               <ais:Operation>&gt;=</ais:Operation>
               <!--Optional:-->
               <ais:Value>2020-12-27</ais:Value>
            </ais:Filter>
         </ais:OrFilters>
         <!--Optional:-->
         <ais:loginToken>
            <!--Optional:-->
            <ais:token>@Value(token)</ais:token>
         </ais:loginToken>
      </ais:GetWorkTickets>
   </soapenv:Body>
</soapenv:Envelope>

 

Best answer by david_r

You will probably have to contact the API supplier and ask if this filter combination is possible in their implementation.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • January 4, 2021

You will probably have to contact the API supplier and ask if this filter combination is possible in their implementation.

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.