Eliminate item from collection of objects in Json using Powershell

Question

Eliminate item from collection of objects in Json using Powershell

I have a scenario where I am importing JSON data into Powershell to update certain values, but I also need to remove specific objects from the imported data.

Here is my import code:

$fileJson = Get-Content -path/Template.json  -Encoding UTF8

In the JSON data, there is an array of objects structured like this:

{
 "resources": [
   {
     "name": "name1"
     "type": "type1"
     "....": "....."
   }, 
   {
     "name": "name2"
     "type": "type2"
     "....": "....."
   },
   {
     "name": "name3"
     "type": "type1"
     "....": "....."
   }
 ]
}

I need to be able to remove a specific object from this array based on a condition. For example, I want to remove the object where "type" equals "type2".

So far, I have tried using .Replace method but it only allows me to replace individual values and not entire objects. Is there a way to delete or skip an entire object based on a condition?

json powershell

Answer 1

Answer №1

Transform the JSON into a personalized object:

$jsonData = Get-Content -path/Template.json  -Encoding UTF8
$customObject = $jsonData |ConvertFrom-Json

Utilize Where-Object to refine the resources array:

$customObject.resources = @($customObject.resources |Where-Object type -ne type2)

Revert the modified object back to JSON format and save it to disk:

$customObject |ConvertTo-Json |Set-Content ./path/to/updatedTemplate.json -Encoding UTF8

Answer 2

Transform the JSON into a personalized object:

$jsonData = Get-Content -path/Template.json  -Encoding UTF8
$customObject = $jsonData |ConvertFrom-Json

Utilize Where-Object to refine the resources array:

$customObject.resources = @($customObject.resources |Where-Object type -ne type2)

Revert the modified object back to JSON format and save it to disk:

$customObject |ConvertTo-Json |Set-Content ./path/to/updatedTemplate.json -Encoding UTF8

Answer 3

Answer №2

One approach is to transform json data into PowerShell objects, apply the necessary modifications, and then convert it back to json format if required.

Here's an illustration:

$data = Get-Content -Path "C:\input.json" | ConvertFrom-Json
$data.items = $data.items | where category -eq 'category1'
$data | ConvertTo-Json -Depth 4 | Out-File "C:\output.json"

Answer 4

One approach is to transform json data into PowerShell objects, apply the necessary modifications, and then convert it back to json format if required.

Here's an illustration:

$data = Get-Content -Path "C:\input.json" | ConvertFrom-Json
$data.items = $data.items | where category -eq 'category1'
$data | ConvertTo-Json -Depth 4 | Out-File "C:\output.json"

Eliminate item from collection of objects in Json using Powershell

Answer №1

Answer №2

Similar questions

Problem: Values are not being posted with AJAX when using $(form).serialize()

Connecting Alamofire calls using Swift and PromiseKit

Utilizing NodeJS to Extract Data from MongoDB and Export to JSON File

How to Send and Receive Data in One Request Using Android Studio and Web API

Integrating List<class> into class xxx with JSON format

Working with JSON data in Java and displaying it in a user interface

Error in decoding JSON while creating an index in Azure Search

ìdentifying Incomplete JSON Data using Python

Split a column containing JSON stored as a string into individual rows and columns

Is it possible for Python JSON to encode/decode functions from text files?

Unexpected JSON token error occurs in jQuery when valid input is provided

Transforming AWS CLI DynamoDB JSON output into standard JSON format

Managing JSON object with irregular data in Angular 7: Best Practices

reversed json using javascript

Grails - JSONBuilder - Specification for toPrettyString() results in a stack overflow exception

Guide on accessing a nested array within a JSON object using JavaScript

Best practices for sending an object from client to server using Node.js

The controller is unable to accept JSON data from the JQuery.ajax function

What is the best way to retrieve and manipulate JSON data using Python?

Utilize Node.js to parse JSON data and append new nodes to the final output