`Im trying to read an nested api. The record nodes is nested in level 3, and I need a subvalue of to the parent.

`Im trying to read an nested api. The record nodes is nested in level 3, and I need a subvalue of to the parent.

`Im trying to read an nested api. The record nodes is nested in level 3, and I need a subvalue of to the parent.

`Im trying to read an nested api. The record nodes is nested in level 3, and I need a subvalue of to the parent.

I have a JSON file called “values.json” with this content:

I have a json file which when converted into a dataframe looks something like this:

I have a json file with this structure:

I have an excel file with a structure as the following:

I have a problem. I have a nested JSON file: