I have below two arrays.

# My First request
$MyResultArray1 = Invoke-RestMethod -Uri "http://myhost/rest-api-1" -Method GET -ErrorAction 'Stop'

# My Second request
$MyResultArray2 = Invoke-RestMethod -Uri "http://myhost/rest-api-2" -Method GET -ErrorAction 'Stop'

Both the request returns the JSON Array something like Below.

#Array 1 - $MyResultArray1
{
  "values": [
    {
       "id": 1,
       "testType": "something1"
    },
    {
       "id": 2,
       "testType": "something2"
    },
    {
       "id": 3,
       "testType": "something3"
    }
  ]
}

#Array 2 - $MyResultArray2
{
  "values": [
    {
       "testId": 1,
       "testResult": "result1",
       "testMeta": {}
    },
    {
       "testId": 2,
       "testResult": "result2",
       "testMeta": {}
    },
    {
       "testId": 3,
       "testResult": "result3",
       "testMeta": {}
    }
  ]
}

I want to merge these JSON array based on the ID and generate the resulting array as below.

#Array 3 - $Result
{
  "result": [
    {
       "id": 1,                  <-- From Array#1
       "testType": "something1"  <-- From Array#1
       "testResult": "result1"   <-- From Array#2
    },
    {
       "id": 2,
       "testType": "something2"
       "testResult": "result2"
    },
    {
       "id": 3,
       "testType": "something3"
       "testResult": "result3"
    },
  ]
}

I want to match the testId with id and generate the resulting array. I want to search for the $MyResultArray2.testId in the $MyResultArray1 and add the new field "testResult" in $MyResultArray1.

I am very new to Powershell, I am not sure how it is done in Powershell.
I able to iterate array but not able to search and create new object.

CodePudding user response：

Here's some code that will do what you want, but returns in a new array. Let me know if it can't be in a new array. Also, this will work for JSON data where the IDs aren't consistent across the two arrays.

First you have to convert the data from JSON to a PS Object with Convert-FromJson. After that, it's really just looping through one of the arrays.

Since most of the data is coming from the first array, I'll loop through that array. I have to select $obj1.values because $obj1 is an object that has an array where $obj1.values is the array of values.

From there, you will use Where-Object to find a given iteration's corresponding value in the other array.

All of this data goes into a PS Custom Object that then gets pushed to an array for your answer.

# Array 1 - $MyResultArray1
$obj1 = '{
  "values": [
    {
       "id": 1,
       "testType": "something1"
    },
    {
       "id": 2,
       "testType": "something2"
    },
    {
       "id": 3,
       "testType": "something3"
    }
  ]
}' | ConvertFrom-Json

# Array 2 - $MyResultArray2
$obj2 = '{
  "values": [
    {
       "testId": 1,
       "testResult": "result1",
       "testMeta": {}
    },
    {
       "testId": 2,
       "testResult": "result2",
       "testMeta": {}
    },
    {
       "testId": 3,
       "testResult": "result3",
       "testMeta": {}
    }
  ]
}' | ConvertFrom-Json

$newArr = @()


foreach ($value in $obj1.values) {
    $newObj = [pscustomobject]@{
        id = $value.id
        testType = $value.testType
        testResult = ($obj2.values | Where-Object { $_.testId -eq $value.id }).testResult
    }

    $newArr  = $newObj
    #$value.testResult = $obj2.values | Where-Object { $_.testId -eq $value.id }
}

Write-Host $newArr
<#
    @{id=1; testType=something1; testResult=result1}
    @{id=2; testType=something2; testResult=result2} 
    @{id=3; testType=something3; testResult=result3}
#>

Hope this helps... Let me know if you need something more :)