Hola a todos,
He visto otros ejemplos, pero ninguno parece parecer mío aquí, tengo los siguientes datos JSON, ¿cómo los convierto a una tabla:
{
"meta": {
"@id": "http://environment.data.gov.uk/hydrology/id/stations.json?_limit=2",
"editor": "Agencia de Medio Ambiente",
"licencia": "http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/",
"licenseName": "OGL 3",
"comentario": "Versión de prueba de la API de hidrología, alfa",
"versión": "0.2.0",
"hasFormat": [
"http://environment.data.gov.uk/hydrology/id/stations.html?_limit=2",
"http://environment.data.gov.uk/hydrology/id/stations.csv?_limit=2",
"http://environment.data.gov.uk/hydrology/id/stations.json?_limit=2",
"http://environment.data.gov.uk/hydrology/id/stations.ttl?_limit=2",
"http://environment.data.gov.uk/hydrology/id/stations.geojson?_limit=2",
"http://environment.data.gov.uk/hydrology/id/stations.rdf?_limit=2"
],
"límite": 2
},
"artículos": [
{
"@id": "http://environment.data.gov.uk/hydrology/id/stations/951f7162-24d4-45f4-a03e-ee55d3c864c1",
"tipo": [
{
"@id": "http://environment.data.gov.uk/flood-monitoring/def/core/Station"
},
{
"@id": "http://environment.data.gov.uk/reference/def/core/SamplingLocation"
}
],
"etiqueta": "Ponsanooth",
"notación": "951f7162-24d4-45f4-a03e-ee55d3c864c1",
"este": 176228,
"Norte": 37642,
"lat": 50.196411,
"largo": -5.136703,
"RiverName": "Río Kennall",
"stationReference": "48183",
"wiskiID": "SW73F053",
"RLOIid": "3385",
"nrfaStationID": "48007",
"nrfaStationURL": "https://nrfa.ceh.ac.uk/data/station/info/48007.html",
"stationGuid": "951f7162-24d4-45f4-a03e-ee55d3c864c1",
"medidas": [
{
"@id": "http://environment.data.gov.uk/hydrology/id/measures/951f7162-24d4-45f4-a03e-ee55d3c864c1-flow-m-86400-m3s-qualified",
"etiqueta": "Series de tiempo de flujo medios diarias calificadas para SW73F053(Ponsanooth)",
"observedProperty": {
"@id": "http://environment.data.gov.uk/reference/def/op/waterFlow",
"etiqueta": "Flujo de agua"
},
"unitName": "m3/s",
"notación": "951f7162-24d4-45f4-a03e-ee55d3c864c1-flow-m-86400-m3s-qualified",
"período": 86400,
"valueStatistic": {
"@id": "http://environment.data.gov.uk/reference/def/core/mean",
"etiqueta": "mezquino"
},
"observationType": {
"@id": "http://environment.data.gov.uk/reference/def/core/Qualified",
"etiqueta": "Calificado"
}
},
{
"@id": "http://environment.data.gov.uk/hydrology/id/measures/951f7162-24d4-45f4-a03e-ee55d3c864c1-flow--i-15_min-m3_s-measured",
"etiqueta": "Flujo medido 15 min timeseries para Ponsanooth",
"observedProperty": {
"@id": "http://environment.data.gov.uk/reference/def/op/waterFlow",
"etiqueta": "Flujo de agua"
},
"unitName": "m3/s",
"notación": "951f7162-24d4-45f4-a03e-ee55d3c864c1-flow--i-15_min-m3_s medido",
"período": 900,
"valueStatistic": {
"@id": "http://environment.data.gov.uk/reference/def/core/mean",
"etiqueta": "mezquino"
},
"observationType": {
"@id": "http://environment.data.gov.uk/reference/def/core/Measured",
"etiqueta": "Medido"
}
}
]
},
{
"@id": "http://environment.data.gov.uk/hydrology/id/stations/d9f8ae6e-a12e-4fbf-972e-21c89e521789",
"tipo": [
{
"@id": "http://environment.data.gov.uk/flood-monitoring/def/core/Station"
},
{
"@id": "http://environment.data.gov.uk/reference/def/core/SamplingLocation"
}
],
"etiqueta": "Brent (Monks Park)",
"notación": "d9f8ae6e-a12e-4fbf-972e-21c89e521789",
"este": 520194,
"norte": 185052,
"lat": 51.551558,
"largo": -0.267837,
"riverName": "Río Brent",
"stationReference": "3850TH",
"wiskiID": "3850TH",
"nrfaStationID": "39093",
"nrfaStationURL": "https://nrfa.ceh.ac.uk/data/station/info/39093.html",
"stationGuid": "d9f8ae6e-a12e-4fbf-972e-21c89e521789",
"medidas": {
"@id": "http://environment.data.gov.uk/hydrology/id/measures/d9f8ae6e-a12e-4fbf-972e-21c89e521789-flow-m-86400-m3s-qualified",
"etiqueta": "Horarios de flujo medios diarios calificados para 3850TH(Brent (Monks Park))",
"observedProperty": {
"@id": "http://environment.data.gov.uk/reference/def/op/waterFlow",
"etiqueta": "Flujo de agua"
},
"unitName": "m3/s",
"notación": "d9f8ae6e-a12e-4fbf-972e-21c89e521789-flow-m-86400-m3s-qualified",
"período": 86400,
"valueStatistic": {
"@id": "http://environment.data.gov.uk/reference/def/core/mean",
"etiqueta": "mezquino"
},
"observationType": {
"@id": "http://environment.data.gov.uk/reference/def/core/Qualified",
"etiqueta": "Calificado"
}
}
}
]
}
Actualmente, sale así en Power BI:
meta : Grabar
artículos: Lista
Lo siento, no sé cómo adjuntar fotos en el post.
gracias.
