search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2.01k stars 494 forks source link

Example to make an oauth 1.0 call to Etsy's API #413

Open mss-code opened 5 years ago

mss-code commented 5 years ago

I am new to programming and need to use VBA to make an oauth 1.0 request to Etsy's API to bring the data into Excel. I have my oauth token, consumer key, etc., but do not understand enough to adapt your oauth 1.0 example to Etsy. Can you please do an Etsy example? Thanks so much!

coderpros commented 4 years ago

I just finished doing exactly this. Feel free to reach out to me & we can discuss if you still need it.

I am new to programming and need to use VBA to make an oauth 1.0 request to Etsy's API to bring the data into Excel. I have my oauth token, consumer key, etc., but do not understand enough to adapt your oauth 1.0 example to Etsy. Can you please do an Etsy example? Thanks so much!

jjkuest commented 3 years ago

were you ever able to get a solution for this? I am having problems as well, would like to know more.

mss-code commented 3 years ago

Hi. No, I never got any responses or a solution. Good luck!

On Mon, Dec 14, 2020 at 2:55 PM jjkuest notifications@github.com wrote:

were you ever able to get a solution for this? I am having problems as well, would like to know more.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/VBA-tools/VBA-Web/issues/413#issuecomment-744673117, or unsubscribe https://github.com/notifications/unsubscribe-auth/ANCANLEVXFPDWPZ2ZCQ6CSDSUZURXANCNFSM4ISZQL2A .

mitaithecat commented 2 years ago

Has anyone been able to find code for this?

coderpros commented 2 years ago

I did this about a year ago. It's a standard oAuth implementation. Should be simple for any real programmer. Here is a link to an Access DB with some example code that authenticates to Etsy. Bear in mind I haven't looked at it in a year. As I recall, I only hooked up one API method for this client to get all shop transactions. You'll need to update it with your apiKey and Secret

mitaithecat commented 2 years ago

Hi Brandon,

Thanks for the sample code, I made the changes to the apikey and secret (and changed the store id) but I am getting a 76 error when it tries to pull transactions. Have you ever seen that error?

Ian

From: Brandon Osborne @. Sent: Monday, December 20, 2021 4:23 PM To: VBA-tools/VBA-Web @.> Cc: mitaithecat @.>; Comment @.> Subject: Re: [VBA-tools/VBA-Web] Example to make an oauth 1.0 call to Etsy's API (#413)

I did this about a year ago. It's a standard oAuth implementation. Should be simple for any real programmer. Here is a link to an Access DB with some example code that authenticates to Etsy https://coderpro.net/GemstonesRocks&Such.ProductFinder.accdb . Bear in mind I haven't looked at it in a year. As I recall, I only hooked up one API method for this client to get all shop transactions. You'll need to update it with your apiKey and Secret

— Reply to this email directly, view it on GitHub https://github.com/VBA-tools/VBA-Web/issues/413#issuecomment-998342798 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AKPIFECLPY3WIZBNWTEBNLDUR63DPANCNFSM4ISZQL2A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . You are receiving this because you commented. https://github.com/notifications/beacon/AKPIFEAR4E3RIJFRWOZNR4DUR63DPA5CNFSM4ISZQL2KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOHOAYBDQ.gif Message ID: @. @.> >

coderpros commented 2 years ago

Heya Ian,

I haven't looked at that code in over a year. When I opened it up, I remembered it was for a deadbeat client and barely got past the proof of concept phase, so because of Etsy's incredibly (and abnormally) long token life, you have to also set the UserToken & Secret, which you can get from authenticating in PostMan.

A few of my clients & a few people here have been asking me for something like this recently, so I'll finish it up in the next couple of days and update this thread when I'm done.

On a completely unrelated note, does anyone need an Okta authenticator (that one isn't half-baked)?