Ask Your Question

How to reference JSON Text

asked 2018-01-30 14:22:59 -0500

ZDG gravatar image

updated 2018-01-31 10:24:20 -0500

metadaddy gravatar image

Can someone tell me how to reference the text of a json object? I remember doing this once but I think it was by accident. I currently reference the text but when I do it adds a lot to the text such as "MAP: and STRING:" key words. I just want the json in its original form.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-01-31 10:30:27 -0500

metadaddy gravatar image

As you've discovered, SDC parses the incoming JSON into a record containing a hierarchy of fields. To get back to JSON, you can use the JSON Generator processor. You can set the Field to Serialize to the root of the record /, or any other field in the record. Similarly, you can put the generated JSON string in any field you like: the root, an existing field or a new field.

edit flag offensive delete link more


Awesome thanks! I was trying to use that component (JSON Generator) but didn't have the confidence to keep trying as it took a bit to get everything correct especially how to reference the field in the JDBC Query component. A little trial and error brought success. Thank for your help!

ZDG gravatar imageZDG ( 2018-01-31 13:52:42 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-30 14:22:59 -0500

Seen: 8,443 times

Last updated: Jan 31 '18