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

Developer Q&A

Ask a Question
Back to All

ApState Names for RetrieveMultiple

almost 6 years ago by Maro Reyes

Hi, Trying to use ApState Names for Retrieve Multiple but getting error response.

Error Response

soap:ClientSystem.Web.Services.Protocols.SoapException: Object must implement IConvertible.

at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlock(Action action) in C:\TFS-Agent_work\1\s\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 284
at Corrigo.Web.Services.CorrigoService.Core.ServiceExecutionContext.SoapExceptionBlockWithSession[T](Func`1 func) in C:\TFS-Agent_work\1\s\Source\BusinessObjects\Corrigo.BO.CorrigoService\Core\ServiceExecutionContext.cs:line 317
at Integration.CorrigoService.RetrieveMultiple(QueryBase queryExpression) in C:\TFS-Agent_work\1\s\Source\Web\Services\Integration\CorrigoService.asmx.cs:line 92http://am-ce94b.corrigo.com:55443/wsdk/CorrigoService.asmx?wsdl</soap:Fault></soap:Body></soap:Envelope>

Requested XML
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>


WorkOrder


*
WorkOrderCost.ApStatusId
WorkOrderCost.ApStateId
WorkOrderCost.AuthorizationCode
WorkOrderCost.CheckCutDate
WorkOrderCost.CheckNumber
WorkOrderCost.GlAccount
WorkOrderCost.Number
WorkOrderCost.PaymentAmount
WorkOrderCost.VendorInvoiceTotal
WorkOrderCost.VendorInvoiceDate
WorkOrderCost.Items.Amount
WorkOrderCost.Items.CostCategoryId
WorkOrderCost.Items.Amount.Value
WorkOrderCost.Items.Comment
Address.Country
Employee.Number
Employee.DisplayAs
Employee.IsElectronicPayment
ActionLogRecords.ActionDate
WorkZone.Number
WorkZone.Portfolios.PortfolioId







WorkOrderCost.ApStateId
Equal

Exported



And


Address.Country
GreaterThan





And


Employee.Number
GreaterThan





And


Number
GreaterThan

0



And


WorkOrderCost.GlAccount
GreaterThan





And


Employee.IsElectronicPayment
Equal

false



And


WorkOrderCost.Number
GreaterThan

0



And


WorkOrderCost.VendorInvoiceDate
NotNull


And


WorkZone.Number
NotNull


And



Address.Country
NotEqual
US


Or



Address.Country
Equal
US


And


WorkOrderCost.Items.Comment
NotIn
GST
HST









Id
Ascending


true


</soap:Body>
</soap:Envelope>