Redisplay Messages: Compact | Brief | All | Full Show Messages: All | Without Replies Author: | qwertyboy | Posted: | May 16, 2023 11:23 | Subject: | Re: API Question: How immutable are id values? | Viewed: | 34 times | Topic: | Technical Issues | |
|
| In Technical Issues, InanimateReason writes:
| I would like to work with the assumption that certain values are essentially
primary keys. category IDs, color IDs, really anything named xxxx ID. It seems
to me that the nomenclature in use implies that anything called 'id'
is immutable while anything else is fair game for modification during catalog
updates.
|
There are precious few fields that can be considered a primary key. Part numbers
can (and do) change, people's login name can (and do) change. There is no
way for us mere mortals to access the actual primary key info for these entities.
If you are considering keeping things like parts history, be prepared to either
set up some links from old part IDs to new part IDs, or update your old data
with new IDs (finding out what the new part ID is when you only have the old
part ID is fun - what is the new part ID of "372"? - most times, the
old ID is kept as an alternative on the site, so you can search for it, but not
from the API). Some parts keep flip-flopping IDs (like 6093/x104, 41669/x346
etc).
Some things that do stay the same are order numbers, color IDs, lot IDs.
Enjoy!
Niek.
|
|
Author: | InanimateReason | Posted: | May 16, 2023 08:09 | Subject: | Re: API Question: How immutable are id values? | Viewed: | 36 times | Topic: | Technical Issues | |
|
| Out of curiousity, I downloaded the codes mapping xml file. I guess element IDs
are only assigned to parts. I did find six minifigs in that download, but the
first one I checked was previously a PART.
https://www.bricklink.com/catalogReqList.asp?itemID=147947
So I guess element IDs may only be useful for the parts type in the catalog.
Other catalog types need some other mechanism to track changes. With no changelog
endpoint or key in the item resource, I guess this will be fun to implement.
In Technical Issues, InanimateReason writes:
| As I work through a client to do useful things with the Bricklink API, I'm
curious what issues other developers have experienced that may impact the robustness
any application.
One thought I just had was that there is no guarantee that the underlying data
is stable within the various catalog related resources.
An obvious example is assignment of part numbers. Clearly, they may change over
time. When they do, are new element ids assigned or would the element id be a
reliable way to ensure data integrity?
Would it be wise to preserve the old part numbers in some way either with a soft
delete or some other kind of deprecation flag?
I would like to work with the assumption that certain values are essentially
primary keys. category IDs, color IDs, really anything named xxxx ID. It seems
to me that the nomenclature in use implies that anything called 'id'
is immutable while anything else is fair game for modification during catalog
updates.
Thoughts?
|
|
|
Author: | InanimateReason | Posted: | May 16, 2023 07:55 | Subject: | API Question: How immutable are id values? | Viewed: | 89 times | Topic: | Technical Issues | |
|
| As I work through a client to do useful things with the Bricklink API, I'm
curious what issues other developers have experienced that may impact the robustness
any application.
One thought I just had was that there is no guarantee that the underlying data
is stable within the various catalog related resources.
An obvious example is assignment of part numbers. Clearly, they may change over
time. When they do, are new element ids assigned or would the element id be a
reliable way to ensure data integrity?
Would it be wise to preserve the old part numbers in some way either with a soft
delete or some other kind of deprecation flag?
I would like to work with the assumption that certain values are essentially
primary keys. category IDs, color IDs, really anything named xxxx ID. It seems
to me that the nomenclature in use implies that anything called 'id'
is immutable while anything else is fair game for modification during catalog
updates.
Thoughts?
|
|
Author: | Nubs_Select | Posted: | May 15, 2023 00:06 | Subject: | Re: PayPal error | Viewed: | 25 times | Topic: | Technical Issues | |
|
| | Their shop is currently closed but I don’t think that affects payment.
|
Nope it dosnt affect if you can pay or not
|
Author: | Stuart9 | Posted: | May 14, 2023 09:21 | Subject: | Re: PayPal error | Viewed: | 35 times | Topic: | Technical Issues | |
|
| Thanks, messaged them a few minutes ago.
In Technical Issues, SylvainLS writes:
| In Technical Issues, Stuart9 writes:
| Only happened this morning, worked fine a couple of days ago.
Just this invoice to pay.
Their shop is currently closed but I don’t think that affects payment.
|
I think the same (or “I don’t think the same”? ).
I’d contact the Help Desk and try again a couple times, after 2-3 hours. If
it eventually works, good, but that shouldn’t prevent them to investigate.
|
|
|
Author: | SylvainLS | Posted: | May 14, 2023 09:18 | Subject: | Re: PayPal error | Viewed: | 30 times | Topic: | Technical Issues | |
|
| In Technical Issues, Stuart9 writes:
| Only happened this morning, worked fine a couple of days ago.
Just this invoice to pay.
Their shop is currently closed but I don’t think that affects payment.
|
I think the same (or “I don’t think the same”? ).
I’d contact the Help Desk and try again a couple times, after 2-3 hours. If
it eventually works, good, but that shouldn’t prevent them to investigate.
|
|
Author: | Stuart9 | Posted: | May 14, 2023 08:34 | Subject: | Re: PayPal error | Viewed: | 32 times | Topic: | Technical Issues | |
|
| Only happened this morning, worked fine a couple of days ago.
Just this invoice to pay.
Their shop is currently closed but I don’t think that affects payment.
In Technical Issues, SylvainLS writes:
| In Technical Issues, Stuart9 writes:
| Keep getting this when I try to pay invoice via pay button.
Paid this way hundreds of times, don’t know why it’s a problem now.
Any ideas ?
|
Have you tried the Help Desk? (Well, it’s Sunday today but you didn’t say when
it started ).
|
|
|
Author: | SylvainLS | Posted: | May 14, 2023 06:20 | Subject: | Re: PayPal error | Viewed: | 35 times | Topic: | Technical Issues | |
|
| In Technical Issues, Stuart9 writes:
| Keep getting this when I try to pay invoice via pay button.
Paid this way hundreds of times, don’t know why it’s a problem now.
Any ideas ?
|
Have you tried the Help Desk? (Well, it’s Sunday today but you didn’t say when
it started ).
|
Author: | Stuart9 | Posted: | May 14, 2023 05:21 | Subject: | PayPal error | Viewed: | 81 times | Topic: | Technical Issues | |
|
| Keep getting this when I try to pay invoice via pay button.
Paid this way hundreds of times, don’t know why it’s a problem now.
Any ideas ?
Cheers
|
|
|
Author: | macebobo | Posted: | May 13, 2023 04:09 | Subject: | Re: API Get Member Notes not working? | Viewed: | 26 times | Topic: | Technical Issues | |
|
| In Technical Issues, ErwinNL writes:
| In Technical Issues, macebobo writes:
| In Technical Issues, ErwinNL writes:
| In Technical Issues, InanimateReason writes:
| In Technical Issues, macebobo writes:
|
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
LOL. Not the first error I've found in the docs. Thanks for the quick response.
|
I've reported this, but no luck yet. There are more missing fields, incorrect
field types ed. Hopefully they get time someday to fix that.
|
Narrator: They will not.
BTW, Bricklink I would gladly help keep the API documentation Up-To-Date.
|
Same, I work with the API daily and wouldn't mind submitting or editing the
issues I find. Win-win for everyone.
|
Submit your findings to apisupport@bricklink.com and Russell states, in time,
they will probably, maybe, get fixed.
With the description he gave of the different "channels" I'm beginning
to think comic guy is correct in illustrating the BL IT having figurative trash
cans in their heads.
I don't know why I expect a subsidiary of a multi billion dollar company
to have a more coherent information system strategy. It's like they don't
want seller's to have the tools to make Bricklink money. SMH
|
|
Author: | ErwinNL | Posted: | May 13, 2023 03:12 | Subject: | Re: API Get Member Notes not working? | Viewed: | 27 times | Topic: | Technical Issues | |
|
| In Technical Issues, macebobo writes:
| In Technical Issues, ErwinNL writes:
| In Technical Issues, InanimateReason writes:
| In Technical Issues, macebobo writes:
|
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
LOL. Not the first error I've found in the docs. Thanks for the quick response.
|
I've reported this, but no luck yet. There are more missing fields, incorrect
field types ed. Hopefully they get time someday to fix that.
|
Narrator: They will not.
BTW, Bricklink I would gladly help keep the API documentation Up-To-Date.
|
Same, I work with the API daily and wouldn't mind submitting or editing the
issues I find. Win-win for everyone.
|
|
Author: | wildchicken13 | Posted: | May 13, 2023 00:19 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 32 times | Topic: | Technical Issues | |
|
| In Technical Issues, axaday writes:
| Can anyone help me sort this out?
|
I can! I'm good at sorting.
|
|
Author: | macebobo | Posted: | May 12, 2023 17:34 | Subject: | Re: API Get Member Notes not working? | Viewed: | 23 times | Topic: | Technical Issues | |
|
| In Technical Issues, ErwinNL writes:
| In Technical Issues, InanimateReason writes:
| In Technical Issues, macebobo writes:
|
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
LOL. Not the first error I've found in the docs. Thanks for the quick response.
|
I've reported this, but no luck yet. There are more missing fields, incorrect
field types ed. Hopefully they get time someday to fix that.
|
Narrator: They will not.
BTW, Bricklink I would gladly help keep the API documentation Up-To-Date.
|
|
Author: | Nubs_Select | Posted: | May 12, 2023 17:03 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 29 times | Topic: | Technical Issues | |
|
| | Ok, I submitted a help desk request. It is the first time I ever have, because
the general reputation is that will not work.
|
they have massively improved the response time
https://www.bricklink.com/message.asp?ID=1407431
so you may be in luck
|
|
Author: | axaday | Posted: | May 12, 2023 17:01 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 24 times | Topic: | Technical Issues | |
|
| In Technical Issues, SylvainLS writes:
| In Technical Issues, axaday writes:
| In Technical Issues, axaday writes:
| I have an order 4 days old now that the customer cannot pay. They are new and
made 3 attempts. I suspect they didn't confirm at the end. But on my order
page, the payment is marked as recieved. In PayPal it shows voided 3 times.
I have order status set to pending and the dropdown for payment status shows
"None" as an option, but I cannot select it.
|
Can anyone help me sort this out?
|
Help Desk?
|
Ok, I submitted a help desk request. It is the first time I ever have, because
the general reputation is that will not work.
|
|
Author: | SylvainLS | Posted: | May 12, 2023 16:17 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 29 times | Topic: | Technical Issues | |
|
| In Technical Issues, axaday writes:
| In Technical Issues, axaday writes:
| I have an order 4 days old now that the customer cannot pay. They are new and
made 3 attempts. I suspect they didn't confirm at the end. But on my order
page, the payment is marked as recieved. In PayPal it shows voided 3 times.
I have order status set to pending and the dropdown for payment status shows
"None" as an option, but I cannot select it.
|
Can anyone help me sort this out?
|
Help Desk?
|
|
Author: | axaday | Posted: | May 12, 2023 16:15 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 30 times | Topic: | Technical Issues | |
|
| In Technical Issues, axaday writes:
| I have an order 4 days old now that the customer cannot pay. They are new and
made 3 attempts. I suspect they didn't confirm at the end. But on my order
page, the payment is marked as recieved. In PayPal it shows voided 3 times.
I have order status set to pending and the dropdown for payment status shows
"None" as an option, but I cannot select it.
|
Can anyone help me sort this out?
|
|
Author: | ErwinNL | Posted: | May 12, 2023 14:46 | Subject: | Re: API Get Member Notes not working? | Viewed: | 28 times | Topic: | Technical Issues | |
|
| In Technical Issues, InanimateReason writes:
| In Technical Issues, macebobo writes:
| In Technical Issues, InanimateReason writes:
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
LOL. Not the first error I've found in the docs. Thanks for the quick response.
|
I've reported this, but no luck yet. There are more missing fields, incorrect
field types ed. Hopefully they get time someday to fix that.
|
|
Author: | InanimateReason | Posted: | May 12, 2023 10:55 | Subject: | Re: API Get Member Notes not working? | Viewed: | 27 times | Topic: | Technical Issues | |
|
| In Technical Issues, macebobo writes:
| I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
That worked perfectly. Thanks again!
|
|
Author: | billdad84 | Posted: | May 12, 2023 08:34 | Subject: | Re: Waiting for payment please do not refresh ... | Viewed: | 51 times | Topic: | Technical Issues | |
|
| I'm having the same issue. Did anyone find a fix?
In Technical Issues, kayteelee3 writes:
| In Technical Issues, dbost01 writes:
| When I click on an order I a page that says a "Payment in progress. Please do
not refresh page. It will automatically refresh....." It wont go away.
Help please.
|
Has this issue been resolved for you yet? I am getting that same message, & cannot
seem to figure it out, either. I have tried submitting 2 help forms, but neither
has been acknowledged. It's pretty difficult to see the orders with this
big notice taking over the page.
|
|
|
Author: | Peettoys | Posted: | May 12, 2023 06:02 | Subject: | Re: Error when trying to send an invoice manually | Viewed: | 46 times | Topic: | Technical Issues | |
|
| In Technical Issues, Stellar writes:
| In Technical Issues, jennnifer writes:
| In Technical Issues, Peettoys writes:
| Thanks for your reply! Regarding your questions;
- Payment methode: Paypal onsite,
- No links or email addresses,
- No Dutch Sales Tax (Only the UK VAT that will be collected by BL.
|
Have you tried reverting to the default invoice template? There may be an issue
with a macro tag.
~Jen
|
Before doing that be sure to save the original template!
If this doesn't finally work, head to the helpdesk, time to reply is pretty
quick nowadays as far as I know.
https://helpdesk.bricklink.com/Main/
|
Order has 102 lots, deleted all of them from the invoice and the problem was
"Solved".
Tested several more, with deleting the last 10, 20 and 30 lots.
With less or equal than 70 lots the problem was "solved".
So is it a treshold, or could there be something wrong with a lot "description"!?
|
|
Author: | InanimateReason | Posted: | May 11, 2023 21:33 | Subject: | Re: API Get Member Notes not working? | Viewed: | 20 times | Topic: | Technical Issues | |
|
| In Technical Issues, macebobo writes:
| In Technical Issues, InanimateReason writes:
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
LOL. Not the first error I've found in the docs. Thanks for the quick response.
|
|
Author: | macebobo | Posted: | May 11, 2023 21:11 | Subject: | Re: API Get Member Notes not working? | Viewed: | 34 times | Topic: | Technical Issues | |
|
| In Technical Issues, InanimateReason writes:
I have it working, the documentation is wrong it should be members/deaddrop/my_notes
Wherever the doc for the member sections says notes it should be my_notes on
all of the methods.
Good luck!
-- John
|
|
|
Author: | wildchicken13 | Posted: | May 11, 2023 10:00 | Subject: | Re: Order Hung Up, Cannot Change Payment Status | Viewed: | 37 times | Topic: | Technical Issues | |
|
| In Help, axaday writes:
| I have an order 4 days old now that the customer cannot pay. They are new and
made 3 attempts. I suspect they didn't confirm at the end. But on my order
page, the payment is marked as recieved. In PayPal it shows voided 3 times.
I have order status set to pending and the dropdown for payment status shows
"None" as an option, but I cannot select it.
|
Have you tried using Stripe?
|
Next Page: 5 More | 10 More | 25 More | 50 More | 100 More
|