Based on the customer feedback in the latest version of Advanced ETL Processor we have introduced support for JSON

What is JSON

JSON is short for JavaScript Object Notation. It is a way to store information in an organized, easy-to-access manner. In a nutshell, it gives us a human-readable collection of data that we can access in a really logical manner.

Benefits of using JSON

JSON is much more efficient than XML. It requires less network traffic processing power and memory to work with  

More Information
  1. JSON only has three simple types – strings, numbers and Booleans – and two complex types – arrays and objects.
  2. A string is a sequence of zero or more characters wrapped in quotes with backslash escapement, the same notation used in most programming languages.
  3. A number can be represented as an integer, real, or floating-point. JSON does not support octal or hex. It does not have values for NaN or Infinity. Numbers are not quoted.
  4. A JSON object is an unordered collection of key/value pairs. The keys are strings and the values are any of the JSON types. A colon separates the keys from the values, and a comma separates the pairs. The whole thing is wrapped in curly braces.
  5. The JSON array is an ordered collection of values separated by commas and enclosed in square brackets.
  6. The character encoding of JSON text is always Unicode. UTF-8 is the only encoding that makes sense on the wire, but UTF-16 and UTF-32 are also permitted.
  7. JSON has no version number. No revisions to the JSON grammar are anticipated.
  8. JSON has become the X in Ajax. It is now the preferred data format for Ajax applications. The most common way to use JSON is with XMLHttpRequest. Once a response text is obtained, it can quickly be converted into a JavaScript data structure and consumed by a program
  9. JSON's syntax is significantly simpler than XML, so parsing is more efficient.
  10. JSON doesn't have namespaces. Every object is a namespace: its set of keys is independent of all other objects, even exclusive of nesting. JSON uses context to avoid ambiguity, just as programming languages do.
  11. JSON has no validator. Being well-formed and valid is not the same as being correct and relevant. Ultimately, every application is responsible for validating its inputs.JSON Examples
JSON array
{
"Drinks": ["Water", "Beer", "Vine"]
}
JSON Objects
{ 
  "Patient": {
    "ID": 1,
    "Name": "Batman"
    "Age": 23,
    "friends": ["SpiderMan","IronMan"],
    "complaint": "Blured night vision"
   }
}
Advanced ETL Processor JSON Transformations

json transformation functions

Example

json transformation example

Visit JSON Wiki Page