Select to view content in your preferred language

JSON URL in Data Pipeline

164
1
Jump to solution
04-21-2025 02:21 AM
Labels (2)
HingFungChan
Occasional Contributor

I have a JSON's URL with formate like this(link below)

{
    "obsTime": "2025-04-21T17:00:00+08:00",
    "hourlyRainfall": [
        {
            "automaticWeatherStation": "Lau Fau Shan",
            "automaticWeatherStationID": "RF001",
            "value": "0",
            "unit": "mm"
        },

https://data.weather.gov.hk/weatherAPI/opendata/hourlyRainfall.php?lang=en

HingFungChan_0-1745227247866.png

 

 

And it input all the data in one cell. But I would like a table.
How can I do that?

0 Kudos
1 Solution

Accepted Solutions
HingFungChan
Occasional Contributor

NVM, just input hourlyRainfall in  Root property

HingFungChan_0-1745228781946.png

 

 

View solution in original post

0 Kudos
1 Reply
HingFungChan
Occasional Contributor

NVM, just input hourlyRainfall in  Root property

HingFungChan_0-1745228781946.png

 

 
0 Kudos