I need help with getting result back from a web api. The data which I need to pass to the api is stored in a column and I need a new column to be populated with the result from the web See the example below (BSID is what is available and Group is what I need to get from the Api using the URL https://api.macvendors.com/"BSID")
BSID - Group
FCA13E - Samsung Electronics Co.,Ltd
8841fc - AirTies Wireless Networks
Example of a call would be
In the Query Editor, add a Custom Column (Add Column > Custom Column) with the following:
Csv.Document(Web.Contents("https://api.macvendors.com/" & [BSID]))
After that, you'll want to expand the column, then merge the column with "Space" as the separator, and finally rename the column to Group.
Shouldn't be a problem running this against 1000s of rows. I've run something similar across tens of thousands of rows. The main potential issue you'll face is rate limiting from the API. If you run into something like that, try this:
Could you please mark the proper answers as solutions?