Skip to main content

Need authorization help using API v2 with Excel VBA

  • June 19, 2020
  • 6 replies
  • 4594 views
JCorrell
Forum|alt.badge.img

I’ve created an Excel workbook using VBA to update monday using API v2. Currently, I have my own API token as a constant in the VBA project. I want to be able to have other people use the workbook. Obviously, having my token as a constant is not optimal. The other possibility I see is to have the user paste their token into the sheet. I don’t like that they would either have to paste their token every time they opened the workbook or allow them to save it with the token.

My preference would be that the fact that they are logged in on monday would allow them access to the API.

Any ideas?

This topic has been closed for replies.

6 replies

basdebruin
  • basdebruin
  • Community Expert
  • June 20, 2020

Hi @JCorrell, Jim

This is where OAuth comes in 🙂. You make an HTTP request to https://auth.monday.com/oauth2/authorize? where you specify a callback. The callback will be called by monday.com with a code. With this code you make another HTTP request to https://auth.monday.com/oauth2/token and you wait for a return from monday.com with a token. In this handshake you can define what your VBA project wants to do with the board (scope) and the user will be prompted to authorize this.

There’s a repository with a simple server to server example usage of the monday.com OAuth functionality in general: https://github.com/yuhgto/monday-oauth-example

See also an article here: https://monday.com/developers/apps/oauth

    JCorrell
    Forum|alt.badge.img
    • JCorrell
    • Author
    • Community Expert
    • June 22, 2020

    Thanks for the help!

    S
    • stuart.radlett
    • New Participant
    • September 10, 2020

    Hi,

    I’m looking to do a similar thing from Excel; did you get anywhere with this and have any code you are willing to share?

    Thanks,

    Stuart

    JCorrell
    Forum|alt.badge.img
    • JCorrell
    • Author
    • Community Expert
    • September 10, 2020

    I gave up on the Oauth. I basically went the token route. I added logic to allow user to save their token in an encrypted format that they could then reuse with a password.

    If you get it to work without a redirect server, I’d like to see it.

    If you are interested in the token logic, let me know.

    S
    • stuart.radlett
    • New Participant
    • September 10, 2020

    Hi,

    Thanks for the speedy response.

    I really would appreciate anything you can share with me. I’m trying to evaluate whether Monday fits our needs and the ability to work with it via the API and Excel is critical.

    Cheers,

    Stuart

    JCorrell
    Forum|alt.badge.img
    • JCorrell
    • Author
    • Community Expert
    • February 25, 2021

    This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

    Terms & ConditionsCookie settingsAccessibility statement