Developer Q&A
RetrieveMultiple SOAP
The RetrieveMultiple SOAP below returned successful response 200. But the data returned do not satisfy the conditions stated in Condition expression. WorkOrder Ids returned were 2025164, 2030236 and 2034304.
- Is the Condition expression below correct?
- Could you please provide a sample SOAP that will provide WorkOrder.Id , WorkOrder.WorkOrderCost.Number and WorkOrder.Employee.Number within a single RetrieveMultiple?
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:int="http://corrigo.com/integration/">
<soap:Header>
<int:CorrigoNetOptions>
<int:ImposeConcurrencyId>false</int:ImposeConcurrencyId>
<int:UpdateLastModified>true</int:UpdateLastModified>
<int:CanDeleteMissingEntity>false</int:CanDeleteMissingEntity>
<int:LockOnDataRetrieval>Default</int:LockOnDataRetrieval>
</int:CorrigoNetOptions>
</soap:Header>
<soap:Body>
<int:RetrieveMultiple>
<int:queryExpression xsi:type="int:QueryExpression" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<int:EntityType>WorkOrder</int:EntityType>
<int:propertySet xsi:type="int:AllProperties"/>
<int:Criteria>
<int:ConditionExpression>
<int:PropertyName>Id</int:PropertyName>
<int:Operator>GreaterOrEqual</int:Operator>
<int:Values>5003974</int:Values>
</int:ConditionExpression>
<int:ConditionExpression>
<int:PropertyName>Number</int:PropertyName>
<int:Operator>ConditionOperator.GreaterThan</int:Operator>
<int:Values>0</int:Values>
</int:ConditionExpression>
<int:ConditionExpression>
<int:PropertyName>Employee.Number</int:PropertyName>
<int:Operator>ConditionOperator.NotNull</int:Operator>
</int:ConditionExpression>
</int:Criteria>
<int:Orders>
<int:OrderExpression>
<int:PropertyName>Id</int:PropertyName>
<int:OrderType>Ascending</int:OrderType>
</int:OrderExpression>
</int:Orders>
<int:Count>3</int:Count>
</int:queryExpression>
</int:RetrieveMultiple>
</soap:Body>
</soap:Envelope>