JSON Tools

Overview

Given a huge JSON to process and store in the database, this plug-in avoids using a long string in the process model and improves performances and memory usage. The big JSON can then be stored in a document and the document passed to the plug-in through a process instance.

Key Features & Functionality

Smart Services:

  • Load JSON to a database
  • Cast a JSON Array document to CSV document

Functions:

  • Validate a JSON
  • Validate a JSON against a schema
  • Remap a JSON
  • Filter a within a JSON
Anonymous
Parents
  • I am trying to load a JSON file to a table. When I try loading a JSON that only contains a JSON array, everything works fine. However, when the JSON array is located inside another JSON, it fails (I am using the JsonPath parameter).

    FIRST .json:

    [

    {...},

    {...},

    ]

    SECOND .json:

    {"key1": {

    "key2": {""},

    "key3": [

    {...},

    {...},

    ]

    }

    }

    JSON PATHs USED:

    $.key1.key3

    $.key1.key3.*

    $.key1.key3[:]

    $.['key1'].['key3']

    Do anyone know how to use this parameter?

    Thank you!

Comment
  • I am trying to load a JSON file to a table. When I try loading a JSON that only contains a JSON array, everything works fine. However, when the JSON array is located inside another JSON, it fails (I am using the JsonPath parameter).

    FIRST .json:

    [

    {...},

    {...},

    ]

    SECOND .json:

    {"key1": {

    "key2": {""},

    "key3": [

    {...},

    {...},

    ]

    }

    }

    JSON PATHs USED:

    $.key1.key3

    $.key1.key3.*

    $.key1.key3[:]

    $.['key1'].['key3']

    Do anyone know how to use this parameter?

    Thank you!

Children
No Data