topic JSON Extract numeric keys without attributes in Talend Studio

JSON Extract numeric keys without attributes

PRocque1686642795 — Fri, 15 Nov 2024 21:41:24 GMT

Hello,

I'm having a problem with a JSON file containing weather data. The file is attached. My objective is to extract the data in talend in order to obtain an Excel output file with a timestamp column, an FF column, an LW_D column, an LW_V column, an RR column, an SSI column, a T column, a T_DEW column and a U column.

The problem is that I can't get timestamp values that don't have attributes.

Until now, I've been using a TextractJsonfields but I can't get the timestamp values.

Thanks for your help.

Re: JSON Extract numeric keys without attributes

anselmopeixoto — Wed, 14 Jun 2023 01:28:52 GMT

Hi @Paulin Rocque

From what I got, you want to extract the element names like "1685966400" but this JSON format is tricky and I believe it won't be possible with tExtractJsonFields alone.

It seems this JSON was designed to be queried for specific timestamps. With that said, I would try to first extract a list of available timestamps from it. Then with that list of timestamps stored in memory you would be able to iterate over the file and query the weather metrics using expressions like $.1685966400 for example.

Re: JSON Extract numeric keys without attributes

PRocque1686642795 — Wed, 14 Jun 2023 06:29:17 GMT

Hi, thanks for your feedback,

In fact, the aim is to get the timestamps. And these timestamps are never the same, so it's impossible to call them specifically.

But yes, one solution could be to extract only the timestamps first, then the rest of the data. But I haven't managed to do that.