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>>=</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>