JSON Grid View
JSON Grid View enables you to see the structure of the JSON document (JSON instance/schema or Avro schema) in a grid, to edit the document more easily in a grid, and to restructure blocks of structured text. This provides you with an overview and editing capability that is not always present in Text View, especially in the case of long and complexly structured documents. In the case of JSON documents, such complexity can occur in the form of arrays and objects being nested within other arrays and objects at multiple levels. For example, compare the JSON text listed below (as it would appear in Text View) and its representation in Grid View (as shown in the screenshot further below).
| Note: | Avro support is available in the Enterprise Edition only. |
{ "web-app": { "servlet": [ { "servlet-name": "altovaCDS", "servlet-class": "org.altova.cds.CDSServlet", "init-param": { "configGlossary:installationAt": "Philadelphia, PA", "configGlossary:adminEmail": "ksm@pobox.com", "configGlossary:poweredBy": "Altova", "configGlossary:poweredByIcon": "/images/altova.gif", "configGlossary:staticPath": "/content/static", "templateProcessorClass": "org.altova.WysiwygTemplate", "templateLoaderClass": "org.altova.FilesTemplateLoader", "templatePath": "templates", "templateOverridePath": "", "defaultListTemplate": "listTemplate.htm", "defaultFileTemplate": "articleTemplate.htm", "useJSP": false, "jspListTemplate": "listTemplate.jsp", "jspFileTemplate": "articleTemplate.jsp", "cachePackageTagsTrack": 200, "cachePackageTagsStore": 200, "cachePackageTagsRefresh": 60, "cacheTemplatesTrack": 100, "cacheTemplatesStore": 50, "cacheTemplatesRefresh": 15, "cachePagesTrack": 200, "cachePagesStore": 100, "cachePagesRefresh": 10, "cachePagesDirtyRead": 10, "searchEngineListTemplate": "forSearchEnginesList.htm", "searchEngineFileTemplate": "forSearchEngines.htm", "searchEngineRobotsDb": "WEB-INF/robots.db", "useDataStore": true, "dataStoreClass": "org.altova.SqlDataStore", "redirectionClass": "org.altova.SqlRedirection", "dataStoreName": "altova", "dataStoreDriver": "com.microsoft.jdbc.sqlserver.SQLServerDriver", "dataStoreUrl": "jdbc:microsoft:sqlserver://LOCALHOST:1433;DatabaseName=goon", "dataStoreUser": "sa", "dataStorePassword": "dataStoreTestQuery", "dataStoreTestQuery": "SET NOCOUNT ON;select test='test';", "dataStoreLogFile": "/usr/local/tomcat/logs/datastore.log", "dataStoreInitConns": 10, "dataStoreMaxConns": 100, "dataStoreConnUsageLimit": 100, "dataStoreLogLevel": "debug", "maxUrlLength": 500 } }, { "servlet-name": "altovaEmail", "servlet-class": "org.altova.cds.EmailServlet", "init-param": { "mailHost": "mail1", "mailHostOverride": "mail2" } }, { "servlet-name": "altovaAdmin", "servlet-class": "org.altova.cds.AdminServlet" }, { "servlet-name": "fileServlet", "servlet-class": "org.altova.cds.FileServlet" }, { "servlet-name": "altovaTools", "servlet-class": "org.altova.cms.AltovaToolsServlet", "init-param": { "templatePath": "toolstemplates/", "log": 1, "logLocation": "/usr/local/tomcat/logs/AltovaTools.log", "logMaxSize": "", "dataLog": 1, "dataLogLocation": "/usr/local/tomcat/logs/dataLog.log", "dataLogMaxSize": "", "removePageCache": "/content/admin/remove?cache=pages&id=", "removeTemplateCache": "/content/admin/remove?cache=templates&id=", "fileTransferFolder": "/usr/local/tomcat/webapps/content/fileTransferFolder", "lookInContext": 1, "adminGroupID": 4, "betaServer": true } } ], "servlet-mapping": { "altovaCDS": "/", "altovaEmail": "/altovautil/aemail/*", "altovaAdmin": "/admin/*", "fileServlet": "/static/*", "altovaTools": "/tools/*" }, "taglib": { "taglib-uri": "altova.tld", "taglib-location": "/WEB-INF/tlds/altova.tld" } } }
|
While the document structure in Text View (listing above) is difficult to discern without a longer, more careful reading, the structure in Grid View (screenshot below) is more readily seen at a glance.
Additionally, the structure can be easily modified by adding, deleting, or moving objects in the grid. Entire blocks of text can be reorganized (for example, by sorting them or moving them). Content, too, can be edited easily in Grid View, this being made even easier with the availability of in-cell commands in individual cells.
Grid View toolbar
Commands related to editing in Grid View can be accessed quickly via the Grid View toolbar (screenshot below)—which is located in the toolbars area at the top of the application window. Hover over a toolbar icon to see its name and shortcut.
| Note: | These commands are also available in the JSON menu. |
In this section
This section is organized into the topics listed below. These descriptions explain features that are specific to JSON Grid View.
•How the JSON document is displayed in JSON Grid View