How to replace text in json using bash

Question

I am trying to replace qa_test_services by test_services using bash in JSON file, could someone please help me with this ? thanks

JSON file - variables.json

{
    "variable": {
        "qa_test_services": {
            "default": {
                "prod-test-1": {
                    "position": 0,
                    "service_name": "test-1-service"
                },
                "prod-test-2": {
                    "position": 1,
                    "service_name": "test-2-service"
                }
            }
        }
    }
}

bash - script

test_json="variables.json"
actual_text="qa_test_services"
replace_text="test_services"

SEARCH_LINE=`cat $test_json | grep $actual_text | sed 's/"//g' | sed 's/://g' | sed 's/{//g' | sed -e 's/  */ /g'`
echo $SEARCH_LINE

See also [useless use of `cat`](https://stackoverflow.com/questions/11710552/useless-use-of-cat), [useless use of `grep`](http://www.iki.fi/era/unix/award.html#grep), and [Combining two `sed` commands](https://stackoverflow.com/questions/7657647/combining-two-sed-commands) — tripleee, Jul 20 '21 at 11:27

Cole Tierney · Answer 1 · 2021-07-20T15:42:43.973

I would avoid the temptation to edit json with line oriented tools. Like xml, It will not always be nicely formatted. Try using jq; it's like sed for json.

jq -f filter.jq variables.json

filter.jq

.variable |= with_entries(
    if .key == "qa_test_services" then
        .key = "test_services"
    else
        .
    end)

output

{
  "variable": {
    "test_services": {
      "default": {
        "prod-test-1": {
          "position": 0,
          "service_name": "test-1-service"
        },
        "prod-test-2": {
          "position": 1,
          "service_name": "test-2-service"
        }
      }
    }
  }
}

using bash variables

jq ".variable |= with_entries(
    if .key == \"$actual_text\" then
        .key = \"$replace_text\"
    else
        .
    end)" $test_json

Rather than 'nicely', I would say 'correctly formatted and escaped'! +1 — Brian Agnew, Jul 20 '21 at 14:21

score 1 · Answer 2 · answered Jul 20 '21 at 11:22

If the string you want to replace is exactly that, you could just use this simple sed command:

$ sed 's/qa_test_services/test_services/' variables.json
{
  "variable": {
    "test_services": {
      "default": {
        "prod-test-1": {
          "position": 0,
          "service_name": "test-1-service"
        },
        "prod-test-2": {
          "position": 1,
          "service_name": "test-2-service"
        }
      }
    }
  }
}

If you're happy with the result you can either pipe the output to a different file:

sed 's/qa_test_services/test_services/' variables.json > replaced.json

Or instruct sed to modify the file in-place:

sed -i .backup 's/qa_test_services/test_services/' variables.json

Where .backup is the extension that sed should use for the backup file it creates.

This works locally but fails if I try in azure devops pipeline — Ketan Bijwe, Jul 20 '21 at 12:23

score 0 · Answer 3 · answered Nov 19 '22 at 16:32

0

This is another example using escape chars as I needed this, thought it would help someone else!

sed 's/\/sounds/\/apps\/soundboard\/sounds/' soundboard.json > test_json_new

answered Nov 19 '22 at 16:32

Jay Mee

55
1
11

How to replace text in json using bash

3 Answers3

Linked

Related