Remote Dataset - Trouble configuring Remote Data Path

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é

Hi,

no one ever worked with remote datasets or do you need more information?

Wrong forum? Should I move this thread to general?

Any help would be appreciated.

best regards,
André

Hello,

Do you already solve the problem? I think i have same problem as yours.

Thanks

Hello riopangeran,

unfortenately not. Have you found a solution?

Yes, but i use API insted , not this remote data path, i have tried everything, but still i can’t found the answer, i think it bugs for this version.

I push data using API , then use cronjob to make sure the data will be pushed as schedule

Hello!

I have exactly the same problem. I don’t know how to write the Remote Data Path.

What do you mean by to use API ??
How did you do exactly?

Thank you!

Let me explain it on the example posted by @git_andre - also I apologise for the delay in our reply.

Ok, let’s get to it, as mentioned, we will use the json posted in the very first post in this topic.

DataSet configuration:

Data root is rows

and that’s pretty much it there, now for columns

We will want 4 columns, the problematic part ie remote data path, in this case that would be like this:

remote data path for other columns in this example would be:
ownerName then aptDate and last but not least aptNotes

with that prepared, we can hit the Test Data URL button, we’d expect to see the following as a result
first the entries (ie our .json data), then processed which should be like this:

"processed": [
      [
         {
            "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"
         }
      ]
   ],
1 Like

@Peter : Thank you for the answer.

I have some data in “processed” when I click on Test Data URL, but no data in the table. It can take a few times?

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.

:cry:
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!!! :roll_eyes:

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 :

@Peter : Thx a lot, works like I charm.

1 Like

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…?