Developer Q&A

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.

1. Is the Condition expression below correct?
2. 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:ImposeConcurrencyIdfalse</int:ImposeConcurrencyId>
int:UpdateLastModifiedtrue</int:UpdateLastModified>
int:CanDeleteMissingEntityfalse</int:CanDeleteMissingEntity>
int:LockOnDataRetrievalDefault</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:EntityTypeWorkOrder</int:EntityType>
<int:propertySet xsi:type="int:AllProperties"/>
int:Criteria
int:ConditionExpression
int:PropertyNameId</int:PropertyName>
int:OperatorGreaterOrEqual</int:Operator>
int:Values5003974</int:Values>
</int:ConditionExpression>
int:ConditionExpression
int:PropertyNameNumber</int:PropertyName>
int:OperatorConditionOperator.GreaterThan</int:Operator>
int:Values0</int:Values>
</int:ConditionExpression>
int:ConditionExpression
int:PropertyNameEmployee.Number</int:PropertyName>
int:OperatorConditionOperator.NotNull</int:Operator>
</int:ConditionExpression>
</int:Criteria>
int:Orders
int:OrderExpression
int:PropertyNameId</int:PropertyName>
int:OrderTypeAscending</int:OrderType>
</int:OrderExpression>
</int:Orders>
int:Count3</int:Count>
</int:queryExpression>
</int:RetrieveMultiple>
</soap:Body>
</soap:Envelope>