The data in the table should update once the task fetch remote dataset runs, I believe it runs every hour by default - you can see it and adjust on Tasks page in CMS.
You can also try Run Now option on it, to force it to run now.
I did Run Now in Task “Fetch Remote DataSets”, but there is nothing in the table…
Hello, i have tried to make dummy data like in other thread, created same dataset column just like what it said, but still when i test data URL , it had difference result.
And one more thing, i tried to get credential username and password using $_POST, but it returns empty arrays,
Maybe i did something wrong here?
Note : I use docker for Xibo CMS 1.8.9
I have that remote dataset with .json from this topic, just run the task now and I do have the data now:
Could you see if the task definitely run? perhaps you could share the Tasks page screenshot with us.
Is the last sync on the dataSet updated?
Is that on a new dataSet or did you edit existing dataSet that had wrong configuration?
Obviously those values in my post were explicitly to that example .json in this topic, if you have completely different .json then it is possible that some adjustments need to be made.
yes, there is a problem with auth credentials at the moment, it should be fixed in 1.8.10 - guthub issue - Remote DataSets: Authentication not working · Issue #1525 · xibosignage/xibo · GitHub
OH!!! 
I saw what was wrong…
My file was a .txt with a JSON text inside. I just put .json instead of .txt and it’s right.
Thank you for your help!!!
1 Like
Hi Peter, thanks for your response
Here’s the link to my problem :
I am facing the same problems… configured to fetch the data using ‘GET’ method. When I pressed the ‘Test URL’ button, it gives me this results;
{
“entries”: [
[
{
“id”: 1,
“name”: “Leanne Graham”,
“username”: “Bret”,
“email”: “Sincere@april.biz”,
“address”: {
“street”: “Kulas Light”,
“suite”: “Apt. 556”,
“city”: “Gwenborough”,
“zipcode”: “92998-3874”,
“geo”: {
“lat”: “-37.3159”,
“lng”: “81.1496”
}
},
“phone”: “1-770-736-8031 x56442”,
“website”: “hildegard.org”,
“company”: {
“name”: “Romaguera-Crona”,
“catchPhrase”: “Multi-layered client-server neural-net”,
“bs”: “harness real-time e-markets”
}
},
{
“id”: 2,
“name”: “Ervin Howell”,
“username”: “Antonette”,
“email”: “Shanna@melissa.tv”,
“address”: {
“street”: “Victor Plains”,
“suite”: “Suite 879”,
“city”: “Wisokyburgh”,
“zipcode”: “90566-7771”,
“geo”: {
“lat”: “-43.9509”,
“lng”: “-34.4618”
}
},
“phone”: “010-692-6593 x09125”,
“website”: “anastasia.net”,
“company”: {
“name”: “Deckow-Crist”,
“catchPhrase”: “Proactive didactic contingency”,
“bs”: “synergize scalable supply-chains”
}
},
{
“id”: 3,
“name”: “Clementine Bauch”,
“username”: “Samantha”,
“email”: “Nathan@yesenia.net”,
“address”: {
“street”: “Douglas Extension”,
“suite”: “Suite 847”,
“city”: “McKenziehaven”,
“zipcode”: “59590-4157”,
“geo”: {
“lat”: “-68.6102”,
“lng”: “-47.0653”
}
},
“phone”: “1-463-123-4447”,
“website”: “ramiro.info”,
“company”: {
“name”: “Romaguera-Jacobson”,
“catchPhrase”: “Face to face bifurcated interface”,
“bs”: “e-enable strategic applications”
}
},
{
“id”: 4,
“name”: “Patricia Lebsack”,
“username”: “Karianne”,
“email”: “Julianne.OConner@kory.org”,
“address”: {
“street”: “Hoeger Mall”,
“suite”: “Apt. 692”,
“city”: “South Elvis”,
“zipcode”: “53919-4257”,
“geo”: {
“lat”: “29.4572”,
“lng”: “-164.2990”
}
},
“phone”: “493-170-9623 x156”,
“website”: “kale.biz”,
“company”: {
“name”: “Robel-Corkery”,
“catchPhrase”: “Multi-tiered zero tolerance productivity”,
“bs”: “transition cutting-edge web services”
}
},
{
“id”: 5,
“name”: “Chelsey Dietrich”,
“username”: “Kamren”,
“email”: “Lucio_Hettinger@annie.ca”,
“address”: {
“street”: “Skiles Walks”,
“suite”: “Suite 351”,
“city”: “Roscoeview”,
“zipcode”: “33263”,
“geo”: {
“lat”: “-31.8129”,
“lng”: “62.5342”
}
},
“phone”: “(254)954-1289”,
“website”: “demarco.info”,
“company”: {
“name”: “Keebler LLC”,
“catchPhrase”: “User-centric fault-tolerant solution”,
“bs”: “revolutionize end-to-end systems”
}
},
{
“id”: 6,
“name”: “Mrs. Dennis Schulist”,
“username”: “Leopoldo_Corkery”,
“email”: “Karley_Dach@jasper.info”,
“address”: {
“street”: “Norberto Crossing”,
“suite”: “Apt. 950”,
“city”: “South Christy”,
“zipcode”: “23505-1337”,
“geo”: {
“lat”: “-71.4197”,
“lng”: “71.7478”
}
},
“phone”: “1-477-935-8478 x6430”,
“website”: “ola.org”,
“company”: {
“name”: “Considine-Lockman”,
“catchPhrase”: “Synchronised bottom-line interface”,
“bs”: “e-enable innovative applications”
}
},
{
“id”: 7,
“name”: “Kurtis Weissnat”,
“username”: “Elwyn.Skiles”,
“email”: “Telly.Hoeger@billy.biz”,
“address”: {
“street”: “Rex Trail”,
“suite”: “Suite 280”,
“city”: “Howemouth”,
“zipcode”: “58804-1099”,
“geo”: {
“lat”: “24.8918”,
“lng”: “21.8984”
}
},
“phone”: “210.067.6132”,
“website”: “elvis.io”,
“company”: {
“name”: “Johns Group”,
“catchPhrase”: “Configurable multimedia task-force”,
“bs”: “generate enterprise e-tailers”
}
},
{
“id”: 8,
“name”: “Nicholas Runolfsdottir V”,
“username”: “Maxime_Nienow”,
“email”: “Sherwood@rosamond.me”,
“address”: {
“street”: “Ellsworth Summit”,
“suite”: “Suite 729”,
“city”: “Aliyaview”,
“zipcode”: “45169”,
“geo”: {
“lat”: “-14.3990”,
“lng”: “-120.7677”
}
},
“phone”: “586.493.6943 x140”,
“website”: “jacynthe.com”,
“company”: {
“name”: “Abernathy Group”,
“catchPhrase”: “Implemented secondary concept”,
“bs”: “e-enable extensible e-tailers”
}
},
{
“id”: 9,
“name”: “Glenna Reichert”,
“username”: “Delphine”,
“email”: “Chaim_McDermott@dana.io”,
“address”: {
“street”: “Dayna Park”,
“suite”: “Suite 449”,
“city”: “Bartholomebury”,
“zipcode”: “76495-3109”,
“geo”: {
“lat”: “24.6463”,
“lng”: “-168.8889”
}
},
“phone”: “(775)976-6794 x41206”,
“website”: “conrad.com”,
“company”: {
“name”: “Yost and Sons”,
“catchPhrase”: “Switchable contextually-based project”,
“bs”: “aggregate real-time technologies”
}
},
{
“id”: 10,
“name”: “Clementina DuBuque”,
“username”: “Moriah.Stanton”,
“email”: “Rey.Padberg@karina.biz”,
“address”: {
“street”: “Kattie Turnpike”,
“suite”: “Suite 198”,
“city”: “Lebsackbury”,
“zipcode”: “31428-2261”,
“geo”: {
“lat”: “-38.2386”,
“lng”: “57.2232”
}
},
“phone”: “024-648-3804”,
“website”: “ambrose.net”,
“company”: {
“name”: “Hoeger LLC”,
“catchPhrase”: “Centralized empowering task-force”,
“bs”: “target end-to-end models”
}
}
]
],
“number”: 1,
“processed”: [
[
{
“number”: “1”,
“name”: “Leanne Graham”,
“username”: “Bret”,
“email”: “Sincere@april.biz”,
“address”: false,
“phone”: “1-770-736-8031 x56442”,
“website”: “hildegard.org”,
“company”: false
},
{
“number”: “2”,
“name”: “Ervin Howell”,
“username”: “Antonette”,
“email”: “Shanna@melissa.tv”,
“address”: false,
“phone”: “010-692-6593 x09125”,
“website”: “anastasia.net”,
“company”: false
},
{
“number”: “3”,
“name”: “Clementine Bauch”,
“username”: “Samantha”,
“email”: “Nathan@yesenia.net”,
“address”: false,
“phone”: “1-463-123-4447”,
“website”: “ramiro.info”,
“company”: false
},
{
“number”: “4”,
“name”: “Patricia Lebsack”,
“username”: “Karianne”,
“email”: “Julianne.OConner@kory.org”,
“address”: false,
“phone”: “493-170-9623 x156”,
“website”: “kale.biz”,
“company”: false
},
{
“number”: “5”,
“name”: “Chelsey Dietrich”,
“username”: “Kamren”,
“email”: “Lucio_Hettinger@annie.ca”,
“address”: false,
“phone”: “(254)954-1289”,
“website”: “demarco.info”,
“company”: false
},
{
“number”: “6”,
“name”: “Mrs. Dennis Schulist”,
“username”: “Leopoldo_Corkery”,
“email”: “Karley_Dach@jasper.info”,
“address”: false,
“phone”: “1-477-935-8478 x6430”,
“website”: “ola.org”,
“company”: false
},
{
“number”: “7”,
“name”: “Kurtis Weissnat”,
“username”: “Elwyn.Skiles”,
“email”: “Telly.Hoeger@billy.biz”,
“address”: false,
“phone”: “210.067.6132”,
“website”: “elvis.io”,
“company”: false
},
{
“number”: “8”,
“name”: “Nicholas Runolfsdottir V”,
“username”: “Maxime_Nienow”,
“email”: “Sherwood@rosamond.me”,
“address”: false,
“phone”: “586.493.6943 x140”,
“website”: “jacynthe.com”,
“company”: false
},
{
“number”: “9”,
“name”: “Glenna Reichert”,
“username”: “Delphine”,
“email”: “Chaim_McDermott@dana.io”,
“address”: false,
“phone”: “(775)976-6794 x41206”,
“website”: “conrad.com”,
“company”: false
},
{
“number”: “10”,
“name”: “Clementina DuBuque”,
“username”: “Moriah.Stanton”,
“email”: “Rey.Padberg@karina.biz”,
“address”: false,
“phone”: “024-648-3804”,
“website”: “ambrose.net”,
“company”: false
}
]
],
“messages”: [
“Processing 1 results into 8 potential columns”,
"Processing Result with Data Root ",
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Processing 2”,
“Processing 3”,
“Processing 4”,
“Processing 5”,
“Processing 6”,
“Processing 7”,
“Processing 8”,
“Processing 9”,
“Consolidating entries”,
“There are 10 entries in total”
]
}
I am using test source http://jsonplaceholder.typicode.com/users.
But there’s nothing on the Data set Table in ‘view data’ even after I have Run ‘Fetch Remote Data Set’
Please help anyone… Thanks
How did you configure your remote columns please?
Also did the fetch remote dataset task definitely run?
(you’d expect to see correct date in Last Sync column on DataSet page if the task did run)
Here’s my column configuration:
I have Run the Fetch Remote DataSet Task
but still results in:
Please help, Thanks.
{
“entries”: [
[
{
“id”: 1,
“name”: “Leanne Graham”,
“username”: “Bret”,
“email”: “Sincere@april.biz”,
“address”: {
“street”: “Kulas Light”,
“suite”: “Apt. 556”,
“city”: “Gwenborough”,
“zipcode”: “92998-3874”,
“geo”: {
“lat”: “-37.3159”,
“lng”: “81.1496”
}
},
“phone”: “1-770-736-8031 x56442”,
“website”: “hildegard.org”,
“company”: {
“name”: “Romaguera-Crona”,
“catchPhrase”: “Multi-layered client-server neural-net”,
“bs”: “harness real-time e-markets”
}
},
{
“id”: 2,
“name”: “Ervin Howell”,
“username”: “Antonette”,
“email”: "Shanna@melissa.tv",
“address”: {
“street”: “Victor Plains”,
“suite”: “Suite 879”,
“city”: “Wisokyburgh”,
“zipcode”: “90566-7771”,
“geo”: {
“lat”: “-43.9509”,
“lng”: “-34.4618”
}
},
“phone”: “010-692-6593 x09125”,
“website”: “anastasia.net”,
“company”: {
“name”: “Deckow-Crist”,
“catchPhrase”: “Proactive didactic contingency”,
“bs”: “synergize scalable supply-chains”
}
},
{
“id”: 3,
“name”: “Clementine Bauch”,
“username”: “Samantha”,
“email”: "Nathan@yesenia.net",
“address”: {
“street”: “Douglas Extension”,
“suite”: “Suite 847”,
“city”: “McKenziehaven”,
“zipcode”: “59590-4157”,
“geo”: {
“lat”: “-68.6102”,
“lng”: “-47.0653”
}
},
“phone”: “1-463-123-4447”,
“website”: “ramiro.info”,
“company”: {
“name”: “Romaguera-Jacobson”,
“catchPhrase”: “Face to face bifurcated interface”,
“bs”: “e-enable strategic applications”
}
},
{
“id”: 4,
“name”: “Patricia Lebsack”,
“username”: “Karianne”,
“email”: "Julianne.OConner@kory.org",
“address”: {
“street”: “Hoeger Mall”,
“suite”: “Apt. 692”,
“city”: “South Elvis”,
“zipcode”: “53919-4257”,
“geo”: {
“lat”: “29.4572”,
“lng”: “-164.2990”
}
},
“phone”: “493-170-9623 x156”,
“website”: “kale.biz”,
“company”: {
“name”: “Robel-Corkery”,
“catchPhrase”: “Multi-tiered zero tolerance productivity”,
“bs”: “transition cutting-edge web services”
}
},
{
“id”: 5,
“name”: “Chelsey Dietrich”,
“username”: “Kamren”,
“email”: “Lucio_Hettinger@annie.ca”,
“address”: {
“street”: “Skiles Walks”,
“suite”: “Suite 351”,
“city”: “Roscoeview”,
“zipcode”: “33263”,
“geo”: {
“lat”: “-31.8129”,
“lng”: “62.5342”
}
},
“phone”: “(254)954-1289”,
“website”: “demarco.info”,
“company”: {
“name”: “Keebler LLC”,
“catchPhrase”: “User-centric fault-tolerant solution”,
“bs”: “revolutionize end-to-end systems”
}
},
{
“id”: 6,
“name”: “Mrs. Dennis Schulist”,
“username”: “Leopoldo_Corkery”,
“email”: “Karley_Dach@jasper.info”,
“address”: {
“street”: “Norberto Crossing”,
“suite”: “Apt. 950”,
“city”: “South Christy”,
“zipcode”: “23505-1337”,
“geo”: {
“lat”: “-71.4197”,
“lng”: “71.7478”
}
},
“phone”: “1-477-935-8478 x6430”,
“website”: “ola.org”,
“company”: {
“name”: “Considine-Lockman”,
“catchPhrase”: “Synchronised bottom-line interface”,
“bs”: “e-enable innovative applications”
}
},
{
“id”: 7,
“name”: “Kurtis Weissnat”,
“username”: “Elwyn.Skiles”,
“email”: “Telly.Hoeger@billy.biz”,
“address”: {
“street”: “Rex Trail”,
“suite”: “Suite 280”,
“city”: “Howemouth”,
“zipcode”: “58804-1099”,
“geo”: {
“lat”: “24.8918”,
“lng”: “21.8984”
}
},
“phone”: “210.067.6132”,
“website”: “elvis.io”,
“company”: {
“name”: “Johns Group”,
“catchPhrase”: “Configurable multimedia task-force”,
“bs”: “generate enterprise e-tailers”
}
},
{
“id”: 8,
“name”: “Nicholas Runolfsdottir V”,
“username”: “Maxime_Nienow”,
“email”: "Sherwood@rosamond.me",
“address”: {
“street”: “Ellsworth Summit”,
“suite”: “Suite 729”,
“city”: “Aliyaview”,
“zipcode”: “45169”,
“geo”: {
“lat”: “-14.3990”,
“lng”: “-120.7677”
}
},
“phone”: “586.493.6943 x140”,
“website”: “jacynthe.com”,
“company”: {
“name”: “Abernathy Group”,
“catchPhrase”: “Implemented secondary concept”,
“bs”: “e-enable extensible e-tailers”
}
},
{
“id”: 9,
“name”: “Glenna Reichert”,
“username”: “Delphine”,
“email”: "Chaim_McDermott@dana.io",
“address”: {
“street”: “Dayna Park”,
“suite”: “Suite 449”,
“city”: “Bartholomebury”,
“zipcode”: “76495-3109”,
“geo”: {
“lat”: “24.6463”,
“lng”: “-168.8889”
}
},
“phone”: “(775)976-6794 x41206”,
“website”: “conrad.com”,
“company”: {
“name”: “Yost and Sons”,
“catchPhrase”: “Switchable contextually-based project”,
“bs”: “aggregate real-time technologies”
}
},
{
“id”: 10,
“name”: “Clementina DuBuque”,
“username”: “Moriah.Stanton”,
“email”: “Rey.Padberg@karina.biz”,
“address”: {
“street”: “Kattie Turnpike”,
“suite”: “Suite 198”,
“city”: “Lebsackbury”,
“zipcode”: “31428-2261”,
“geo”: {
“lat”: “-38.2386”,
“lng”: “57.2232”
}
},
“phone”: “024-648-3804”,
“website”: “ambrose.net”,
“company”: {
“name”: “Hoeger LLC”,
“catchPhrase”: “Centralized empowering task-force”,
“bs”: “target end-to-end models”
}
}
]
],
“number”: 1,
“processed”: [
[
{
“Number”: “1”,
“Name”: “Leanne Graham”,
“Username”: “Bret”,
“Email”: “Sincere@april.biz”,
“Address street”: “Kulas Light”,
“Address suite”: “Apt. 556”,
“Address city”: “Gwenborough”,
“Address zipcode”: “92998-3874”,
“Phone”: “1-770-736-8031 x56442”,
“Website”: “hildegard.org”,
“Company”: “Romaguera-Crona”,
“Company catchPhrase”: “Multi-layered client-server neural-net”,
“company bs”: “harness real-time e-markets”
},
{
“Number”: “2”,
“Name”: “Ervin Howell”,
“Username”: “Antonette”,
“Email”: "Shanna@melissa.tv",
“Address street”: “Victor Plains”,
“Address suite”: “Suite 879”,
“Address city”: “Wisokyburgh”,
“Address zipcode”: “90566-7771”,
“Phone”: “010-692-6593 x09125”,
“Website”: “anastasia.net”,
“Company”: “Deckow-Crist”,
“Company catchPhrase”: “Proactive didactic contingency”,
“company bs”: “synergize scalable supply-chains”
},
{
“Number”: “3”,
“Name”: “Clementine Bauch”,
“Username”: “Samantha”,
“Email”: "Nathan@yesenia.net",
“Address street”: “Douglas Extension”,
“Address suite”: “Suite 847”,
“Address city”: “McKenziehaven”,
“Address zipcode”: “59590-4157”,
“Phone”: “1-463-123-4447”,
“Website”: “ramiro.info”,
“Company”: “Romaguera-Jacobson”,
“Company catchPhrase”: “Face to face bifurcated interface”,
“company bs”: “e-enable strategic applications”
},
{
“Number”: “4”,
“Name”: “Patricia Lebsack”,
“Username”: “Karianne”,
“Email”: "Julianne.OConner@kory.org",
“Address street”: “Hoeger Mall”,
“Address suite”: “Apt. 692”,
“Address city”: “South Elvis”,
“Address zipcode”: “53919-4257”,
“Phone”: “493-170-9623 x156”,
“Website”: “kale.biz”,
“Company”: “Robel-Corkery”,
“Company catchPhrase”: “Multi-tiered zero tolerance productivity”,
“company bs”: “transition cutting-edge web services”
},
{
“Number”: “5”,
“Name”: “Chelsey Dietrich”,
“Username”: “Kamren”,
“Email”: “Lucio_Hettinger@annie.ca”,
“Address street”: “Skiles Walks”,
“Address suite”: “Suite 351”,
“Address city”: “Roscoeview”,
“Address zipcode”: “33263”,
“Phone”: “(254)954-1289”,
“Website”: “demarco.info”,
“Company”: “Keebler LLC”,
“Company catchPhrase”: “User-centric fault-tolerant solution”,
“company bs”: “revolutionize end-to-end systems”
},
{
“Number”: “6”,
“Name”: “Mrs. Dennis Schulist”,
“Username”: “Leopoldo_Corkery”,
“Email”: “Karley_Dach@jasper.info”,
“Address street”: “Norberto Crossing”,
“Address suite”: “Apt. 950”,
“Address city”: “South Christy”,
“Address zipcode”: “23505-1337”,
“Phone”: “1-477-935-8478 x6430”,
“Website”: “ola.org”,
“Company”: “Considine-Lockman”,
“Company catchPhrase”: “Synchronised bottom-line interface”,
“company bs”: “e-enable innovative applications”
},
{
“Number”: “7”,
“Name”: “Kurtis Weissnat”,
“Username”: “Elwyn.Skiles”,
“Email”: “Telly.Hoeger@billy.biz”,
“Address street”: “Rex Trail”,
“Address suite”: “Suite 280”,
“Address city”: “Howemouth”,
“Address zipcode”: “58804-1099”,
“Phone”: “210.067.6132”,
“Website”: “elvis.io”,
“Company”: “Johns Group”,
“Company catchPhrase”: “Configurable multimedia task-force”,
“company bs”: “generate enterprise e-tailers”
},
{
“Number”: “8”,
“Name”: “Nicholas Runolfsdottir V”,
“Username”: “Maxime_Nienow”,
“Email”: "Sherwood@rosamond.me",
“Address street”: “Ellsworth Summit”,
“Address suite”: “Suite 729”,
“Address city”: “Aliyaview”,
“Address zipcode”: “45169”,
“Phone”: “586.493.6943 x140”,
“Website”: “jacynthe.com”,
“Company”: “Abernathy Group”,
“Company catchPhrase”: “Implemented secondary concept”,
“company bs”: “e-enable extensible e-tailers”
},
{
“Number”: “9”,
“Name”: “Glenna Reichert”,
“Username”: “Delphine”,
“Email”: "Chaim_McDermott@dana.io",
“Address street”: “Dayna Park”,
“Address suite”: “Suite 449”,
“Address city”: “Bartholomebury”,
“Address zipcode”: “76495-3109”,
“Phone”: “(775)976-6794 x41206”,
“Website”: “conrad.com”,
“Company”: “Yost and Sons”,
“Company catchPhrase”: “Switchable contextually-based project”,
“company bs”: “aggregate real-time technologies”
},
{
“Number”: “10”,
“Name”: “Clementina DuBuque”,
“Username”: “Moriah.Stanton”,
“Email”: “Rey.Padberg@karina.biz”,
“Address street”: “Kattie Turnpike”,
“Address suite”: “Suite 198”,
“Address city”: “Lebsackbury”,
“Address zipcode”: “31428-2261”,
“Phone”: “024-648-3804”,
“Website”: “ambrose.net”,
“Company”: “Hoeger LLC”,
“Company catchPhrase”: “Centralized empowering task-force”,
“company bs”: “target end-to-end models”
}
]
],
“messages”: [
“Processing 1 results into 13 potential columns”,
"Processing Result with Data Root ",
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Processing 2”,
“Processing 3”,
“Processing 4”,
“Processing 5”,
“Processing 6”,
“Processing 7”,
“Processing 8”,
“Processing 9”,
“Consolidating entries”,
“There are 10 entries in total”
]
}
How do you concate the ‘address’ string with the ‘suite’ string etc…?
Can that be done by Xibo DataSet…?
Since the processed looks to have correct data when you test it, I’d expect the dataSet to be populated when the fetch remote dataset task runs and if the last sync date in the row with your dataset has current date.
If it’s not, then please enable CMS auditing, let the task run, collect logs and send them to me via private message.
1 Like
I also use get for my datasets.
At the top of your json data, I dont think I can see a data root - what have you specified as your data root?
It looks like it just goes straight into your array data. My JSON test URL results are as below :
Also at the bottom of your test JSON output, it says "Processing Result with Data Root " only - mine shows :
This all points towards a lack of a dataroot setting in my opinion…
I had to add an extra line in my Excel VBA to get that dataroot setting to output before it hits my array data so that Xibo can organise it into its columns…
Jimbo
Olá,
Você esta usando URL Json?
Se sim, pode me enviar para eu poder analisar melhor o problema
I think thats true, but in my case, If I specify the data root,
I get:
but without dataroot, I get:
I was at the thought that Xibo had already fetch the data,
but I couldn’t figure out why xibo does not populate the table.
Looking at your Json output, thats because ‘address’ isnt a dataroot - its contained in part of your array.
You need a line in your JSON file that goes inbetween ‘entries’ and ‘id’ which can then be declared as a Xibo dataroot in order to populate your columns correctly with all your array data. For this to work for me, I had to add an extra line in my VBA code that generates my Json file that writes a line (before it starts reading and writing from my excel data for my columns in Xibo) that simply says ‘Xibo’ (it can be anything you want as long as the dataroot matches within the Xibo dataset set up screen) and then that is my dataroot (as seen in my previous example of Json output). I did this by just adding an extra dictionary item into my VBA program and then saying write/output this dictionary item on a line before you start writing data from my excel spreadsheet.
If you need help with that, please let me know and I can give you the vba I had to use to create my dataroots (thats if youre using Excel VBA of course). I had exactly the same issue as you with my datasets until I did this.
Jimbo
Thanks for the reply, I think the Dataroot could be the issue. I’ll try and modify my JSON file…
Thanks again.
Im no expert but your test url output is mirroring the same symptoms as I had when I first started using datasets and Json files with no dataroot so its worth a try.
Jimbo