Skip to main content
Solved

SOAP API Upload Body

  • December 31, 2020
  • 1 reply
  • 30 views

warrendev
Enthusiast
Forum|alt.badge.img+23

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.

View original
Did this help you find an answer to your question?

1 reply

david_r
Celebrity
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings