Exposing REST API to consumer external system

[sandeep3791]

Hi,

I have extended 2 tables from Business Service table. I need to expose REST API to support CRUD operations for the consumer external systems of my tables and that is through ESB layer.

Option 1

Shall I use import set and transform map with target table as Business service. Type field will direct the data to either extended table.

Or

Option 2

shall I simply expose 2 different REST APIs with 2 import set and 2 transform maps,

First REST API - first import set - first Transform map - Target table as first extended table

Second REST API - second import set - second Transform map - Target table as second extended table

Option 2 saves me some complexities I am facing with option 1 due to some table specific fields behavior as it will be a direct mapping.

Kindly suggest which approach is better or recommended.

Thanks

[marcguegueniat]

Hi,

Personaly I would go with option 2.

First thing is that a transform map targets a specific table. It will be tricky to retarget record to a child table of the original table.

This would not be efficient either for performance or maintenance, I think.

Second point is more functional.

If you came out with the need to extend one table into 2 childs, there is a reason, your data is somehow different in the 2 tables.

So I would not be so surprised to have 2 API exposed.

But this is just my point of vue!

Regards,

Marc