Remote Dataset with multiple levels

Hi. I’m trying to get the remote data for this:

  {
   "entries": [
      {
         "Services": [
            {
               "ServiceNo": "522",
               "Operator": "MICHAEL",
               "NextAvailability": {
                  "IdentityCode": "85499",
                  "EstimatedAvailability": "2018-10-23T14:50:00+10:00",
                  "Type": "CC"
               },
               "NextAvailability": {
                  "IdentityCode": "85239",
                  "EstimatedAvailability": "2018-10-23T14:55:00+10:00",
                  "Type": "CC"

I was able to get the “ServiceNo” and “Operator” when I input Services as the data root.

The only difficulty I’m facing is getting the information under “NextAvailability”.

Any advice for such JSON format?

Thanks.

Services is the data root.

You’d then have columns for ServiceNo, Operator, NextAvailability.IdentifyCode, NextAvailaiblity.Type etc

That should work provided NextAvailability is unique within each Service definition.

Works like charm!! Xibo community and support at its best!

Thanks Alex.

1 Like

Oh and one more thing. Is it possible to split up the date and time from the EsitmatedAvailability using the remote dataset? Meaning to split them into different rows or something?

EstimatedAvailability": "2018-10-23T14:50:00+10:00"

I don’t believe so, but I think you could create a formula column that broke that date out in to whatever parts you wanted.