Can FlexMonster handle mapping a JSON or JSONB column/data element?

posted on January 11th, 2024

Answered

Bill Kaper asked on January 11, 2024

Hi,

We have a few columns in our data sets that are JSONB columns. Right now, we are manually decomposing the JSONB elements into individual string items for each element in the JSONB object. Is there a way we can map these in the mapping section of the report without first decomposing them in the source query?

Thanks,
Bill

1 answer

Public

Maksym Diachenko ⋅ Flexmonster ⋅ January 15, 2024

Hello, Bill!

Thank you for your question.
Please note that Flexmonster does not support parsing JSONB objects via mapping. Currently, the only option for loading JSONB in FDS is to convert the JSON data to columns inside the connection query.
Feel free to contact us if questions arise.

Best Regards,
Maksym

Changes to Flexmonster Software License Agreement

Can FlexMonster handle mapping a JSON or JSONB column/data element?

1 answer

Please login or Register to Submit Answer