Add fields from two different tables in API page

(0) Share

Report

Posted on by Sujan Khadka

I have to add two different fields on one API page. let's say one from the employee table and another from the default dimension. How can I achieve this?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I assume you need to create a page which has the fields added to it and from there create the API page.

Thanks.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

There is an example here you can follow as long as there is a relation between the tables:

docs.microsoft.com/.../devenv-develop-custom-api

If there is no releation you have to add code to the OnAfterGetRecord trigger to retrieve the data you need from the other tables.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, or you create a normal page, get the data on OnOpenPage trigger, and publish it in the Web Service.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No