"Post" method not working while using API in VBA

Sandhiya07

Hi,

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

Thanks,

Sandhiya P

Genevieve P.

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.

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.