<div>
Must be valid JSON to start.<br />
<br />
Nested JSON works, so long as the JSON validates.<br />
<br />
<a href="https://jsonformatter.org/" rel="ugc"><u>https://jsonformatter.org</u>/</a> is a great validator tool which also formats JSON into human readable form.<br />
<br />
Reformat your JSON to pass validation + likely all will work well.<br />
<br />
Tip: Be sure to check the return result of json.loads() + bail out with an error in your code, to know if the JSON parse has succeeded.
</div>


<div>
@David thank's for the pointer to the validator, I am able to output the elements shown in the script attached, it's the nested elements, that I am not sure how-to do this in python, and ideas ?
</div>


<div>
The main issue as has been stated is the JSON is NOT a JSON. It is a good attempt to be one but not quite. This particular Json has a lot of issues starting on line 3.<br />
&quot;nonPersonalizedCardLine3&quot;<wbr /> : <br />
Error: Parse error on line 3:<br />
...nalizedCardLine3&quot; : ValuedCustomer,&quot;pro<br />
-----------------------^<br />
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['<br />
ValuedCustomer,<br />
<br />
What that means is the text ValuedCustomer needs to be double quoted: &nbsp;&quot;ValuedCustomer&quot;,<br />
<br />
To be valid all values should be one of the following:<br />
<br />
STRING, NUMBER, NULL, true, false, { or [<br />
<br />
Once you go ahead and fix up the example file to be a proper Json then parsing it will be super easy!
</div>


Fractional CTO

David Favor

<div>
Mark... restated my point better than I did... <b>&quot;The main issue as has been stated is the JSON is NOT a JSON.&quot;</b><br />
<br />
Your JSON must be JSON (validates clean) before your JSON will parse.<br />
<br />
You said, <b>&quot;it's the nested elements, that I am not sure how-to do this in python, and ideas?&quot;</b><br />
<br />
Yes. Simple.<br />
<br />
1) First you can't fix this... ever... any way... in your parser.py script... well... unless you write some hand rolled (custom) JSON parser which attempts to fix broken JSON.<br />
<br />
You'll take this option if you're independently wealthy - unlimited time + money.<br />
<br />
2) Better to fix this in the code generating the JSON.<br />
<br />
3) To fix your JSON code generator, first output the output the outer block of your JSON (no nested elements) + ensure your JSON validates, then do the same for every individual JSON element, then merge the both outer block + nested element generation + you should be good.
</div>


<div>
I have uploaded a valid json, my question is still the same... how to parse the nested elements. Thanks!!!
</div>


<div>
Can you make the new valid JSON available to us? In order to give you an example of how to parse it we need to see what we are working with.<br />
Looking at the original JSON posted in this question the key of &quot;productLocale&quot; has a value which is a list of objects - or a list of dicts when it is json.loads(). To iter through each key =&gt; value in the nested objects:<br />
<br />
for key, val in obj['productLocale'].iter(<wbr />):<br />
&nbsp; &nbsp; print('{KEY} =&gt; {VAL}'.format(KEY = key, VAL = val)<br />
<br />
If you are not sure if the values are objects themselves you could do an isinstance check on each value before parsing it. If it is an instance of a dict or list then you know to iter the values. If not then that the values like a string (or whatever type of data is in there).<br />
<br />
If you post the fixed json and tell us exactly what you expect to get out of it or your purpose for reading the data then we can help further.
</div>


<div>
You said, <b>&quot;I have uploaded a valid json, my question is still the same... how to parse the nested elements. Thanks!!!&quot;</b><br />
<br />
Once your JSON is valid, then your parser.py file will work as it's written, so valid JSON will parse correctly.<br />
<br />
Maybe what you're asking is how you access these elements in your parsed data.<br />
<br />
If this is what you're asking, then refer to Mark's comment.<br />
<br />
Sometimes the easiest way to figure this out is to run your data through JSFormatter above. Once you have pretty (human readable) output, you can work out your exact parsing based on Mark's comment.
</div>


<div>
@Mark, Using this version of the script, I pasted output. <br />
========================<br />

<pre><code class="code-1 nolinks" id="code-20-42836244-1"><span>import json</span>
<span>obj = json.loads(open('./file.json').read())</span>
<span>print(&quot;stopApprovalInd: &quot; + str(obj['stopApprovalInd']))</span>
<span>print(&quot;creatorId: &quot; + str(obj['creatorId']))</span>
<span>print(&quot;productBarcodes: &quot; + str(obj['productBarcodes']))</span>
<span>print(&quot;\n&quot;)</span>
</code></pre>
<br />
stopApprovalInd: True<br />
creatorId: PDM4PDZ0PDNQBGWMVGMRVTK9DM<wbr /><br />
productBarcodes: [{u'<b>barcodeType</b>': u'3D-CA128'}]<br />
<br />
If I just want to output <b>barcodeType</b>, how do I resolve to just that ?<br />
<br />
thanks again!!!<br />
<br />
Martin
</div>


<div>
Best to post a copy of your valid JSON + likely someone can give you the exact syntax required to access data you're after.
</div>


<div>
I updated the attached json file &nbsp;2 days ago. it is valid, looking for an expert on the extract of elements that are embedded. These don't seem to fit as an item in an array to iter() on. &nbsp;<br />
<br />
Repeat the simple case here.<br />

<pre><code class="code-1 nolinks" id="code-20-42836779-1"><span>productBarcodes: [{u'barcodeType': u'3D-CA128'}]</span>
</code></pre>
<br />
If I just want to output barcodeType, how do I resolve to just that ? <br />
<br />
Thanks!
</div>


Martin Miller

<div>
Thanks Mark, Very much appreciated!
</div>


<div>
<div class="content wysiwyg-content">
Parsing nested json. I am looking for help to parsing the nested json elements.<br />
<br />
I attached a json file I need to output all of the data fields, however some are nested and I don't know the HOW-TO output the nested values. Can you help ?<br />
<br />
I also include the start a python script<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w14/1416679/parser.py" target="_blank" class="file-inline" title="start of my python script to output json elements (247 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>parser.py</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w14/1416680/file.json" target="_blank" class="file-inline" title="json file with nested elements (4 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>file.json</a>
</div>
</div>


start of my python script to output json elements

parser.py

file.json

Parsing nested json. I am looking for help to parsing the nested json elements.

I attached a json file I need to output all of the data fields, however some are nested and I don't know the HOW-TO output the nested values. Can you help ?

I also include the start a python script

Parsing nested json

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.

Python

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.