Variation Error: "Value for was not a valid JSON string."

[david olick]

I'm getting a weird error when trying to update the variations of a listing with this JSON string:

[{"property_id":506, “value":"6"”, “price":"10.1915”, “is_available":1},{"property_id":506, “value":"8"”, “price":"11.0415”, “is_available":1},{"property_id":506, “value":"10"”, “price":"11.8915”, “is_available":1},{"property_id":506, “value":"12"”, “price":"12.7415”, “is_available":1},{"property_id":506, “value":"14"”, “price":"13.5915”, “is_available":1},{"property_id":506, “value":"16"”, “price":"14.4415”, “is_available":1}]

Here's what it looks better formatted:

[

{"property_id":506, “value":"6"”, “price":"10.1915”, “is_available":1},

{"property_id":506, “value":"8"”, “price":"11.0415”, “is_available":1},

{"property_id":506, “value":"10"”, “price":"11.8915”, “is_available":1},

{"property_id":506, “value":"12"”, “price":"12.7415”, “is_available":1},

{"property_id":506, “value":"14"”, “price":"13.5915”, “is_available":1},

{"property_id":506, “value":"16"”, “price":"14.4415”, “is_available":1}

]

I can't see anything wrong with the JSON.  Are you processing the &quote; before parsing the JSON string?

Here are some request UUID's:

OFgO8tv0vIE6uze-zKknv5JRaTBE

b5BCzoK6usiANIrhhP8EzB8xxGdA

XVGmEP_UFSaJVSPz9k8MS-za9vWU

[Support]

The message does not give you much to work on. It reads like the failed field was not injected into the message.

Taking a stab at it, the price field has 4 decimal places - is that the problem? Did you try removing the quote?

Kind Regards,

​yumiFUZE ​

Support Team

--
You received this message because you are subscribed to the Google Groups "Etsy API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to etsy-api-v2...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[david olick]

I have confirmed the problem was the &quote;

However, that's how the data was given to me by Etsy (you can see the listing here: https://www.etsy.com/listing/194297338/blueberry-patch-tutu-baby-tutu-toddler ).

Because this is someone else's listings I am dealing with, I need to be able to present their variations the way they want their variations to be presented.  This is a parsing bug on Etsy's side that really needs to get fixed.  Although 6" inches seems to be redundant, that doesn't mean a custom variation CANT support the quote sign via the API but the web interface can.

--

David Olick

Oriku Inc.

[david olick]

I did find out that if you replace " with \" it works.  However, the value doesn't get updated back to " when you query the listing again.  For example if it said 8", retrieving it would give 8".  You can update it to be 8\", but the next time you use the API to get the value of the variation it says 8\" instead of the original value 8".  I'm not sure if this will cause any problems for Etsy or any other API user.

I didn't notice that the github repository was removed until you pointed it out.  I was hoping to get more information about the problem I was having before adding an issue to it.  Can someone from Etsy look into this?

--

David Olick

Oriku Inc.

On Thu, Jan 14, 2016 at 6:53 PM, wrote:

Hi David, Glad to hear that you identified the problem. I will have a look at what you found. Have you worked out a way around the problem yet? Also is it me or has the Etsy API github repository vanished? I wanted to check there to see if this was problem mentioned, plus review other outstanding problems however I can't see it anymore. Helen

Kind Regards, ​yumiFUZE ​ Support Team

[Kush Goyal]

Still not solved. I had to replace " with empty string for the request to validate. Etsy team should really look into this.