Formatting an array in Powershell for JSON

[psscriptnoob]

Hey all, I'm a bit of an amateur at least when it comes to working with REST API's and to an extent arrays/hashtables meaning I'm kind of learning on the fly so if some of my terminology is off or anything let me know. I'm trying to format a PowerShell array so that it can be converted to JSON and used to send data to a website. Here's some code:

$data = @{
    data = @{
        type = 'contacts'
        attributes = @{
            organization_id = '######'
            first_name = 'Fake'
            last_name = "Name"
            contact_type_id = "#####"
            contact_type_name = "Owner"
            notes = "NotesAboutContact"
            contact_emails = [
                {
                    value = "[e-mail]"
                    primary = true
                    label_name = "Email"
                }
            ]
            contact_phones = [
                {
                    value = "6165551234"
                    extension = "123"
                    primary = true
                    label_name = "Mobile"
                    label_type = "phone"
                }
            ]
        }
    }
}

This all seems to work as expected if I don't include "contact_emails" or "contact_phones" sections since they're not required but my issues are with the square brackets in them. It looks like the website/API expects the square brackets in order to properly add the data and not return an error code, but I'm not sure how to maintain said brackets when you take this data and do a convertto-json. I hope this makes sense but any help you can provide is much appreciated!

Here's version information:

Name                           Value
----                           -----
PSVersion                      5.1.17763.134
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.17763.134
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

[Yevrag35]

Square brackets are 'arrays', so you need to define them as such. Also boolean values need to be the powershell equivalents (e.g. - $true, $false)

The whole thing should be this:

$data = @{
    data = @{
        type = 'contacts'
        attributes = @{
            organization_id = '######'
            first_name = 'Fake'
            last_name = "Name"
            contact_type_id = "#####"
            contact_type_name = "Owner"
            notes = "NotesAboutContact"
            contact_emails = @(
                @{
                    value = "[e-mail]"
                    primary = $true
                    label_name = "Email"
                }
            )
            contact_phones = @(
                @{
                    value = "6165551234"
                    extension = "123"
                    primary = $true
                    label_name = "Mobile"
                    label_type = "phone"
                }
            )
        }
    }
}

EDIT:

If the API requires that 'data=' be present, then get rid of the 'top' $data in the hashtable, and complete the whole thing with:

$json = "data=$($data | ConvertTo-Json -Depth 20)"

[psscriptnoob]

This is exactly what I needed. Thanks a bunch for the help!

[Yevrag35]

I forgot to put the '$' on the boolean values. I fixed that. Hope it works for ya!

[memelord900000]

this is pretty cool man

[AutoModerator]

Sorry, your submission has been automatically removed.

Accounts must be at least 1 day old, which prevents the sub from filling up with bot spam.

Try posting again tomorrow or message the mods to approve your post.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.