we have new custom columns of type subform in one of our tables (Deals table to be exact)

we need to be able to fetch those data columns

I reached support and they asked engineerin about it

they came up with 2 approaches, each with a limitation that blocks implementation:

Approach 1: 

 

We can try to incrementally get the subforms with the help of /{module_api_name}/id but assigning the parent-child relationship to the standard_module-subform is not possible. It is because of the following reasons:

• A subform's name is given by the customer and all the fields are custom ones in a subform. Mapping that particular subform's parent_id to be the id of the parent standard module in run time is not possible.

Limitation:Due to the above reason delete captures cannot happen.

 

Approach 2:

If we were not to assign any relationship , the endpoint /{subform_api_name} would help but it has a limitation that the subform will be a reimport table.

• Each time a new subform entry is added , the whole table will be synced.
• Each time a subform entry is deleted , the whole table will be synced.
• In case the whole subform is deleted ,a state variable would have stored the subforms which were active in the previous sync and check if there are null entries in current sync and deletes them.