
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
json xpath loop query
Dear Fellow,
I had an json schema just like this:
{
"statusCode": 200,
"result": {
"type": "Topology",
"objects": {
"output": {
"type": "GeometryCollection",
"geometries": [
{
"type": "Point",
"properties": {
"pkey": "307014",
"created_at": "2022-10-07T07:55:03.649Z",
"source": "grasp",
"status": "confirmed",
"url": "4f79bb30-91f7-4f63-9287-3ccb101b5d73",
"image_url": "https://images.petabencana.id/4f79bb30-91f7-4f63-9287-3ccb101b5d73.jpg",
"disaster_type": "flood",
"report_data": {
"report_type": "flood",
"flood_depth": 89
},
"tags": {
"district_id": null,
"local_area_id": null,
"instance_region_code": "ID-JT"
},
"title": null,
"text": "# simulasipekalongan\nberita banjir rob terkini\n5000 warga terdampak banjir\n200 anak-anak\n150 balita",
"partner_code": null,
"partner_icon": null
},
"coordinates": [
109.6194396486,
-7.0385461634
]
},
{
"type": "Point",
"properties": {
"pkey": "307013",
"created_at": "2022-10-07T06:22:00.269Z",
"source": "grasp",
"status": "confirmed",
"url": "9f43d77b-02aa-43b7-95d3-4e9acdb5f7c4",
"image_url": "https://images.petabencana.id/9f43d77b-02aa-43b7-95d3-4e9acdb5f7c4.jpg",
"disaster_type": "flood",
"report_data": {
"report_type": "flood",
"flood_depth": 77
},
"tags": {
"district_id": null,
"local_area_id": null,
"instance_region_code": "ID-JT"
},
"title": null,
"text": "# sinulasipekalongan terjadi bencana banjir rob dengan ketinggian 5 meter\n10 rw terkena dampak \n5 kelurahan mengalami kerusakan",
"partner_code": null,
"partner_icon": null
},
"coordinates": [
109.6281136467,
-6.8474412604
]
}
]
}
},
"arcs": [
],
"bbox": [
109.6194396486,
-7.0385461634,
109.6281136467,
-6.8474412604
]
}
}
I would like to parse those schema using tFileInputJson
It did work but the result is empty columns
Any suggestion to make it work?
Thank you in advance
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would set "Read By" to "JSONPath", set your "Loop JSON query" to....
$.result.objects.output.geometries
....and then take another look at your some of your mappings for the appropriate JSONPath queries.
Take a look at this website to make finding JSONPath queries easier.....
https://jsonpathfinder.com/
Keep in mind that your "Loop JSON query" is where the queries start from in the mapping. So, if the website above gives you a path like this to one of your fields.....
x.result.objects.output.geometries[0].properties.pkey
.... your query for this column will be....
"properties.pkey"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would set "Read By" to "JSONPath", set your "Loop JSON query" to....
$.result.objects.output.geometries
....and then take another look at your some of your mappings for the appropriate JSONPath queries.
Take a look at this website to make finding JSONPath queries easier.....
https://jsonpathfinder.com/
Keep in mind that your "Loop JSON query" is where the queries start from in the mapping. So, if the website above gives you a path like this to one of your fields.....
x.result.objects.output.geometries[0].properties.pkey
.... your query for this column will be....
"properties.pkey"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
