External API call support in Office Scripts - Office Scripts Calls to external APIs can only be made through the Excel application, not through Power Automate under normal circumstances External calls are also not supported for scripts stored on a SharePoint site
External APIs | Apps Script | Google for Developers Google Apps Script can interact with APIs from all over the web This guide shows how to work with different types of APIs in your scripts You can use the UrlFetch service to make API
You do not have permission to call UrlFetchApp. fetch You'll need to authorize your script to access the external_request service If you're the owner of the project, you should be able to grant access by running and confirming with the oauth page
Authorization Scopes | Apps Script | Google for Developers The script project defines these individual permissions as OAuth scopes For most scripts, Apps Script automatically detects what scopes are needed for you; you can view the scopes a script
List of permissions needed for SharePoint REST calls For our needs, we ticked the box "Enumerate Permissions" which includes these dependant permissions: Browse Directories, View Pages, Browse User Information, Open Assigning that role to a user then resulted in them being able to use the REST endpoints for read-only operations as desired
Authorizing an Apps Script - spreadsheet. dev Authorization is the process by which you grant the script whatever access it needs to run Let's imagine that you've created a new Apps Script and you haven't written any code yet You run the script by clicking the Run button The script will run just fine and it won't ask you for any permission