In our classic customization we have added UD01 as a child table to a Sale Order in our customization to act as a change log. We are using Key1 as the Sales Order Number and Key5 as the line number of each change log entry. I am trying to recreate this in Kinetic 2025.2 and have not had much luck. Is there any examples out there showing this. Also, I tried using the REST API help to retrieve some existing records. I want to fill a grid with all lines for an order. Also, I want to add, edit and delete line.
GetByID fails, I entered a sales order number under Key1 and get a 500 error. If I additionally adding a line number for Key5, it still fails.
GetList and GetRows will dump the whole UD01 table if I put in no where clause. If I enter a where clause, it fails again.
Iâm still learning so forgive me the potentially silly question⌠but, if youâre using UD01 as a child table Sales Orders⌠youâre still within the internal scope of Epicor, right? Iâm wondering why youâre using the API v2 GetByID method (requiring an API Key) vs the API v1 method.
This doesnât sound like it is for external access, but Iâm still wrapping my head around all of this.
Just curious if you test against the API v1 method⌠where you only need to pass the Key values, do you get a successful return?
select
[UD01].[Company] as [UD01_Company],
[UD01].[Key1] as [UD01_Key1],
[UD01].[Key5] as [UD01_Key5],
[UD01].[Character01] as [UD01_Character01],
[UD01].[Character10] as [UD01_Character10],
[UD01].[Number01] as [UD01_Number01]
from Ice.UD01 as [UD01]
