topic Re: Seperate each JSON object in Talend Studio

Seperate each JSON object

kuwaryogi27 — Wed, 10 Jul 2019 12:02:20 GMT

I have a use case where we read an excel using java code since the schema is not fixed.
and create a JSON out of it and the JSON that is getting created is attached in the TEST.json file.
In this file, I want to separate out the content [ ] from each map
In a globalmap, we have multiple HashMaps and we need to get the JSON's row by row so that it can be sent to ActiveMQ.

Re: Seperate each JSON object

nfz11 — Thu, 11 Jul 2019 05:49:37 GMT

Use a tExtractJSONFields component. The key part is configuring the loop query so you may want to learn about JSONPath or XPath. Here is the input and output from a test job:

Starting job TestSeparateJsonObject at 00:42 11/07/2019.

[statistics] connecting to socket on port 3995
[statistics] connected
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
|                                                                                    #1. tLogRow_1                                                                                     |
+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| key  | value                                                                                                                                                                         |
+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| json | {"returnMap1": {"content":[{"id":1111111,"label":"Testing","languageCode":"en_US"}]},"returnMap2": {"content":[{"id":2222222,"label":"New Testing","languageCode":"en_GB"}]}} |
+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

.------------------------.
|     #1. tLogRow_2      |
+--------------+---------+
| key          | value   |
+--------------+---------+
| id           | 1111111 |
| label        | Testing |
| languageCode | en_US   |
+--------------+---------+

.----------------------------.
|       #2. tLogRow_2        |
+--------------+-------------+
| key          | value       |
+--------------+-------------+
| id           | 2222222     |
| label        | New Testing |
| languageCode | en_GB       |
+--------------+-------------+

[statistics] disconnected

Job TestSeparateJsonObject ended at 00:42 11/07/2019. [exit code=0]

Here is a screenshot of the test job showing the details of the tExtractJSONFields component where I use JSONPath in the loop query:

Re: Seperate each JSON object

kuwaryogi27 — Thu, 11 Jul 2019 09:52:20 GMT

@nfz11 , the JSON I attached was a sample one the real JSON is a bit complex I tried tWriteJsonFileds but it was not suitable for the current scenario. So the best way to achieve this was making separate JSON files and reading it through tFileList --> tFileInputRaw --> tJavaRow (read the message and send it to next component as string) --> tMomOutput.

As of now, the task has been solved. Thank you for the guidance and really appreciate it.

Re: Seperate each JSON object

kuwaryogi27 — Thu, 11 Jul 2019 09:56:54 GMT

Attached is the job screenshot to achieve this task.
Regards,
Yogesh.

Re: Seperate each JSON object

nfz11 — Thu, 11 Jul 2019 15:48:00 GMT

That is good that you solved it, but next time be clearer about what you are asking about and give relevant sample input in text format. People are going to try to help you and if you give meaningless sample data and ask the question in an unclear manner it wastes their time.

Re: Seperate each JSON object

kuwaryogi27 — Sat, 13 Jul 2019 12:02:15 GMT

@nfz11, my bad, I am really sorry for this mistake will never ever let this happen again.
Thank you for your valuable time.
Apologies,
Yogesh.

Re: Seperate each JSON object

nfz11 — Sat, 13 Jul 2019 13:56:36 GMT

@ykasture thank you for your apology. You are not the only one who does it, believe me, I see it more often than not. Good luck in your Talend work.