Old 10-29-2020, 01:43 AM
Robert Hadfield's Avatar
Robert Hadfield is offline
Join Date: Oct 2020
Posts: 2

Powershell 7 JSON handling

Trying to update a product using powershell 7

I can get the product and convert it from JSON into an object in PS that I can work with:

$myproduct = ConvertFrom-Json (invoke-webrequest -uri https://app.ecwid.com/api/v3/xxxxxxxx/products/xxxxxxx?token=secret_xxxxxxxxxx).Content
I can update an attribute:
$myproduct.name = "Test Product 1.3"
I can convert it back to JSON:
$myJSON = ConvertTo-Json $myproduct -compress
But it fails on update:
$myJSON | Invoke-WebRequest -uri https://app.ecwid.com/api/v3/xxxxxx/products/xxxxxx?token=secret_xxxxxxxx -method PUT -ContentType 'application/json'
With the following message:
InvalidOperation: The regular expression pattern media":{"images":["@{ is not valid.
The conversion of the media object one way or the other is messed up.

Comparing the Original:
to the Converted:
"media":{"images":["@{id=0; isMain=True; orderBy=0; image160pxUrl=https://d2j6dbq0eux0bg.cloudfront.net/images/36906115/1729548913.jpg; image400pxUrl=https://d2j6dbq0eux0bg.cloudfront.net/images/36906115/1729548916.jpg; image800pxUrl=https://d2j6dbq0eux0bg.cloudfront.net/images/36906115/1729548915.jpg; image1500pxUrl=https://d2j6dbq0eux0bg.cloudfront.net/images/36906115/1729548914.jpg; imageOriginalUrl=https://d2j6dbq0eux0bg.cloudfront.net/images/36906115/1729548912.jpg}"]}
You can see how different it is.

So I am trying to work out how to get around this.
Old 10-29-2020, 03:25 AM
Robert Hadfield's Avatar
Robert Hadfield Robert Hadfield is offline
Join Date: Oct 2020
Posts: 2

Funny how you can spend days on something & then work it out hours after posting on a forum.
ConvertFrom-Json has a default depth of 1024
ConvertTo-Json has a default depth of only 2!
Adding -Depth 3 to the end of my ConvertTo-Json command has fixed my problem.

$myJSON = ConvertTo-Json $myproduct -compress -Depth 3
Wondering then, how deep do other Ecwid JSON objects go?

Last edited by Robert Hadfield; 10-29-2020 at 03:29 AM.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 01:47 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.