Small and medium business | Business Central, N...

API get field from another table

(0) Share

Report

Posted on by Samantha73

2,413

Hi All

I'm creating an API for purchase Line (directly using line table instead of buffer table). Is there any way to link Dimension Set Entry table and get global dimension = 1 so I can show the dimension value rather than dimension set ID?

All responses (2)

Answers (0)

Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: API get field from another table

The value for global dimension 1 should be available for you directly on the purchase line table, so that is a field you should be able to add directly to your API page.

The same goes for short-cut dimension 2
Suggested answer

Tech-Lucky 796 on at

Like (0)

Report

RE: API get field from another table

Yes, you need to create the variables and assign the Values from the Dimension Set Entry Record to variables and you can easily use the variables as the fields to show the data accordingly.

Mark this answer to verify if this was helpful.