"Post" method not working while using API in VBA

Sandhiya07
Sandhiya07 ✭✭✭

Hi,

I want to update values in smartsheet using API Key but post method is not working.

Thanks,

Sandhiya P

Answers

  • Hi @Sandhiya07

    I haven't had experience with VBA at all, but from what I found on the internet it looks like VBA may only give you API access to update Microsoft related products. Here's the article I found.

    I'd suggest testing your calls in Postman to see if you're able to Post to Smartsheet in general.

    Cheers,

    Genevieve

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

  • Sergio G.
    Sergio G. ✭✭

    Hey! I hope the information below is useful to you and to anybody working with VBA since the information available is limited to none. I personally myself work a lot with VBA Excel and had to figure this one out.

    Follow the Code Formatting and replace values with your personal information. Make sure you run a GET Request first so you can get rowIDs and whatnot.

    image.png image.png image.png image.png