Help getting started with using Excel VBA to get info from API

[darthslipper]

Hello all,

I have been using the site BrickLink for the past year and would like to use their API to get information from their catalog, etc. I have some basic VBA knowledge, but I am stumped when it comes to using it for this task.

I think I have a good grasp of how to use the various methods and manipulating the data once received. The main issue is that I am getting hung up on the OAUTH 1.0 authentication process. I am hoping that someone can help me in creating the code needed to properly access the API.

Here is a link to the API's Wiki: API References - BrickLink Store API - Redmine
and specifically the Authorization part: Authorization - BrickLink Store API - Redmine

Any help, or even pointing me in the directing of a step by step tutorial. I have been searching the web for the past couple days and nothing I am finding is helping.

Thanks!

 

[Rijnsent]

Hi DarthSlipper,
a good starting point for that is the site of @brucemcpherson, it has helped me in the past: Basic HTTP Authentication from VBA - Desktop Liberation
Cheers,
Koen