Integrate WebAPI into Excel sheet

[artilheirogomes]

Hello everyone.

I would like some assistance or tips.

I want to build a database in Excel that contains a certain amount of serial numbers from some computers destined to test. The results of the tests that run on each SN are saved into a database which have interaction a Webpage.
I want through the API to read the SN from excel sheet and export from the API the results of the tests (Passed, Failed) to the excel.

I have the hyperlink address and the API code itself.

Can anyone help me with this?
Many thanks in advance

Kind regards

artilheirogomes