Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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.
I am trying to do the exact same thing. If anyone knows of a way, please let me know.