| Discussion Forum: Thread 336372 |
|
 |
| | | Author: | ianshires  | | Posted: | Mar 12, 2023 20:25 | | Subject: | Bricklink API using Excel VBA | | Viewed: | 113 times | | Topic: | General | |
|
| I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
|
| | | | | |
| | | | | Author: | Nubs_Select | | Posted: | Mar 13, 2023 00:25 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 55 times | | Topic: | General | |
|
| In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
Brickstore (or brickstock can never remember which but it’s the one with the
blue hat) sounds like it could be some help if your interested in mass price
changes and uploads
|
|
| | | | | |
| | | | | Author: | Leftoverbricks | | Posted: | Mar 13, 2023 06:46 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 41 times | | Topic: | General | |
|
| In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
Here's another one who wants to know.
|
|
| | | | | |
| | | | | Author: | Leftoverbricks | | Posted: | Mar 13, 2023 12:01 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 40 times | | Topic: | General | |
|
| In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
I googled "bricklink api excel vba" and the only results I got were this
very thread and the same question on another forum with no answers.
However, I'm sure that there are people around here who know how-to but I'm
afraid that they will keep their knowledge to their selves. @Teup could be helpful
but he's no longer on the forum.
|
|
| | | | | |
| | | | | Author: | Ra | | Posted: | Mar 13, 2023 13:12 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 35 times | | Topic: | General | |
|
| In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
I had something working in excel vba, but got stuck on hashing. I used postman
to get the hashed api call for orders and you could send the same line, but nothing
that was more dynamic like a specific order number.
Ditched excel and moved on to python, that worked good and flexible. I got the
api setup from a bricklink api. Setting python up was a pain and the api had
errors in it.
So then i moved on to C++ to get the graphical interface and rewrote most of
it but again wad stuck on the hashing, but had everything else working.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | Ra | | Posted: | Mar 13, 2023 13:18 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 33 times | | Topic: | General | |
|
| In General, ZorBeast writes:
| | In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
Thanks!
|
I had something working in excel vba, but got stuck on hashing. I used postman
to get the hashed api call for orders and you could send the same line, but nothing
that was more dynamic like a specific order number.
Ditched excel and moved on to python, that worked good and flexible. I got the
api setup from a bricklink api. Setting python up was a pain and the api had
errors in it.
So then i moved on to C++ to get the graphical interface and rewrote most of
it but again wad stuck on the hashing, but had everything else working.
|
I also tied the python code to sync with google sheets, but there were differences
of opinion on how google sheets couldnt directly interact with bl
|
|
|
| | | | | |
| | | | | Author: | hedgehog_bricks | | Posted: | Mar 13, 2023 13:29 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 37 times | | Topic: | General | |
|
| In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
|
Perhaps this could be useful? https://github.com/VBA-tools/VBA-Web
It looks a bit old (no updates in 3.5 years), but does at least look like it
handles the authentication part which is the most non-trivial bit. Also, I haven't
used VBA for 25 years, so I'm unlikely to be able to help any more!
Jonathan
|
|
| | | | | | | | | |
| | | | | | | Author: | ianshires | | Posted: | Mar 18, 2023 19:55 | | Subject: | Re: Bricklink API using Excel VBA | | Viewed: | 33 times | | Topic: | General | |
|
| Thanks for all the responses!
In the end I have started to use Brickstore (which is excellent for downloading
/ adjusting my store inventory and updating prices) and a bit of Excel too....
No API in VBA required!
Ian
In General, hedgehog_bricks writes:
| | In General, ianshires writes:
| | I would be interested to know if anyone uses API for pulling data from BL into
Excel using VBA. It would be great to automate mass upload / pricing but I don’t
know where to start with API (although I’m pretty proficient at VB…)
Would anyone share some basic VBA code to pull data?
|
Perhaps this could be useful? https://github.com/VBA-tools/VBA-Web
It looks a bit old (no updates in 3.5 years), but does at least look like it
handles the authentication part which is the most non-trivial bit. Also, I haven't
used VBA for 25 years, so I'm unlikely to be able to help any more!
Jonathan
|
|
|
|
|
|
|
|
United Kingdom, England
Canada, Ontario
Netherlands, Overijssel
USA, New York
