Using Losant API in Excel

Has anyone tried open the Losant API to read data tables through Excel?
I can authenticate/connect and get the table information, but I can only see total record counts not detailed record data.

I set up a webhook and have Excel call that endpoint which runs a workflow that collects the data table and formats to CSV.

Where in excel can you call that endpoint?