We are looking to make API which gets data from any lookup table (with input as TableName), seeking good design principles. It will be sent to Angular web front end.
The lookup table, can be Table and Columns below. We have 1000+ lookup tables; and trying to reduce code base instead of individually writing 1000 APIs and DTOs for each. Eg:
Product: ProductId, ProductName, ProductDescription Company: CompanyId, CompanyBusiness, CompanyArea Inventory: InventoryCode, InventoryVendor, InventoryLocation
What is the best way to return data from lookup tables in API? Should we use
dynamic type, and send to Angular?