can't connect api link using excel

Olusoji Oyeyemi 1 Reputation point
2022-02-17T14:09:32.823+00:00

We are trying to fetch data into an excel file using API however it is not working. We are able to access the same API using postman and other tools, it seems excel /office is blocking the connections. Can you please help us to resolve this.
175452-image.png

175395-image.png

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
    2022-02-18T09:07:05.403+00:00

    Hi @Olusoji Oyeyemi ,
    It seems the username is incorrect, try to remove @kpler.com from User name and check if it will help.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.