Data type JSON to JSONB

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:

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

Thank you

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.


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.