Hello,
There is an excel file in SharePoint that is updated regularly by a business team. We are looking to ingest this file and load the data into a custom table. I was able to create a Data source and makes a REST API call to Microsoft Graph API. The result is that I am able to load 1 worksheet worth of data into a Import set table and then use a transform map to populate it to the custom table. Here is the problem:
1. There are multiple worksheets. The Microsoft Graph API seems to only let me query one sheet per Rest Call. Even if I knew all the names of every worksheet. How do I program the Data Source or the Action to make multiple REST AP Calls and bundle them in one import set. Also, the worksheet is a property of the data, my custom table has a field that will track which worksheet the row came from, how can I parse the worksheet name into a field in the import set.
2. Even if I have to create Multiple Data Source records for each worksheet, how do I pass a worksheet name variables from the Data Source to the Action, is the only way to create multiple action that look exactly the same, except for the worksheet name?
Thanks in advance.
