Can i use excel get and transform function to fetch data in excel from manager file.
snapshot of excel get and transform function is attached.
i have used it couple of time to fetch data from web tables.
You can’t use that particular method for a website that requires login.
However, you can build a query using the API
API using excel