Bij replicatie van ExactOnlineREST.SalesOrder.SalesOrdersBulk treedt volgende melding op in Invantive Data Hub 22.1.122-BETA+3759:
2023-01-11 00:44:09.988 Error itgencun016: Error itgeneor328: Multiple errors in Invantive Data Hub.
One or more errors occurred.
A required filter is missing.
The remote server returned an error: (400) Bad Request.
Please contact Invantive Support: This endpoint has mandatory filtering applied. A GET request for this endpoint must have a $filter parameter with one of the following fields in the url:ApprovalStatus,Approver,Created,DeliverTo,DeliverToContactPerson,DeliveryAddress,DeliveryDate,DeliveryStatus,Description,Document,InvoiceStatus,InvoiceTo,InvoiceToContactPerson,Modified,OrderedBy,OrderedByContactPerson,OrderDate,OrderID,OrderNumber,Salesperson,SelectionCode,ShippingMethod,Status,TaxSchedule,PaymentReference,WarehouseID,YourRef.
Please contact Invantive Support: This endpoint has mandatory filtering applied. A GET request for this endpoint must have a $filter parameter with one of the following fields in the url:Created,DeliverTo,DeliverToAddress,DeliverToContactPerson,Description,Document,InvoiceDate,InvoiceID,InvoiceNumber,InvoiceTo,InvoiceToContactPerson,Journal,Modified,OrderedBy,OrderedByContactPerson,OrderNumber,PaymentReference,Salesperson,SelectionCode,Status,TaxSchedule,Type,YourRef,Warehouse.
Please contact Invantive Support: This endpoint has mandatory filtering applied. A GET request for this endpoint must have a $filter parameter with one of the following fields in the url:Barcode,Class_01,Class_02,Class_03,Class_04,Class_05,Class_06,Class_07,Class_08,Class_09,Class_10,Code,CostPriceNew,Created,Description,EndDate,ExtraDescription,FreeBoolField_01,FreeBoolField_02,FreeBoolField_03,FreeBoolField_04,FreeBoolField_05,FreeDateField_01,FreeDateField_02,FreeDateField_03,FreeDateField_04,FreeDateField_05,FreeNumberField_01,FreeNumberField_02,FreeNumberField_03,FreeNumberField_04,FreeNumberField_05,FreeNumberField_06,FreeNumberField_07,FreeNumberField_08,FreeTextField_01,FreeTextField_02,FreeTextField_03,FreeTextField_04,FreeTextField_05,FreeTextField_06,FreeTextField_07,FreeTextField_08,FreeTextField_09,FreeTextField_10,GLCosts,GLRevenue,GLStock,ID,IsBatchItem,IsFractionAllowedItem,IsMakeItem,IsPurchaseItem,IsSalesItem,IsSerialItem,IsStockItem,IsSubcontractedItem,IsTime,IsWebshopItem,ItemGroup,ItemGroupCode,Modified,NetWeightUnit,SalesVatCode,SearchCode,StartDate,Unit.
https://start.exactonline.nl/api/v1/2504981/bulk/SalesOrder/SalesOrders?$select=SelectionCode,SelectionCodeCode,SelectionCodeDescription,AmountDC,AmountDiscount,AmountDiscountExclVat,AmountFC,AmountFCExclVat,ApprovalStatus,ApprovalStatusDescription,Approved,Approver,ApproverFullName,Created,Creator,CreatorFullName,Currency,DeliverTo,DeliverToContactPerson,DeliverToContactPersonFullName,DeliverToName,DeliveryAddress,DeliveryDate,DeliveryStatus,DeliveryStatusDescription,Description,Discount,Division,Document,DocumentNumber,DocumentSubject,InvoiceStatus,InvoiceStatusDescription,InvoiceTo,InvoiceToContactPerson,InvoiceToContactPersonFullName,InvoiceToName,Modified,Modifier,ModifierFullName,OrderDate,OrderID,OrderNumber,OrderedBy,OrderedByContactPerson,OrderedByContactPersonFullName,OrderedByName,PaymentCondition,PaymentConditionDescription,PaymentReference,Remarks,Salesperson,SalespersonFullName,ShippingMethod,ShippingMethodDescription,Status,StatusDescription,TaxSchedule,TaxScheduleCode,TaxScheduleDescription,WarehouseCode,WarehouseDescription,WarehouseID,YourRef,SalesChannel,SalesChannelCode,SalesChannelDescription,IncotermAddress,IncotermCode,IncotermVersion
Call stack:
2023-01-11 00:44:12.050 Error itgeneor328: System.Net.WebException
ValidationException
System.Net.WebException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpBasedProvider.DoRequest(GlobalState owner, ExecutionOptions executionOptions, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int32 timeoutInitialMs, Int32 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
System.Net.WebException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpBasedProvider.DoRequest(GlobalState owner, ExecutionOptions executionOptions, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int32 timeoutInitialMs, Int32 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
System.Net.WebException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpBasedProvider.DoRequest(GlobalState owner, ExecutionOptions executionOptions, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int32 timeoutInitialMs, Int32 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
System.AggregateException
ValidationException
at System.Net.HttpWebRequest.GetResponse()
at Invantive.Data.Providers.Http.HttpBasedProvider.DoRequest(GlobalState owner, ExecutionOptions executionOptions, HttpWebRequest request, String url, ObjectDefinition objectDefinition, QueryObject queryObject, String partitionCode, String callSafeNameOverrule, String anonymizedPostText, Boolean allowRetryOnNoConnectionMade, Boolean allowRetryOnConnectionLoss, ParameterList parameters, Guid nativeCallUid, Boolean throwExceptionOnNonSuccessfulStatusCode, Object requestBody, Int32 timeoutInitialMs, Int32 timeoutMaxOnRetryMs, String resultCacheId, String publicQueryParameters, ExecutionStatistics& executionStatistics, ODataErrorProcessingInstructions& oDataErrorProcessingInstructions)
Gebruikte URL:
/api/v1/410738/bulk/SalesOrder/SalesOrders?$select=SelectionCode,SelectionCodeCode,SelectionCodeDescription,AmountDC,AmountDiscount,AmountDiscountExclVat,AmountFC,AmountFCExclVat,ApprovalStatus,ApprovalStatusDescription,Approved,Approver,ApproverFullName,Created,Creator,CreatorFullName,Currency,DeliverTo,DeliverToContactPerson,DeliverToContactPersonFullName,DeliverToName,DeliveryAddress,DeliveryDate,DeliveryStatus,DeliveryStatusDescription,Description,Discount,Division,Document,DocumentNumber,DocumentSubject,InvoiceStatus,InvoiceStatusDescription,InvoiceTo,InvoiceToContactPerson,InvoiceToContactPersonFullName,InvoiceToName,Modified,Modifier,ModifierFullName,OrderDate,OrderID,OrderNumber,OrderedBy,OrderedByContactPerson,OrderedByContactPersonFullName,OrderedByName,PaymentCondition,PaymentConditionDescription,PaymentReference,Remarks,Salesperson,SalespersonFullName,ShippingMethod,ShippingMethodDescription,Status,StatusDescription,TaxSchedule,TaxScheduleCode,TaxScheduleDescription,WarehouseCode,WarehouseDescription,WarehouseID,YourRef,SalesChannel,SalesChannelCode,SalesChannelDescription,IncotermAddress,IncotermCode,IncotermVersion