How do you use the WebAPI login?

David Jenkins 946 Reputation points

I'm trying to learn how to setup WEB API authentication. Any articles would be helpful. I might be trying to do the wrong thing.

I would like to use Odata connections in Excel and have them refresh. I get errors when I do. I thought that it was permissions since the Excel app isn't logged in as anyone during the refresh.


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor

    Hi @David Jenkins ,
    I suggest you refer to these links and check if you can get any help from it:

    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.