Is there a way to loop the Json Writer so it creates a json structure for each input record that is passed to it? I want to create multiple Jsons as an input to the HTTP connector so I can send a request for each each record. So far I have been able to do it by manually creating the Json structure as a string using the reformat component and concatenating the the inputs but was wondering if it was possible to do the same with the Json writer.
For example , I would like to produce for each record
I have also tried split out the json structure using the streaming option as opposed to the discrete option but was unsure how to do split it in a way the produces a valid json for each part
I believe that you can indeed achieve your goal by using the JSONWriter component. The component, however, assumes that it is intended to create one JSON file from all records (from the whole data flow). In order to tell the component that you need one result for each row, you might want to set the “Records per file” attribute to 1. This way, the JSONWriter creates a separate JSON file for each record.
If you then use the output port writing function (you can use the discrete option now), the component will send a list of JSON strings to the output port, where each row corresponds with each original record. The result on the edge looks like this:
CaptureJson.PNG
I have created a graph for your review (I am including input data that the graph uses). Please take a look. I hope this meets your needs, but if not, please let me know.
I believe that you can indeed achieve your goal by using the JSONWriter component. The component, however, assumes that it is intended to create one JSON file from all records (from the whole data flow). In order to tell the component that you need one result for each row, you might want to set the “Records per file” attribute to 1. This way, the JSONWriter creates a separate JSON file for each record.
If you then use the output port writing function (you can use the discrete option now), the component will send a list of JSON strings to the output port, where each row corresponds with each original record. The result on the edge looks like this:
CaptureJson.PNG
I have created a graph for your review (I am including input data that the graph uses). Please take a look. I hope this meets your needs, but if not, please let me know.
