Creating a JSON string, PowerShell object

Question

I am unable to create a variable on this request so I can later convert the variable to JSON using converttojson

{
    "update": {
        "comment": [
            {
                "add": {
                    "body": "Comment added when resolving issue"
                }
            }
        ]
    },

    "transition": {
        "id": "21"
    }
}

Tried the below

$jsonRequest = @{
    update= @{
        comment =@{
           add =@{
               body = "$Description"
            }
        }

    }
    transition =@{
        id = $TransactionID
    }
}

But get an output as below

{
    "transition":  {
                       "id":  1
                   },
    "update":  {
                   "comment":  {
                                   "add":  "System.Collections.Hashtable"
                               }
               }
}

How do I make it a list containing hashtable?

Sudheej
– Sudheej

2017-06-16 20:14:56 +00:00
Commented Jun 16, 2017 at 20:14 — Sudheej
– Sudheej, Commented Jun 16, 2017 at 20:14

TessellatingHeckler · Accepted Answer · 2017-06-16 20:17:51Z

27

Comment" in your JSON is a list containing a hashtable, in your code it's a hashtable containing a hashtable.

This looks right by making it an array of one item:

$jsonRequest = [ordered]@{
    update= @{
        comment = @(
            @{
               add =@{
                   body = "$Description"
                }
            }
        )
    }
    transition = @{
        id = 21
    }
}

$jsonRequest | ConvertTo-Json -Depth 10

And I've made it '[ordered]' so the update and transition come out in the same order as your code, although that shouldn't really matter.

answered Jun 16, 2017 at 20:17

TessellatingHeckler

29.3k4 gold badges55 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sudheej Over a year ago

Thank you.. saved the day.

scrthq Over a year ago

To clarify as well since I didn't see it mentioned; in your original output, it looks like you were using ConvertTo-Json without the -Depth parameter, which is why the add attribute just showed the type ("add": "System.Collections.Hashtable") when it went that deep (the default -Depth value is 2 & max is 100).

Collectives™ on Stack Overflow

Creating a JSON string, PowerShell object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related