API using excel

[gisselletdean]

I was trying to access the API page using excel as follows:

But after inputting credentials I keep getting this error message:

Is there something more that I should do to get excel to log in to the api page?

Note: I am using an administrator account and use the password saved in my wallet.

[Agnescott]

I made some experiments with Excel and manager last summer. Working with the old APIs is completely impractical.

[MaritzaSchmidt]

Pulling data from the API into Excel can be tricky, but one approach is using Power Query. You can make GET requests directly within Excel to fetch data from Manager API. If you're looking for a deeper understanding of working with data in Excel, excel.tv has some great insights into automation and API connections in spreadsheets. JSON parsing will be important as well, depending on how the API delivers data.