As of version 2023.1.6, I am seeing a change in the way dates are returned via the REST API, compared to past versions. It has broken our software integrations that rely on BAQs. For example, I have a BAQ that I am running in versions 2022.2.12 and 2023.1.6. The BAQ returns at least one date field. …

It is a real bug. We tested it here. [image] REST date/datetime bug reality check Kinetic ERP Whatever the issue is, it’s going to be on your sql server, not the app server. Cast/convert is done in sql directly. If you can use the varchar and make it a date after th…

To be specific, you’ll have to read the thread, that statement quoted that I made was partially incorrect.

I got a call from Epicor Support. They are aware of the issue and development is researching it. Currently only v2 of the REST API is affected, so a workaround would be to call v1 of the API. This is OK for external integrations, but I’m not sure if API calls internally (like in App Studio) can be…

[image] andrew.johnson: but I’m not sure if API calls internally (like in App Studio) can be helped. May be able to fudge it with a function call. :thinking:

[image] klincecum: May be able to fudge it with a function call. :thinking: If true then only mostly! The issue is that the API appears to be handling the variety of date/time datatypes with a one size fits all method that (incorrectly) casts values to a fully qualified datetimeoffset value. …

Date Values in BAQ Results via REST API

Kinetic ERP

gpayne (Greg Payne) June 29, 2023, 1:18pm 2

It is a real bug. We tested it here.

If you can use the varchar and make it a date after that could be a workaround.

Topic		Replies	Views
REST date/datetime bug reality check Kinetic ERP	31	2610	September 11, 2023
Kinetic 2023 and MS PowerQuery Date/Time/Zone Woes Kinetic ERP rest	0	383	June 14, 2023
REST API Date format Epicor ERP 10 rest-api	9	3328	November 17, 2021
REST converting ISO dates in character fields to US dates Kinetic ERP rest	129	7646	October 28, 2023
REST API Time Zone offset throwing me for a loop Epicor ERP 10 rest	13	2635	June 8, 2018

Date Values in BAQ Results via REST API

Related topics