Remote json data path not showing up in dataset


#1

Hello, i am trying to use the remote dataset feature to get images from Airtable.
I have set the dataroot to “records” and the image columns to “fields.Anonnsbild.0.url” and “fields.Mäklarbilder.0.url” respectively.

I assume that the “processed” entry in the response is the columns picking up the data from the paths, though nothing shows up in the data set “data”.

I have the dataset connected to a layout which is running on a display, i’ve tried manually refreshing the “fetch remote data” task, i’ve cleared the device’s cache.

Have I configured something wrong?

{
   "entries": [
      {
         "records": [
            {
               "id": "recVMx8PKhycT5AKq",
               "fields": {
                  "Adress": "Aktervägen 3",
                  "Annonsbild": [
                     {
                        "id": "attLp5f2J2h1hXGmy",
                        "url": "https://dl.airtable.com/.attachments/2173476c7d52564f89ec8776b7a502d8/2ae7d8ad/Akt-page-001.jpg",
                        "filename": "Akt-page-001.jpg",
                        "size": 523328,
                        "type": "image/jpeg",
                        "thumbnails": {
                           "small": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/ba5ce30f058d030fd4fa6fb73f28317f/c8659328",
                              "width": 51,
                              "height": 36
                           },
                           "large": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/cdb0648d7adfde198a768b8e1adad4ad/e0b7606d",
                              "width": 724,
                              "height": 512
                           },
                           "full": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/a7e4ddeef5e39a5ed5b9fd3853774a04/3c557ebc",
                              "width": 2480,
                              "height": 1754
                           }
                        }
                     }
                  ],
                  "Mäklare": "Andreas Stiglund 2",
                  "Bildposition": "Höger",
                  "Mäklarbilder": [
                     {
                        "id": "attm02qdaMgfRymXZ",
                        "url": "https://dl.airtable.com/G3B3QVuTTPuhKDRygoeg_AndreasStiglund.jpg",
                        "filename": "AndreasStiglund.jpg",
                        "size": 32529,
                        "type": "image/jpeg",
                        "thumbnails": {
                           "small": {
                              "url": "https://dl.airtable.com/5gbE0OPkQBuAqoTss2H5_small_AndreasStiglund.jpg",
                              "width": 36,
                              "height": 36
                           },
                           "large": {
                              "url": "https://dl.airtable.com/f47fH5vWSa3ik7KdFj9s_large_AndreasStiglund.jpg",
                              "width": 242,
                              "height": 242
                           },
                           "full": {
                              "url": "https://dl.airtable.com/O4b7tU8RPengrAyhWVl3_full_AndreasStiglund.jpg",
                              "width": 242,
                              "height": 242
                           }
                        }
                     }
                  ]
               },
               "createdTime": "2018-10-26T10:37:13.000Z"
            },
            {
               "id": "rec6l0sTFB6WZgZPe",
               "fields": {
                  "Adress": "Fritidshuskampanj",
                  "Annonsbild": [
                     {
                        "id": "att529Vy9ZNfvJGB2",
                        "url": "https://dl.airtable.com/.attachments/f09355fd44ef444d6148ad76e972bd65/85b23ee7/FByra_1902_fritidshus_webslinga_1920x1080_fri_s1.jpg",
                        "filename": "FByra_1902_fritidshus_webslinga_1920x1080_fri_s (1).jpg",
                        "size": 1079437,
                        "type": "image/jpeg",
                        "thumbnails": {
                           "small": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/4eb219237fe06711e246057507eb612f/82d019d1",
                              "width": 64,
                              "height": 36
                           },
                           "large": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/f86e5aff6d268cd8ce39d702cd8428d6/c1db8629",
                              "width": 910,
                              "height": 512
                           },
                           "full": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/3552e60bb7a8fc71040d1dd8d6f27da8/0269710f",
                              "width": 1920,
                              "height": 1080
                           }
                        }
                     }
                  ]
               },
               "createdTime": "2019-03-06T14:29:13.000Z"
            },
            {
               "id": "recJfdWnKo9diiwL6",
               "fields": {
                  "Adress": "Femöre",
                  "Annonsbild": [
                     {
                        "id": "attyemI1cpPHUZegV",
                        "url": "https://dl.airtable.com/.attachments/66036aaa1fcf72edf0169c207c62878e/0030407b/Femreair-page-001.jpg",
                        "filename": "Femöre air-page-001.jpg",
                        "size": 596735,
                        "type": "image/jpeg",
                        "thumbnails": {
                           "small": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/40e864f824fe74b529cf118dc491079b/b81a5e4d",
                              "width": 51,
                              "height": 36
                           },
                           "large": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/05cef37d8e7f8629ec783b3680ef4c90/fe8b85c7",
                              "width": 724,
                              "height": 512
                           },
                           "full": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/adca455a76fed487b7d9a53d470b8784/1828966c",
                              "width": 3000,
                              "height": 3000
                           }
                        }
                     }
                  ],
                  "Mäklare": "Anders Wallén 1",
                  "Bildposition": "Höger",
                  "Mäklarbilder": [
                     {
                        "id": "attB1KK4ks7cnb7RH",
                        "url": "https://dl.airtable.com/.attachments/c67c09d4a3ce9a8bc630a1a94edaa06a/365dc26d/AndersWallen.jpg",
                        "filename": "AndersWallen.jpg",
                        "size": 24339,
                        "type": "image/jpeg",
                        "thumbnails": {
                           "small": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/474f34cc45fd08b479a6241cfa79ec36/5f04feec",
                              "width": 36,
                              "height": 36
                           },
                           "large": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/6a78f55a5b4be67f5b01cb722dfad905/015ae589",
                              "width": 242,
                              "height": 242
                           },
                           "full": {
                              "url": "https://dl.airtable.com/.attachmentThumbnails/c37d122f50efd9421b0f7222d7790b38/54886746",
                              "width": 3000,
                              "height": 3000
                           }
                        }
                     }
                  ]
               },
               "createdTime": "2019-04-04T09:24:52.000Z"
            }
         ]
      }
   ],
   "number": 1,
   "processed": [
      [
         {
            "Annonsbild": "https://dl.airtable.com/.attachments/2173476c7d52564f89ec8776b7a502d8/2ae7d8ad/Akt-page-001.jpg",
            "Maklare": "https://dl.airtable.com/G3B3QVuTTPuhKDRygoeg_AndreasStiglund.jpg"
         },
         {
            "Annonsbild": "https://dl.airtable.com/.attachments/f09355fd44ef444d6148ad76e972bd65/85b23ee7/FByra_1902_fritidshus_webslinga_1920x1080_fri_s1.jpg"
         },
         {
            "Annonsbild": "https://dl.airtable.com/.attachments/66036aaa1fcf72edf0169c207c62878e/0030407b/Femreair-page-001.jpg",
            "Maklare": "https://dl.airtable.com/.attachments/c67c09d4a3ce9a8bc630a1a94edaa06a/365dc26d/AndersWallen.jpg"
         }
      ]
   ],
   "messages": [
      "Processing 1 results into 2 potential columns",
      "Processing Result with Data Root records",
      "DataRoot is an array",
      "Processing 0",
      "Processing 1",
      "Processing 2",
      "Consolidating entries",
      "There are 3 entries in total"
   ]
}

#2

I’ve recreated the dataSet with local .json file created from your post.

Then I’ve ran the fetch remote dataset task and I can see the results in DataSet data:

The above seems to be consistent with what you’ve got in Processed part of the response to test remote dataSet in your post.

Now, if you don’t see the data in DataSet at all, even though the test looks to be correct, I have couple of questions.

What’s you CMS version and is it docker based installation or not?
If it’s not docker based, is the XTR correctly configured? (it’s pre-configured in docker installations).

About the dataSet itself:
1 - On the DataSet page, do you see recent date in Last Sync column in the row with your remote dataSet?
2 - On Edit dataSet form, what did you set the refresh to?
3 - Which datatype are your columns?

Once the dataSet data will be in the DataSet, then it should also be in visible in layout designer and players running this layout.


#3

The CMS version is 2.0.3 on Docker.

Last sync was 14:30 CEST (15 minutes ago).

The refresh selector is set to “Constantly”.

The datatypes are “External Image”.