View Revisions: Issue #6872

All RevisionsBack to Issue
Summary 0006872: Add a JSON transform type
Revision 2025-05-07 12:16 by emiller
Description Add a JSON transform type which converts the entire row to JSON format. Depending on the transform_expression, it should be in one of three formats. Below are examples of the three formats:

Row for table:
"id","name","state","time"
"customer001","John","inactive","2025-01-01 02:03:04"

1. No header:
{
    "id":"customer001",
    "name":"John",
    "state":"inactive",
    "time":"2025-01-01 02:03:04"
}

2. Customizable data header:
{
    "payload":{
        "id":"customer001",
        "name":"John",
        "state":"inactive",
        "time":"2025-01-01 02:03:04"
    }
}

3. Customizable ID and data header:
{
    "_id":"customer001",
    "data":{
        "id":"customer001",
        "name":"John",
        "state":"inactive",
        "time":"2025-01-01 02:03:04"
    }
}
Revision 2025-05-06 18:03 by emiller
Description Add a JSON transform type which converts the entire row to JSON format. Depending on the transform_expression, it should either create a flat JSON file with one field per column or use an ID as the root.