I need to get the table data from an API connector. I can achieve it by using REST connector, however I would like to get the data from 100 + tables. Traditional way is create all 100+ connections (because to query each table I need t use a unique API URL) first, then build query. Is there any programmatic way to build all connections at one go based on excel sheets API URLs? so that I can use routines to pass parameters and retrieve the data from all of APIs.
