I was hoping to use the record processors otherwise I would definitely use jolt. I was eventually able to get what I was after using a ScriptedReader. I do like 'payload' better than 'json_string' though. :)
Thanks, Steve On Mon, Sep 3, 2018 at 3:09 AM DEHAY Aurelien <[email protected]> wrote: > Hello. > > > > You will have to remove the “ in the wrapped json, and process it like a > standard string, so I would use the text processors instead of a json one. > > > > We did something different from our side: we use encodeJSON do encapsulate > the json payload, encoded (“ => \” mainly) in a payload string: > > Extract the value with evaluatejsonpath with payload attribute as $ > > Update attribute with payload = ${payload:escapeJson()} > > And a jolt processor with default operation like: > > [ > > { > > "operation": "shift", > > "spec": { > > "PLANT": "DE_PLANT" > > } > > }, > > { > > "operation": "default", > > "spec": { > > "PAYLOAD": "${payload}" > > } > > } > > ] > > > > > > > > > *Aurélien DEHAY *Big Data Architect > +33 616 815 441 > > [email protected] > > 2 rue Hennape - 92735 Nanterre Cedex – France > > [image: Faurecia_inspiring_mobility_logo-RVB_150] > > > > *From:* Steve Champagne [mailto:[email protected]] > *Sent:* mardi 28 août 2018 00:53 > *To:* [email protected] > *Subject:* Wrapping a JSON string > > > > Hello, > > > > I'm ingesting some JSON data that I'd like to wrap in a json_string field > as a string type. I tried using a JsonPathReader with a dynamic property > 'json_string' and a value of $, but I seem to be getting back a string > version of the JSON: > > > > {"partition_date":"2018-01-01T00:00:00.000Z","json_string":"{@timestamp=2018-01-01T00:00:00.000Z, > id=1, name=John}"} > > > > I was wondering if there was a way that I could do this and preserve the > raw JSON format? > > > > Thanks, > > Steve > > This electronic transmission (and any attachments thereto) is intended > solely for the use of the addressee(s). It may contain confidential or > legally privileged information. If you are not the intended recipient of > this message, you must delete it immediately and notify the sender. Any > unauthorized use or disclosure of this message is strictly prohibited. > Faurecia does not guarantee the integrity of this transmission and shall > therefore never be liable if the message is altered or falsified nor for > any virus, interception or damage to your system. >
