Update a specific key in JSON Array using PYTHON

Question

I have a JSON file which has some key-value pairs in Arrays. I need to update/replace the value for key id with a value stored in a variable called Var1

The problem is that when I run my python code, it adds the new key-value pair in outside the inner array instead of replacing:

PYTHON SCRIPT:

import json
import sys
var1=abcdefghi

with open('C:\\Projects\\scripts\\input.json', 'r+') as f:
    json_data = json.load(f)
    json_data['id'] = var1
    f.seek(0)
    f.write(json.dumps(json_data))
    f.truncate()

INPUT JSON:

{
    "channel": "AT",
    "username": "Maintenance",
    "attachments": [
      {
         "fallback":"[Urgent]:",
         "pretext":"[Urgent]:",
         "color":"#D04000",
         "fields":[
            {
               "title":"SERVERS:",
               "id":"popeye",
               "short":false
            }
         ]
      }
   ]
}

OUTPUT:

{
    "username": "Maintenance", 
    "attachments": [
        {
            "color": "#D04000", 
            "pretext": "[Urgent]:", 
            "fallback": "[Urgent]:", 
            "fields": [
                {
                    "short": false, 
                    "id": "popeye", 
                    "title": "SERVERS:"
                }
            ]
        }
    ], 
    "channel": "AT", 
    "id": "abcdefghi"
}

akash karothiya · Accepted Answer · 2017-11-17 11:56:07Z

4

Below will update the id inside fields :

json_data['attachments'][0]['fields'][0]['id'] = var1

answered Nov 17, 2017 at 11:56

akash karothiya

5,9601 gold badge21 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

akash karothiya Over a year ago

@AswaryTiwari Welcome, you can check stackoverflow.com/help/someone-answers

Buzzkillionair · Accepted Answer · 2023-02-24 16:56:50Z

To add to the earlier answer from akash, here is a way that you can make these changes in the event that you have multiple fields that contain ids that you want to change to this same variable. I know this likely wouldn't apply here (given that it is an id), but could be used as a broad example for when you want to set all values to the same value in a similar type of question. For example, if you wanted to set the id number for many fields to be unique, you could set var1 = 1 and then each time the for k in json_data loops, you increase the value of var1 by 1. This is not the example I have below, the example below would be to change all the Fields so they all have the same ID value.

Further adjustments can be made if you had multiple attachments as well (could not just use [attachments][0] as it'd only apply to the fields within the first attachment).

I just figured this knowledge could be good for someone to have at some point.

INPUT JSON

{
  "channel": "AT",
  "username": "Maintenance",
  "attachments": [
    {
      "fallback": "[Urgent]:",
      "pretext": "[Urgent]:",
      "color": "#D04000",
      "fields": [
        {
          "title": "SERVERS:",
          "id": "popeye",
          "short": false
        },
        {
          "title": "DUMMYDATA:",
          "id": "DORRIS",
          "short": false
        }
      ]
    }
  ]
}

CODE

var1 = 'abcdefghi'
json_file = "Some/file/path"
with open(json_file, 'r+') as f:
    json_data = json.load(f)
    for k in json_data['attachments'][0]['fields']:
        k['id'] = var1
    f.seek(0)
    f.write(json.dumps(json_data, indent=2))
    f.truncate()

OUTPUT

{
  "channel": "AT",
  "username": "Maintenance",
  "attachments": [
    {
      "fallback": "[Urgent]:",
      "pretext": "[Urgent]:",
      "color": "#D04000",
      "fields": [
        {
          "title": "SERVERS:",
          "id": "abcdefghi",
          "short": false
        },
        {
          "title": "DUMMYDATA:",
          "id": "abcdefghi",
          "short": false
        }
      ]
    }
  ]
}

I hope that this is useful to some extent.

Collectives™ on Stack Overflow

Update a specific key in JSON Array using PYTHON

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related