Excel Office Scripts - using the Fetching JSON functionality - a DEMO
Excel Office Scripts - using the Fetching JSON functionality - a DEMO
In this repo and in the video I demonstrate how you can use the Fetch function to retrieve REST API data from an internet endpoint. Here, we ae using the Office Scripts default method: GET. You can, specify different methods if needed. Note the use of a Promise as a return value for the Main function and the .json method together with the interface to parse the response.