Performing a JSON Deserialization in Talend

Question

Following is the sample of the JSON file I need to deserialize:

{
          "ryan@toofr.com": {
            "confidence":119,"email":"ryan@toofr.com","default":20
          },
          "rbuckley@toofr.com": {
            "confidence":20,"email":"rbuckley@toofr.com","default":15
          },
          "ryan.buckley@toofr.com": {
            "confidence":18,"email":"ryan.buckley@toofr.com","default":16
          },
          "ryanbuckley@toofr.com": {
            "confidence":17,"email":"ryanbuckley@toofr.com","default":17
          },
          "ryan_buckley@toofr.com": {
            "confidence":16,"email":"ryan_buckley@toofr.com","default":18
          },
          "ryan-buckley@toofr.com": {
            "confidence":15,"email":"ryan-buckley@toofr.com","default":19
          },
          "ryanb@toofr.com": {
            "confidence":14,"email":"ryanb@toofr.com","default":14
          },
          "buckley@toofr.com": {
            "confidence":13,"email":"buckley@toofr.com","default":13
          }
        }

I am accessing this data using a tAmazonMysqlInput component and with the retrieval of each line of data, I need to invoke the API which gives me the first name, the last name and the company changes every time. Following is the screenshot of my Job:

From the API I am forwarding the data to a tExtractJSONFields component which will then send it to the tLogRow component. tLogRow component will be then displaying the extracted data on the console. But my issue is, I am not able to configure the tExtractJSONFields component to show each row data on the console via tLogRow.

Please help me in configuring the tExtractJSONFields component. For your better understanding, I am adding the snapshot of my tExtractJSONFields component’s current configuration.

Answer 1

tExtractJSONFields component helps in extracting the desired data from incoming JSON fields based on the XPath or JSONPath query. Thus while working with it, two things you must pay attention to are:

1. a valid XPath loop point

2. A valid XPath mapping structure

You might know that while working with XPath in Talend each value needs a unique key. Which means your input data is incorrect:

Instead, what you can use is:

 {
      "contact": {
        "confidence":119,"email":"ryan@toofr.com","default":20
      },
      "contact": {
        "confidence":20,"email":"rbuckley@toofr.com","default":15
      },

So, now the looping point is “/contact” and the mapping for:

“Confidence” -->‘confidence’,

“Email”--> ‘email’

Remember, it becomes the opposite for the “default”.

Hope this will help!

Join the Talend course today to know more about and become expert.

Thanks.