Data type JSON to JSONB

[Pragadeshgp]

Dear Knimers,

Please need you help to get a node or workflow to convet a data from Data type ‘JSON’ to Datatype ‘JSONB’

ERROR DB Writer 3:107 Execute failed: Output type mapping is missing for column:
XXXXXXX (JSON)

Input type is (JSON)
Output type is (JSONB)

Thank you

[dzhanhir]

Hi @Pragadeshgp,

Thanks for contacting us!

Kindly note that jsonb is one of two PostgreSQL types for storing JSON data.

As JSONB isn’t something common, we don’t have a default mapping available.

Anyway, it can be converted into a JsonCell.

Best,
Dzhanhir