| Discussion Forum: Thread 325954 |
|
 |
| | | Author: | bricktopiausa  | | Posted: | Aug 21, 2022 21:38 | | Subject: | API with Google Sheets | | Viewed: | 114 times | | Topic: | Related Software | |
|
| Trying to make small program that I can quickly get set value and part out value
if possible really quick, without having to go to the pages. Would use while
buying stuff to part out to feed my store.
So I have a google sheet
I put the add-on "API to Sheets" also tried "Rest|API Connector" and got the
same issues so i'm not doing something right
For this one we will talk about "API to Sheets" if you know of one that you got
to work let me know and how you did it.
I have registered as a consumer API with Bricklink
Data Give is
ConsumerKey - "CK"
ConsumerSecret - "CC"
I added a new token, not sure if i should use the same one I use for Bricksync
TokenValue - "TV"
TokenSecret - "TS"
before going more I used a page http://lti.tools/oauth/ to check my data and
it generated my oauth_signature. I inputed my "CS" and my "TS" in their respected
spots and it generated a new encrypted signature and we will refer to it as "SIG"
I then went to https://www.bricklink.com/v3/api.page?page=auth and looked at
the data there
URL i used was https://api.bricklink.com/ (I even tried api.bricklink.com/api/store/v1/items/set/number/price)
oauth_consumer_key is my "CK"
oauth_token is my TV
oauth_signature_method is HMAC-SHA1 (this is always)
oauth_signature is the SIG (generated from my CS&TS)
oauth_timestamp on that other site I selected the day and time for today and
inputed it
oauth_nonce This one I'm confused on the examples are all "kllo9940pc9333jh"
but also says it is generated special each time??????? what do I use here where
do i get it
oauth_version is always 1.0
Any help would be great
I want to put the set number in a cell and have it come back with the price-
as i have a program that I an enter set number and barcode as ways of searching
for a set, then I want to see Set Price and part out price
Also is there a way to get the partout price in API?
|
|
|
|
| | | | | |
| | | | | Author: | macebobo | | Posted: | Aug 21, 2022 21:52 | | Subject: | Re: API with Google Sheets | | Viewed: | 45 times | | Topic: | Related Software | |
|
| In Related Software, bricktopiausa writes:
snip
What method are you calling? and what parameters are you passing.
| | Also is there a way to get the partout price in API?
|
No, not that I know of.
|
|
| | | | | | | | | |
| | | | | | | Author: | bricktopiausa | | Posted: | Aug 21, 2022 21:59 | | Subject: | Re: API with Google Sheets | | Viewed: | 38 times | | Topic: | Related Software | |
|
| not sure what you mean by method?
and calling?
|
|
| | | | | |
| | | | | Author: | 1001bricks | | Posted: | Aug 21, 2022 22:53 | | Subject: | Re: API with Google Sheets | | Viewed: | 59 times | | Topic: | Related Software | |
|
| In Related Software, bricktopiausa writes:
| | Trying to make small program that I can quickly get set value and part out value
if possible really quick, without having to go to the pages. Would use while
buying stuff to part out to feed my store.
|
Wheel, reinventing...
You'll get this instantly, freely and open-source, + many other powerful
features using BrickStore.
https://github.com/rgriebl/brickstore/releases
|
|
| | | | | | | | | |
| | | | | | | Author: | bricktopiausa | | Posted: | Aug 22, 2022 07:42 | | Subject: | Re: API with Google Sheets | | Viewed: | 35 times | | Topic: | Related Software | |
|
|
Brickstore doesn't work on my phone, they have an app but doesnt' work.
I start a new file, no way to input a new set or part only import from my
store. Beside if it worked like the desktop program I use all the time. I would
have to add the set manually, part the set out, set prices, look for total.
I want to scan the barcode and bam have the numbers there that I need while sitting
in a clearance isle deciding if I'm buying or not.
|
|
| | | | | |
| | | | | Author: | ErwinNL | | Posted: | Aug 22, 2022 11:42 | | Subject: | Re: API with Google Sheets | | Viewed: | 33 times | | Topic: | Related Software | |
|
| In Related Software, bricktopiausa writes:
| | Trying to make small program that I can quickly get set value and part out value
if possible really quick, without having to go to the pages. Would use while
buying stuff to part out to feed my store.
So I have a google sheet
I put the add-on "API to Sheets" also tried "Rest|API Connector" and got the
same issues so i'm not doing something right
For this one we will talk about "API to Sheets" if you know of one that you got
to work let me know and how you did it.
I have registered as a consumer API with Bricklink
Data Give is
ConsumerKey - "CK"
ConsumerSecret - "CC"
I added a new token, not sure if i should use the same one I use for Bricksync
TokenValue - "TV"
TokenSecret - "TS"
before going more I used a page http://lti.tools/oauth/ to check my data and
it generated my oauth_signature. I inputed my "CS" and my "TS" in their respected
spots and it generated a new encrypted signature and we will refer to it as "SIG"
I then went to https://www.bricklink.com/v3/api.page?page=auth and looked at
the data there
URL i used was https://api.bricklink.com/ (I even tried api.bricklink.com/api/store/v1/items/set/number/price)
oauth_consumer_key is my "CK"
oauth_token is my TV
oauth_signature_method is HMAC-SHA1 (this is always)
oauth_signature is the SIG (generated from my CS&TS)
oauth_timestamp on that other site I selected the day and time for today and
inputed it
oauth_nonce This one I'm confused on the examples are all "kllo9940pc9333jh"
but also says it is generated special each time??????? what do I use here where
do i get it
oauth_version is always 1.0
Any help would be great
I want to put the set number in a cell and have it come back with the price-
as i have a program that I an enter set number and barcode as ways of searching
for a set, then I want to see Set Price and part out price
Also is there a way to get the partout price in API?
|
What you want requires multiple calls per Set you want to check.
- Get Set subset
/items/{type}/{no}/subsets
- Get Price Guide for each item or Set
/items/{type}/{no}/price
You need to specify all the required and optional GET parameters you need, and
those will change the OAuth signature. Meaning you have to recalculate each time.
I have no idea if this is possible with Google sheets.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | ErwinNL | | Posted: | Aug 22, 2022 11:46 | | Subject: | Re: API with Google Sheets | | Viewed: | 39 times | | Topic: | Related Software | |
|
| In Related Software, ErwinNL writes:
| | In Related Software, bricktopiausa writes:
| | Trying to make small program that I can quickly get set value and part out value
if possible really quick, without having to go to the pages. Would use while
buying stuff to part out to feed my store.
So I have a google sheet
I put the add-on "API to Sheets" also tried "Rest|API Connector" and got the
same issues so i'm not doing something right
For this one we will talk about "API to Sheets" if you know of one that you got
to work let me know and how you did it.
I have registered as a consumer API with Bricklink
Data Give is
ConsumerKey - "CK"
ConsumerSecret - "CC"
I added a new token, not sure if i should use the same one I use for Bricksync
TokenValue - "TV"
TokenSecret - "TS"
before going more I used a page http://lti.tools/oauth/ to check my data and
it generated my oauth_signature. I inputed my "CS" and my "TS" in their respected
spots and it generated a new encrypted signature and we will refer to it as "SIG"
I then went to https://www.bricklink.com/v3/api.page?page=auth and looked at
the data there
URL i used was https://api.bricklink.com/ (I even tried api.bricklink.com/api/store/v1/items/set/number/price)
oauth_consumer_key is my "CK"
oauth_token is my TV
oauth_signature_method is HMAC-SHA1 (this is always)
oauth_signature is the SIG (generated from my CS&TS)
oauth_timestamp on that other site I selected the day and time for today and
inputed it
oauth_nonce This one I'm confused on the examples are all "kllo9940pc9333jh"
but also says it is generated special each time??????? what do I use here where
do i get it
oauth_version is always 1.0
Any help would be great
I want to put the set number in a cell and have it come back with the price-
as i have a program that I an enter set number and barcode as ways of searching
for a set, then I want to see Set Price and part out price
Also is there a way to get the partout price in API?
|
What you want requires multiple calls per Set you want to check.
- Get Set subset
/items/{type}/{no}/subsets
- Get Price Guide for each item or Set
/items/{type}/{no}/price
You need to specify all the required and optional GET parameters you need, and
those will change the OAuth signature. Meaning you have to recalculate each time.
I have no idea if this is possible with Google sheets.
|
Ps. you only have 5000 calls, checking a large Set's part-out value will
likely take really long and will eat your calls like candy.
|
|
|
|
|
|
|
USA, Kentucky
France, Provence-Alpes-Côte d'Azur
Netherlands, Overijssel