Powershell 7 JSON handling

Robert Hadfield · #1 10-29-2020, 01:43 AM

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:

Code:

$myproduct = ConvertFrom-Json (invoke-webrequest -uri https://app.ecwid.com/api/v3/xxxxxxxx/products/xxxxxxx?token=secret_xxxxxxxxxx).Content

I can update an attribute:

Code:

$myproduct.name = "Test Product 1.3"

I can convert it back to JSON:

Code:

$myJSON = ConvertTo-Json $myproduct -compress

But it fails on update:

Code:

$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:

Quote:

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:

Code:

"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"}]}

to the Converted:

Code:

"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.

Robert Hadfield · #2 10-29-2020, 03:25 AM

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.

Code:

$myJSON = ConvertTo-Json $myproduct -compress -Depth 3

Wondering then, how deep do other Ecwid JSON objects go?