The colours can be downloaded via the API, but I don't think there's any other download options available. You could select all the colours in that table and copy & paste them into Excel (although I've just realised that you don't get the BrickOwl colour ID when you do that).
Regarding the upload, I'm honestly not sure. I don't think the info is very clear at all. I've tried playing around with uploading XML's but I get errors each time. The schema's really need to be visible for the import types with tag names etc. so we know exactly what format the file should be in.
Just looking at a backup from my store, the colour gets attached to the end of the BOID e.g. 518532-38
I am also looking at the backup download, it seems color names are included in the description so perhaps when uploading they should be too in the description as well. I am using BL colors in my backend software so I am thinking about a conversion table to obtain the BO colors, but for that it would be nice to have a color download.
@BasKrie Thx! That works. The output is json, and with a converter I get XML. Nice! It contains the BL color names so with that I can create a conversion table to BO colors.
Depends on your programming skills! Your program needs to be able to download that list of colours and then you need a JSON parser to actually make sense of it. If you know a bit of programming, you could probably do it fairly easily. I've got some VBA code in an Excel spreadsheet to do it.
I wouldn't expect the colour to be part of the description on upload. Shouldn't even need a description at all as the BOID/Item ID will take care of that.
Next issue... The XML contains an invalid looping element. <root> <0> <id>0</id> ... </0> <2> <id>2</id>
The looping element is <0> <2> etc. where (I guess) it should be a fixed name like <color>. I am using PDI to read the XML but it cannot recognize elements.
So, why is the repeating element numbered? Maybe that is how it works within API/json?
Comments
Also, is there a list of colors (id, description) available?
https://www.brickowl.com/colors
Is it also available as download file? CSV, XML, Excel?
You could select all the colours in that table and copy & paste them into Excel (although I've just realised that you don't get the BrickOwl colour ID when you do that).
Regarding the upload, I'm honestly not sure. I don't think the info is very clear at all. I've tried playing around with uploading XML's but I get errors each time.
The schema's really need to be visible for the import types with tag names etc. so we know exactly what format the file should be in.
Just looking at a backup from my store, the colour gets attached to the end of the BOID e.g. 518532-38
GET https://api.brickowl.com/v1/catalog/color_list
But I have no idea how to execute it.
I am also looking at the backup download, it seems color names are included in the description so perhaps when uploading they should be too in the description as well.
I am using BL colors in my backend software so I am thinking about a conversion table to obtain the BO colors, but for that it would be nice to have a color download.
@Lawrence do you have a solution for this?
https://api.brickowl.com/v1/catalog/color_list?key=xxx
where xxx is your key.
Your program needs to be able to download that list of colours and then you need a JSON parser to actually make sense of it.
If you know a bit of programming, you could probably do it fairly easily. I've got some VBA code in an Excel spreadsheet to do it.
I wouldn't expect the colour to be part of the description on upload. Shouldn't even need a description at all as the BOID/Item ID will take care of that.
<root>
<0>
<id>0</id>
...
</0>
<2>
<id>2</id>
The looping element is <0> <2> etc. where (I guess) it should be a fixed name like <color>.
I am using PDI to read the XML but it cannot recognize elements.
So, why is the repeating element numbered? Maybe that is how it works within API/json?