Hi Everyone,
I’m trying to create a Remote Dataset using a JSON-File, but I’m not quite sure what I’ve to set as “Remote Data Path” in Xibo.
Here’s an JSON-example, which i found in recent thread and currently use for testing (the productive data has the same structure):
{
"uniqueKeys":[
"petName"
],
"rows":[
{
"petName":"Buffy",
"ownerName":"Hassum Harrod",
"aptDate":"2016-06-20 15:30",
"aptNotes":"This Chihuahua has not eaten for three days and is lethargic"
},
{
"petName":"Spot",
"ownerName":"Constance Smith",
"aptDate":"2016-06-24 08:30",
"aptNotes":"This German Shepherd is having some back pain"
},
{
"petName":"Goldie",
"ownerName":"Barot Bellingham",
"aptDate":"2016-06-22 15:50",
"aptNotes":"This Goldfish has some weird spots in the belly"
},
{
"petName":"Mitten",
"ownerName":"Hillary Goldwyn",
"aptDate":"2016-06-21 9:15",
"aptNotes":"Cat has excessive hairballs"
}
]
}
I created a remote Dataset (“Data root” empty or rows) and a new column called petName:
- Heading: petName
- Column Type: Remote
- Data Type: String
- Column-Order: 1
But here I’m not quite sure what to configure as Remote Data Path. I tried the following:
- [:].petName
- $.rows.[:].petName
- [‘json’ => $.rows.[:].petName]
I also tested the provided example (Data Set -> Remote data source), which works but doesn’t help me much in this case.
This is my first contact with json, so I think that I’m just missing somethings.
best regards,
André