I have two different tables in joget linked to each other, one table is for products, and the other table is for product attributes. Product attribute is linked to product table with column product id (foreign key).

I need to create the API for both the tables through joget API builder.

Below are the sample tables.

But for now, it gives me the results of something like this in JSON format.

JSON Format For product table:

JSON format For the Attribute mapping table:

We have tried joining two different tables and generated the API for the same. But it does not meet our requirements. Following is the JSON format for the same.

But I need to create an API that generates the combined data from both lists based on Product id.

I need the output of something like the below for the above two tables.

Is it possible with the API builder Plugin to build a combined API for the two tables?