Create HTTP Data Actions
You can use an HTTP API data action in a workbook so that when you select a column, it sends the value to a REST API which returns a response.
You must configure the domain that you're trying to connect to as a safe domain before you create an HTTP API data action. See Register Safe Domains.