Developer Q&A

Ask a Question
Back to All

Performance issues with RetrieveMultiple workzones

Hello! I would like to get all WorkZones and, from that, retrieve each WorkZone.Id and DisplayAs. The problem I am having is that there are so many WorkZones, the request takes between 15 and 25 seconds. Is there a specific QueryExpression that will only return those two fields needed? This is what I currently have.

Thank you!

<soap:Envelope xmlns:int="http://corrigo.com/integration/" xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header>
<int:CorrigoNetOptions></int:CorrigoNetOptions>
</soap:Header>
<soap:Body>
<int:RetrieveMultiple>
<int:queryExpression xsi:type="int:QueryExpression">
<int:EntityType>WorkZone</int:EntityType>
<int:PropertySet xsi:type="int:PropertySet">
<int:Properties>
<int:string>DisplayAs</int:string>
<int:string>Id</int:string>
</int:Properties>
</int:PropertySet>
<int:Count>0</int:Count>
<int:FirstResultIndex>0</int:FirstResultIndex>
<int:Distinct>true</int:Distinct>
<int:Orders>
<int:OrderExpression>
<int:PropertyName>DisplayAs</int:PropertyName>
<int:OrderType>Ascending</int:OrderType>
</int:OrderExpression>
</int:Orders>
</int:queryExpression>
</int:RetrieveMultiple>
</soap:Body>
</soap:Envelope>