Extracting Json Value from path python

Question

I have a sample Json which contains key as fileName and value as filepath. For example:

{
  "sqlFiles":{
    "sqlQueryPath": "tmp/r/test.sql"
  },
  "csvFiles": {
    "firstSampleInput": "tmp/c/sample.csv",
    "secondSampleInput": "tmp/c/sample1.csv"
  }
}

and I have a function which takes key as input and return value as output. Something like this:

def readFilePath(key):
    with open('filePaths.json', 'r') as f:
        config = json.load(f)
        value = config[key]
        return value

If the key is available as a root element then my functions totally works but if the key is available in nested format just like it is available in the json then my function will fail.

I will call the function with the json path something like this:

readFilePath("sqlFiles.sqlQueryPath")

What changes to be made in the function that it parse the path in the format config["sqlFiles"]["sqlQueryPath"]

You have iterate thru JSON keys and inner keys:values to get the values of any given key. — Chandu
– Chandu, Commented Sep 24, 2018 at 11:11
Possible duplicate of How to use a dot "." to access members of dictionary? — Mike Scotty
– Mike Scotty, Commented Sep 24, 2018 at 11:19

Rakesh · Accepted Answer · 2018-09-24 11:14:49Z

5

This is one approach. Using a simple iteration.

Demo:

key = "sqlFiles.sqlQueryPath"

def readFilePath(key):
    config = {
          "sqlFiles":{
            "sqlQueryPath": "tmp/r/test.sql"
          },
          "csvFiles": {
            "firstSampleInput": "tmp/c/sample.csv",
            "secondSampleInput": "tmp/c/sample1.csv"
          }
        }

    for i in key.split("."):
        if i in config:
            config = config[i]
        else:
            return None


    return config

print(readFilePath(key))

answered Sep 24, 2018 at 11:14

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Comments

tomer.z · Accepted Answer · 2018-09-24 11:13:33Z

1

You need to split the key by '.' and read value iteratively, pesudo code:

for nestedKey in key.split('.'): value = value[nestedKey]

answered Sep 24, 2018 at 11:13

tomer.z

1,0831 gold badge11 silver badges27 bronze badges

Comments

Narendra Prasath · Accepted Answer · 2018-09-24 11:21:54Z

1

You could try this out,

def readFilePath(key):
with open('filePaths.json', 'r') as f:
    config = json.load(f)
    value = ""
    config_temp = config
    try:
        for k in key.split("."):
            config_temp = config_temp[k]
        value = config_temp
        return value
    except KeyError:
        return value

answered Sep 24, 2018 at 11:21

Narendra Prasath

1,5311 gold badge10 silver badges20 bronze badges

Comments

Ashish · Accepted Answer · 2018-09-24 11:15:57Z

0

You can try this by splitting the input and avoiding for loop with root key

def readFilePath(key):
    json_keys = key.split('.')
    with open('filePaths.json', 'r') as f:
        config = json.load(f)
        if len(json_keys) > 1:
            value = config[json_keys[0]][json_keys[1]]
        else:
            value = config[json_keys[0]]
        return value

answered Sep 24, 2018 at 11:15

Ashish

6434 silver badges10 bronze badges

Comments

rockikz · Accepted Answer · 2018-09-24 11:25:20Z

0

Here is a solution:

def readFilePath(key):
    with open("sample.json") as f:
        config = json.load(f)
        value = None
        for k in key.split("."):
            try:
                value = config[k]
            except KeyError:
                config = value
        return value[k]

answered Sep 24, 2018 at 11:25

rockikz

6461 gold badge8 silver badges18 bronze badges

Collectives™ on Stack Overflow

Extracting Json Value from path python

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related