Hub
NodeNode / Manipulator

JSON Schema Validator

Structured Data JSON
Drag & drop
Like
Copy short link

Validates JSON values based on the specified schema v3 or v4 .

When the value do not satisfy the constraints of the schema, the node will fail with the error message and the row number or collect the errors in a new column.

It uses the fge/json-schema-validator implementation.

Node details

Input ports
  1. Type: Table
    table with JSON
    A table with JSON column to validate
Output ports
  1. Type: Table
    table with errors
    The table with the error messages column

Extension

The JSON Schema Validator node is part of this extension:

Related workflows & nodes

  1. Weather Update
    Takes in City + Country. Updates DB. Outputs Weather info.
    wkhan > Public > Weather DB Update
  2. Community Days REST Tutorial
    REST
    KNIME Community Days REST Tutorial Workflow
    wkhan > Community Days REST > Community Days REST Tutorial
  3. RESTful Workflow- Weather
    Follow along how to build this workflow on the KNIME Blog. Explores how we can build REST…
    wkhan > Public > REST_Example_Weather
  4. 01.1_Extract_WebService_data
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > solutions > Session_1_ETL_Processing_I > 01.1_Extract_WebService_data
  5. 01.2_Extract_S3_data&Blend
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > exercises > Session_1_ETL_Processing_I > 01.2_Extract_S3_data&Blend
  6. 02.1_Data_Anonymization
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > exercises > Session_2_ETL_Processing_II > 02.1_Data_Anonymization
  7. 01.2_Extract_S3_data&Blend
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > solutions > Session_1_ETL_Processing_I > 01.2_Extract_S3_data&Blend
  8. 02.1_Data_Anonymization
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > solutions > Session_2_ETL_Processing_II > 02.1_Data_Anonymization
  9. 02.2 Database update
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > exercises > Session_2_ETL_Processing_II > 02.2_Database_update
  10. 02.2 Database update
    Best practices Data engineer Data engineering
    +1
    The company has two branches: one in the United States and another one in Europe. New US …
    knime > Education > Courses > L4-DE Best Practices for Data Engineering > solutions > Session_2_ETL_Processing_II > 02.2_Database_update