Extract JSON data diferent levels

vicentef — Sat, 16 Nov 2024 03:54:41 GMT

I want to extract JSON data from a file and update a database with the data that i extracted from my file.

The code bellow represents my JSON data simplified :

{
  "data": {
    "uniqueIdData": "1",
    "datecreat": "2019-09-23",
    "libelle": "Septembre 2019",
    "user": "user.user@user.com",
    "date": "2019-09-23 00:00:00",
    "user": [
      {
        "uniqueId": "1",
        "expenseDate": "2019-09-23",
        "categoryName": "Car",
        "categoryType": "Car",
        "approb": [
          {
            "lvl": 1,
            "user": "user1.user@user.com",
            "date": "2019-09-26 00:00:00"
          }
        ],
        "verif_user": "user2.user@usercom",
        "verif_date": "2019-09-26 00:00:00",
        "compta_user": "user3.user@user.com",
        "compta_date": "2019-09-30 00:00:00",
        "code_projet": "PROJECTX"
      },
      {
        "uniqueId": "2",
        "expenseDate": "2019-09-24",
        "categoryName": "Fuel",
        "categoryType": "Fuel",
        "approb": [
          {
            "niv": 1,
            "user": "user2.user@user.com",
            "date": "2019-09-26 00:00:00"
          }
        ],
        "verif_user": "user2.user@user.com",
        "verif_date": "2019-09-26 00:00:00",
        "compta_user": "user3.user@user.com",
        "compta_date": "2019-10-05 00:00:00",
        "code_projet": "PROJECTY"
      }
    ]
  }
}

As you cans see the are 3 levels data => users => aprob.

Job struct

What i have :

Result

What i want to have :

Objectif

Re: Extract JSON data diferent levels

Anonymous — Mon, 16 Dec 2019 06:55:28 GMT

Hi
Read by 'Xpath' model and set the loop xpath as "/data/user/approb", you should be able to extract all records.

Regards
Shong

Re: Extract JSON data diferent levels

uzix — Tue, 17 Dec 2019 13:46:21 GMT

hello

if still interested i have solution.

just reply and i post solution.

topic Re: Extract JSON data diferent levels in Talend Studio

Extract JSON data diferent levels

Re: Extract JSON data diferent levels

Re: Extract JSON data diferent levels