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]
I am trying to insert the where clause into the where parameters for the UD01.GetRows Method with no success. It runs in REST API Help, but the same does not return results when I call UD01.GetRows. I built the where clause in a row-update and save it in TransView.WhereOrderNum and pass that as the where parameter. With no parameters set, all rows are returned. What am I missing?
