How to handle json array without key using THMAP

[Jacco_De_Zwart]

Hi al,

When I use an api-end-point that returns it's data in a json array. This array has no key (see image below)

How do I handle this type of array without a name (without a key) ??

JSON responses with an array that does have a name (the array has a key), like this one :

 is no problem using THMAP.

What do I need to do in order to proces an array without a key ?

Thanks in advance.

[fcolagiacomo]

Hi,

I don't know tHMap but if you could use json path (tExtractJSONFields component) you can use the query  "$.[*]" to get all elements of array.

[jlolling]

There is a complete component collection handlich json in a most convinent way:  tJSONDoc*-Komponents.

These componentes works native with JSON without using XML Documents as internal format.

Check them out here: https://github.com/jlolling/talendcomp_tJSONDoc

[Jacco_De_Zwart]

Thanks Jan, I will check these components out !