Developer Q&A
Retrieve multiple is giving false positive results
Hello,
We have the below request to retrieve if there is any duplicate Workorder exist for the HLOL number provided in the body. We were told by Corrigo the system will send the empty/undefined response if there is no active workorders for the HLOL number(mentioned in the below request), but it is responding with an object and we are canceling the legit wo assuming it is a duplicate. Could you please check the? this is happening intermittently if there are any "create" or "update" actions pushed to Corrigo at same time.
Example WorkOrder:
Sample Request:
Request Body: <int:RetrieveMultiple xmlns:int="http://corrigo.com/integration/">
<int:queryExpression xsi:type="int:QueryExpression">
<int:EntityType>WorkOrder</int:EntityType>
<int:PropertySet xsi:type="int:AllProperties"/>
<int:Criteria>
<int:Filters>
<int:FilterExpression>
<int:Conditions>
<int:ConditionExpression xsi:nil="false">
<int:PropertyName>Number</int:PropertyName>
<int:Operator>Equal</int:Operator>
<int:Values>
<int:anyType xsi:type="xsd:string">HLOL0273601</int:anyType>
</int:Values>
</int:ConditionExpression>
</int:Conditions>
<int:FilterOperator>And</int:FilterOperator>
<int:Conditions>
<int:ConditionExpression xsi:nil="false">
<int:PropertyName>StatusId</int:PropertyName>
<int:Operator>NotEqual</int:Operator>
<int:Values>
<int:anyType xsi:type="int:WorkOrderStatus">Cancelled</int:anyType>
</int:Values>
</int:ConditionExpression>
</int:Conditions>
<int:FilterOperator>And</int:FilterOperator>
<int:Conditions>
<int:ConditionExpression xsi:nil="false">
<int:PropertyName>StatusId</int:PropertyName>
<int:Operator>NotEqual</int:Operator>
<int:Values>
<int:anyType xsi:type="int:WorkOrderStatus">Completed</int:anyType>
</int:Values>
</int:ConditionExpression>
</int:Conditions>
</int:FilterExpression>
</int:Filters>
</int:Criteria>
<int:Orders>
<int:OrderExpression>
<int:PropertyName>Id</int:PropertyName>
<int:OrderType>Descending</int:OrderType>
</int:OrderExpression>
</int:Orders>
<int:Count>0</int:Count>
<int:FirstResultIndex>0</int:FirstResultIndex>
</int:queryExpression>
</int:RetrieveMultiple>
Sample Respsone:
RetrieveMultiple HLOL Number: HLOL0273601 Response Body: {"soap:Envelope":{"xmlns:xsd":"http://www.w3.org/2001/XMLSchema","xmlns:soap":"http://www.w3.org/2003/05/soap-envelope","xmlns:xsi":"http://www.w3.org/2001/XMLSchema-instance","soap:Body":{"RetrieveMultipleResponse":{"xmlns":"http://corrigo.com/integration/","RetrieveMultipleResult":{"CorrigoEntity":{"ShortLocation":"PRUDENTIAL CENTER - 356","DtOnSiteBy":"2021-12-20T18:30:00","Customer":{"DisplayAs":"","IsRemoved":"false","Dba":"","PerformDeletion":"false","ConcurrencyId":"0","Instructions":"","Name":"","Addresses":"","ApprovalScopes":"","TaxExempt":"false","CustomFields":"","Contacts":"","Spaces":"","TenantCode":"","Id":"78","Notes":"","GroupsBridge":""},"Access":"NotApplicable","IsWarranty":"false","Assignments":"","Procedures":"","ScheduledStartUtc":{"xsi:nil":"true"},"WorkZone":{"Entity":"","WorkPlanAutoDependency":"false","UseBizHours":"false","EarliestSlot":"0","BizHours":"","WoNumberDigits":"0","WorkPlanAutoCancel":"false","ContactAddresses":"","UseOnCall":"false","DefaultAccess":"Unknown","UiShowProvidersFirst":"false","AutoAssignEnabled":"false","AccessOptionsMask":"0","LatestSlot":"0","TurnTemplateId":"0","IsPrecalculatedSchedule":"false","IsOffline":"false","TurnKickOffAuto":"false","TimeZone":"0","CustomFields":"","RoundApptTimeTo":"0","TurnKickOffOnDays":"0","Id":"54","SlotsCount":"0","DisplayAs":"","IsRemoved":"false","CpThemeId":"0","PerformDeletion":"false","ConcurrencyId":"0","Responsibilities":"","DefaultBillToLogic":"0","Number":"","Teams":"","CurrencyTypeId":"Unknown","BackupRoutingId":"Unassigned","Portfolios":"","WorkPlanChildResolution":"false","NoIncompleteProcedure":"false","UseEscalation":"false","TurnKickOffLagDays":"0","WoNumberPrefix":"","SpecDispatchRules":"","EscalationRules":"","AllowTimePreference":"false","UseHolidays":"false","NoIncompleteItem":"false","OnCallRules":"","LanguageId":"0","SchedulingWindow":"0","AdvanceNotice":"0","SlaValues":""},"TypeCategory":"Request","Items":"","WorkOrderCost":{"VendorInvoiceDate":{"xsi:nil":"true"},"PaymentNotes":"","PerformDeletion":"false","ConcurrencyId":"0","CustomerNte":{"Value":"0","CurrencyTypeId":"Unknown"},"PaymentAmount":{"Value":"0","CurrencyTypeId":"Unknown"},"CostsTotal":{"Value":"0","CurrencyTypeId":"Unknown"},"Number":"","ApStatusId":"1","JobCode":"","CostState":"Pending","ExpensesTotal":{"Value":"0","CurrencyTypeId":"Unknown"},"Items":"","CurrencyTypeId":"Unknown","BillingRule":"Unknown","AuthorizationCode":"","CostStatusId":"1","ExternalId":"","CheckCutDate":{"xsi:nil":"true"},"CheckNumber":"","GlAccount":"","VendorInvoiceTotal":{"Value":"0","CurrencyTypeId":"Unknown"},"IsPreBilled":"false","ApStateId":"None","CheckClearDate":{"xsi:nil":"true"},"TaxStatus":"Unknown","Id":"238232","ServiceFeesTotal":{"Value":"0","CurrencyTypeId":"Unknown"},"VendorInvoiceReceivedDate":{"xsi:nil":"true"}},"TaskRefinement":"Graphics:Wrong Item Received:ttest HLOL Detail: Assignment group: Brand Updates & Overhauls","SubType":{"IsRemoved":"false","TypeId":"Unknown","IsDefBasic":"false","PerformDeletion":"false","ConcurrencyId":"0","Id":"259","IsDefSR":"false"},"DtCreated":"2021-12-06T18:04:00","Priority":{"DueInMinutes":"0","AcknowledgeInMinutes":"0","RespondInMinutes":"0","PerformDeletion":"false","IsEmergency":"false","Id":"6"},"PoNumber":"","Duration":"0","DtAcknowledgeBy":"2021-12-10T18:30:00","Specialty":{"DisplayAs":"","IsRemoved":"false","PerformDeletion":"false","ConcurrencyId":"0","Instructions":"","Id":"10029","WONServiceId":"0","Currencies":""},"CreatedDateUtc":"2021-12-06T23:04:00","AcknowledgeByUtc":"2021-12-10T23:30:00","TimeZone":"35","CustomFields":"","Employee":{"DisplayAs":"","IsRemoved":"false","Specialties":"","PerformDeletion":"false","AccessToAllWorkZones":"false","ConcurrencyId":"0","TaxWarnOnly":"false","WonLocationId":"0","JobTitle":"","ForcePasswordReset":"false","StockLocations":"","IsSupplier":"false","AlertSubscriptions":"","Number":"","ContactAddresses":"","Teams":"","BillAtZero":"false","LimitAssignmentByPortfolioId":"0","FreeTextAllowed":"false","Portfolios":"","Password":"","WonServiceRadius":"0","CustomerGroups":"","FirstName":"","ExternalId":"","PriceLists":"","Instructions":"","ProviderStatusId":"NA","RadiusUnit":"Unknown","PayRates":"","FederalId":"","Services":"","TaxExempt":"false","CustomFields":"","IsElectronicPayment":"false","Username":"","ProviderInvitedOn":{"xsi:nil":"true"},"WonMemberId":"0","Id":"227","LastName":"","LabelId":"0","ActorTypeId":"Unknown","DtPwdChange":"0001-01-01T00:00:00","LanguageId":"0","WorkZones":""},"DtUtcOnSiteBy":"2021-12-20T23:30:00","Documents":"","StatusId":"New","Id":"238232","LastActionDateUtc":"2021-12-06T23:04:00","MainAsset":{"ParentId":"0","RootId":"0","IsTemplate":"false","Orphan":"false","TypeId":"Unknown","PerformDeletion":"false","Attributes":"","IsLocked":"false","IsOffline":"false","Name":"","Documents":"","Id":"61770","ModelId":"0"},"PerformDeletion":"false","LastAction":{"WorkOrderId":"0","PerformDeletion":"false","BillStatus":"NotBilled","Id":"238232"},"ConcurrencyId":"2","Verifications":"","LastActionDate":"2021-12-06T18:04:00","WonId":"14157896","DtDue":"2021-12-20T18:30:00","Number":"HLOL0273601","DtScheduledStart":{"xsi:nil":"true"},"CurrencyTypeId":"USD","Notes":"","EquipmentWorkedOn":"","VendorNte":{"Value":"0.0000","CurrencyTypeId":"USD"},"xsi:type":"WorkOrder","ActionLogRecords":"","CheckInOuts":"","ContactName":"","DueDateUtc":"2021-12-20T23:30:00"}}}}}}