Can't figure out this APATH
I have a validated JSON file which is displaying a list of events. I'm having a hard time cracking the code on the APATH value. I've used this module successfully for many years with JSON formatted a bit differently from a different source, and I've tried a bunch of variations with no success.
Here's the JSON:
{
"events": [
{
"event": {
"id": 47100462204030,
"title": "Convocation 2024",
"url": "",
"updated_at": "2024-08-21T08:34:31-04:00",
"created_at": "2024-07-29T12:10:51-04:00",
"event_instances": [
{
"event_instance": {
"id": 47100462206079,
"event_id": 47100462204030,
"start": "2024-08-29T15:00:00-04:00",
"end": "2024-08-29T16:00:00-04:00"
}
}
],
"address": "xxx xxx xxxx ",
"description": "xxx xxx",
"featured": true,
"geo": {
"latitude": "xx.xxxxx",
"longitude": "xx.xxxxx",
"street": "xxx xxx Street",
"city": "xxx",
"state": "xx",
"country": "US",
"zip": "xxxxx"
},
"filters": {
"departments": [
{
"name": "Faculty/Staff",
"id": 132070
},
{
"name": "Parents and families",
"id": 132072
}
],
"event_types": [
{
"name": "Campus-wide",
"id": 132076
},
{
"name": "Academic",
"id": 132333
},
{
"name": "Virtual",
"id": 33183103839399
}
]
},
"custom_fields": {
}
}
},
{
"event": {
"id": 47100462204030,
"title": "Convocation 2024",
"url": "",
"updated_at": "2024-08-21T08:34:31-04:00",
"created_at": "2024-07-29T12:10:51-04:00",
"event_instances": [
{
"event_instance": {
"id": 47100462206079,
"event_id": 47100462204030,
"start": "2024-08-29T15:00:00-04:00",
"end": "2024-08-29T16:00:00-04:00"
}
}
],
"address": "xxx xxx xxxx ",
"description": "xxx xxx",
"featured": true,
"geo": {
"latitude": "xx.xxxxx",
"longitude": "xx.xxxxx",
"street": "xxx xxx Street",
"city": "xxx",
"state": "xx",
"country": "US",
"zip": "xxxxx"
},
"filters": {
"departments": [
{
"name": "Faculty/Staff",
"id": 132070
},
{
"name": "Parents and families",
"id": 132072
}
],
"event_types": [
{
"name": "Campus-wide",
"id": 132076
},
{
"name": "Academic",
"id": 132333
},
{
"name": "Virtual",
"id": 33183103839399
}
]
},
"custom_fields": {
}
}
}
],
"page":{
"current":1,
"size":10,
"total":1
},
"date":{
"first":"2024-07-15",
"last":"2025-07-10"
}
}
I've tried the following for APATH:
events
event
%/event
events/event
ChatGPT suggested I try:
events[].event
No joy with any of these. Anyone know how to crack this one? Thanks!
Active
2.0
Module
For your case you must enter in
[Advanced -> Others -> Query settings] Row Apath = events
[Fields] JSON_FIELD = event/id
You can debug the all possible values in the render function of this plugin in contribe module 'web/modules/contrib/views_json_source/src/Plugin/views/field/ViewsJsonField.php'
I attached screen shots for debugging to trace the property path