"Post" method not working while using API in VBA

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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • 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.