HomeGuidesAPI ReferenceChangelogDeveloper Q&A
HomeGuidesAPI ReferenceAnnouncementsLog In
Developer Q&A

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:EntityTypeWorkZone</int:EntityType>
<int:PropertySet xsi:type="int:PropertySet">
int:Properties
int:stringDisplayAs</int:string>
int:stringId</int:string>
</int:Properties>
</int:PropertySet>
int:Count0</int:Count>
int:FirstResultIndex0</int:FirstResultIndex>
int:Distincttrue</int:Distinct>
int:Orders
int:OrderExpression
int:PropertyNameDisplayAs</int:PropertyName>
int:OrderTypeAscending</int:OrderType>
</int:OrderExpression>
</int:Orders>
</int:queryExpression>
</int:RetrieveMultiple>
</soap:Body>
</soap:Envelope>