Companies House API

详细信息

I am looking to pull data from companies house using their api. (https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/reference)
I would like the script to look up the company name in column A of this gsheet https://docs.google.com/spreadsheets/d/15rRpXZMmf0wUXl0hfQy05HBGifTCAAHl19q_gqzZJNg/edit#gid=0 and return the company number, director and persons of significant control.
I would preferably like the script to work in Appscript within the gsheet if possible?
It does require an API token so it will require you to register to create a token.