Our client is using web scheduler with Sage X3.
When importing data from Sage in Bricks we are getting the following error
"TOTAL IMPORT ENDED WITH ERRORS; PLEASE CHECK INTERFACE LOG FILE ENTITY;
Import ERROR; The remote server returned an error: (400) bad request"
on checking the log here is the section where it references the error
2025-09-09 01:37:29.5341|INFO||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|QueryMaterialDefinitionAPI retrived 400 rows.
2025-09-09 01:37:29.5341|TRACE||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|New pagination after: "[\"401043\",\"\\"BG 916 NITRILE O RING (SUITS 1 5/16\\"\\" UNF\\"\",\"PURCH\"]#43"
2025-09-09 01:37:29.5341|INFO||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|Calling API at xyz:8126/../api
2025-09-09 01:37:29.5341|TRACE||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|Query of QueryMaterialDefinitionAPI: { x3Manufacturing { workOrderMaterialLine { queryAggregate( first: 200 filter: "{_updateStamp: {_gte: '2000-01-01 00:00:00Z'}, productionSite:'OH1', number: {orderStatus: {_lt: 4}}, _or: [{ number:{workOrderOptimized: true}}, { number:{schedulingStatus: 4}}]}" after: "[\"401043\",\"\\"BG 916 NITRILE O RING (SUITS 1 5/16\\"\\" UNF\\"\",\"PURCH\"]#43" ) { pageInfo { endCursor hasNextPage startCursor hasPreviousPage } edges { node { group { product { code localizedDescription1 productCategory { code } } } } } } } }}
2025-09-09 01:37:29.6081|INFO||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|Execution time of QueryMaterialDefinitionAPI HTTP web API call on endpoint xyz.com.au:8126/.../api 60.25 ms.
2025-09-09 01:37:29.6081|ERROR||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|The remote server returned an error: (400) Bad Request.
2025-09-09 01:37:29.6151|ERROR||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI|System
2025-09-09 01:37:29.6151|ERROR||Sedapta.Sage.X3InterfaceService.API.Actions.QueryMaterialDefinitionAPI| at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
