[D] what’s the scope of the JSON type in Hop? (hop)

["S3tuit (via GitHub)" <gi...@apache.org>]

GitHub user S3tuit created a discussion: what’s the scope of the JSON type in Hop?

This might seem a naive question, but while drafting docs for the JSON datatype I tried it end-to-end and I can't get it to work.

- Mongo Output: setMongoValueFromHopValue(...) doesn’t appear to handle TYPE_JSON, so I can’t write a Hop JSON value as a BSON document.
- PostgreSQL: ValueMetaJson doesn’t override setPreparedStatementValue(...), so I can’t write to json/jsonb columns (it ends up as plain text).
- Reads: reading JSON from Mongo comes in as String, which I can convert to JSON with Select Values—that part works.

So I’m not sure if JSON is meant to be an in-memory/helper type only (not for writes to dbs yet), or this is an incomplete implementation and we should add it. I can also share the two transforms with you (write to mongo and Postgres). thanks in advance for your time

GitHub link: https://github.com/apache/hop/discussions/5753

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] what’s the scope of the JSON type in Hop? (hop)

["hansva (via GitHub)" <gi...@apache.org>]

GitHub user hansva added a comment to the discussion: what’s the scope of the JSON type in Hop?

It's an incomplete implementation, it was first added for pub/sub I think? Or at least one of the message brokers. But except for that one location it isn't implemented anywhere else. Even the JSON transforms do not handle the JSON datatype. So it could be a nice field of improvement for other transforms to gracefully handle the datatype 

GitHub link: https://github.com/apache/hop/discussions/5753#discussioncomment-14557054

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] what’s the scope of the JSON type in Hop? (hop)

["S3tuit (via GitHub)" <gi...@apache.org>]

GitHub user S3tuit added a comment to the discussion: what’s the scope of the JSON type in Hop?

okk tnx, in this case I'm gonna open an issue to gracefully handle JSON type in the current transforms 

GitHub link: https://github.com/apache/hop/discussions/5753#discussioncomment-14560020

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org

Re: [D] what’s the scope of the JSON type in Hop? (hop)

["hansva (via GitHub)" <gi...@apache.org>]

GitHub user hansva edited a comment on the discussion: what’s the scope of the JSON type in Hop?

It's an incomplete implementation, it was first added for pub/sub I think? Or at least one of the message brokers. But except for that one location it isn't implemented anywhere else. Even the JSON transforms do not handle the JSON datatype. So it could be a nice field of improvement for other transforms to gracefully handle the datatype. And maybe even some extra helper transforms to manipulate json objects 

GitHub link: https://github.com/apache/hop/discussions/5753#discussioncomment-14557054

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org