"Post" method not working while using API in VBA

Options

Hi,

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

Thanks,

Sandhiya P

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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

  • Sergio G.
    Options

    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.