Importing and Parsing JSON and XML files into Omniscope

Modified on Mon, 17 Apr 2023 at 12:22 PM

Omniscope is capable of handling and importing JSON and XML data in several ways - multiple workflow blocks can split nested JSON objects into separate columns, or similarly extract XML data and allow the user to visually explore and filter the data.

In Omniscope project workflow - add the File block, then specify the URL of the JSON or XML data source, alternatively you can browse and navigate to the file location. Omniscope will automatically detect the schema and offer data preview of the original format (see the window on the right), field mappings and choice of record path options to choose from.  The preview table below is reflecting the choice and showing the result in a tabular format. 

This data is now ready to be blended with other data sources in Omniscope workflow and be visualised or saved/ exported to other data formats.

This is an example of XML file import:

Further to this - Omniscope has multiple blocks that can handle JSON and XML formats.

The Parse Text block in the Preparation section will parse the contents of a text field and output the records resulting for each cell.

A typical use case for this block is to parse the output of a Batch HTTP block e.g. a REST API endpoint returning structured data encoded as JSON object. 

(We can use the Batch Http block to invoke the REST API endpoint multiple times, based on a set of parameters)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article