topic Re: Getting JSON fields from JSON array with XPATH in Talend Studio

Getting JSON fields from JSON array with XPATH

Anonymous — Sat, 16 Nov 2024 10:34:11 GMT

My JSON looks like this

{
	"ORDER": ,
	"HELP_NR": "554-5774"
}

How can I get fields out from JSON with XPATH ? The problem is that the number of JSON elements varies. Sometimes is 3, Sometimes is 4 and Sometimes is 2?
So JSON sometimes look like this:

{
	"ORDER": ,
	"HELP_NR": "554-5774"
}

My job looks like this:
tFileInputJSON -- tLogRow
I would like my tLogRow to look like this:
.--------------------.
| tLogRow_2 |
|=------------------=|
|Name |
|=------------------=|
|Mike|
'--------------------'
|Linda|
'--------------------'
|Danny|
'--------------------'

Re: Getting JSON fields from JSON array with XPATH

Anonymous — Tue, 21 Jun 2016 18:07:23 GMT

Hi sebast
I sent the solution
Please look at the snapshot's.

Best regards,
Alfonso Borre
skype : alfonso.borre

Re: Getting JSON fields from JSON array with XPATH

Anonymous — Thu, 23 Jun 2016 19:19:30 GMT

I tested and it works. This is just what I need for now. Thanx.

Re: Getting JSON fields from JSON array with XPATH

Anonymous — Tue, 28 Jun 2016 07:42:06 GMT

I added new JSON object which has array of objects. So my new JSON looks this:

{
    "ORDER": ,
    "HELP_NR": "554-5774",
    "TEAM":
}

I wonder how can I get "NAME_T" values as well?
I was able to get this out, and it is not quite what I wanted:

.-----+--------+------.
|      tLogRow_1      |
|=----+--------+-----=|
|NAME |HELP_NR |NAME_T|
|=----+--------+-----=|
|Mike |554-5774|      |
|Linda|554-5774|      |
'-----+--------+------'

I would like that under "NAME_T" would be 'Orange' and 'Pink'.
And on the picture you can see the settings in the tFileInputJSON:

How can I do that ?