how to get json body content value

[DiliTimor]

Dear All,

I have json file with this format:

{

  "U.04": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Sangat Tinggi",

    "tommorow": "Sangat Tinggi",

    "h2": "Sangat Tinggi",

    "h3": "Tinggi"

  },

  "U.02": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Sangat Tinggi",

    "tommorow": "Sangat Tinggi",

    "h2": "Tinggi",

    "h3": "Tinggi"

  },

  "U.01": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Rendah",

    "tommorow": "Rendah",

    "h2": "Rendah",

    "h3": "Rendah"

  },

  "U.03": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Sangat Tinggi",

    "tommorow": "Sangat Tinggi",

    "h2": "Sangat Tinggi",

    "h3": "Tinggi"

  },

  "B.09": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Sangat Tinggi",

    "tommorow": "Sangat Tinggi",

    "h2": "Tinggi",

    "h3": "Tinggi"

  },

  "B.05": {

    "issued": "2022-08-04 05:00 UTC",

    "today": "Rendah",

    "tommorow": "Rendah",

    "h2": "Rendah",

    "h3": "Rendah"

  }

}

with tjsoninput component i can extract issued, today, tommorow, h2 and h3.

My question is how to extract/get the "U.04", "U.02","U.01", and so on

[SamuelLenk]

If the file is not big, you can iterate U.* and B.* dynamically. See the picture for a simple implementation.

HTH! Kind regards, Samuel

https://talend-training.com/