We have a couple of standard JSON document which requires a property value to be updated based on the system they are moving to. So we started looking for an option which tool or scripting language can the best.
So, I looked to use Powershell. Here is an example of How a JSON document value can be updated.
This is how my JSON document content looks like
{ "ConnectionStrings": { "DefaultConnection": "Server=SGT-SQL-UAT-01;Database=MyDb1;User Id=TestUser;Password=TestPswd;MultipleActiveResultSets=true" }, "Logging": { "IncludeScopes": false, "LogLevel": { "Default": "Debug", "System": "Information", "Microsoft": "Information" } } }
Reading the JSON Document and updating the connection string values
[string] $file='G:\Dummy_Data\world_bank\connnection_string.json' If( Test-Path -Path $file) { $data=(Get-Content -Path $file -Raw)| ConvertFrom-Json $data.ConnectionStrings.DefaultConnection="Server=SGT-SQL-UAT-01;Database=MyDb1;User Id=TestUser;Password=TestPswd;MultipleActiveResultSets=true" $data | ConvertTo-Json | Set-Content $file }