Query and Transform JSON using JSONata
What Does This Article Cover?
- What is a JSONata?
- How to set it up?
- Configuration
- Example Video
- Other Related Material
What is a JSONata?
JSONata is a query and transformation language for JSON data sets. Instead of having to write JavaScript to query and transform the data, JSONata can be used instead. JSONata is similar to XSLTs used for XML and SQL used for databases to pull data from data sets and transform them that can get the data you need using single expression.
The JSONata stage was added in version 4.3. Please see Here
Configuration
Here is a download for the configuration used in this article. Download the configuration and import it into Intelligence Hub.
To use the JSONataNamespaceBuilder pipeline, the Token on the ProjectAPI connection needs to be updated to use a valid API key. See API Keys
In addition, here is the Postman Collection used to call the HighByte Data Server in this article.
Examples Video
Here is a video that shows various examples of how to use JSONata in HighByte Intelligence Hub. This video assumes that the jsonata and run-async libraries have been installed, and the Intelligence Hub has been restarted. The process of enabling and installing external libraries is covered in this Knowledge Base Article about generating UUIDs. The actual UUID library is not relevant to JSONata.