How do I parse nested JSON object?

Is there a good editor for editing lists of JSON objects in flat files?

  • I am wondering whether this would be a good solution for editing simple, but large typed data sets. My first desire is to be able to edit flat lists of JSON objects in an almost Excel-like datatable (an alternative to CSV, perhaps). Secondarily, it would be nice to be able to edit lists of nested JSON objects. My thinking is that this 'editor' should be able to operate on text files where there is one JSON encoded object per line, with no nested line breaks. Google BigQuery ingests files formatted in this way (https://developers.google.com/bigquery/preparing-data-for-bigquery#dataformats), except they support embedded newlines for JSON objects.

  • Answer:

    JSON Editor Online could be what you need (http://www.jsoneditoronline.org/) Ace is great too and works for large files: http://ace.c9.io/ Also, I'm playing around with different editors for an encoding similar to JSON called Space (http://spaceful.org/) that might be relevant.

Breck Yunits at Quora Visit the source

Was this solution helpful to you?

Other answers

Here you will find all the functionality you are looking for and the I like is to view images if json data has one. http://codebeautify.org/view/json with export and import form url or files..

Jimmi Prajapati

I usually use a combination of spark and pandas. Pandas mostly for the nicer data frame render. Spark reads json as a flat list of json objects by default. Trifacta is also a very good product for data cleaning. https://www.trifacta.com

William Teo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.