Remote json dataset

[Wietse]

Hello all,

I just can’t get the remote datasets working. For testing i made a very simple json.

{
    "exam1": "wiscat",
    "exam2": "remindo",
    "exam3": "htaal"
}

And this is the “Test data URL” result:

{
   "entries": [
      {
         "exam1": "wiscat",
         "exam2": "remindo",
         "exam3": "htaal"
      }
   ],
   "number": 3,
   "isEligibleToTruncate": true,
   "processed": [
      [
         [],
         [],
         []
      ]
   ],
   "messages": [
      "Processing 1 results into 3 potential columns",
      "Processing Result with Data Root ",
      "DataRoot is an object",
      "Processing as Multiple Rows",
      "Processing exam1",
      "Processing exam2",
      "Processing exam3",
      "Consolidating entries",
      "There are 3 entries in total"
   ]
}

If i manually run the task “Fetch Remote DataSets” it successfully finishes and no errors in the logs.

I tried making 2 colums, but whatever i do there’s just never data in the table.

Could someone help me with this, i think it’s something small.

Wietse

[Wietse]

just for information: i also tried with only 1 or 2 columns but i had the same issue.

[Frazer]

Hi @Wietse , you need to set the Column Type to ‘Remote’ and specify the ‘Remote Data Path’.

For example:

[Wietse]

Hi,

That’s what i thought but this is not available:

I already updatet to the latest version: 4.0.15

[Wietse]

It seems that Column Type “Remote” is removed from the UI. There’s only “Value” and “Formula”.

[Jon_Knowles]

If dataset is not remote, type remote won’t show up.

[Wietse]

of course i’m using dataset remote otherwise i can’t use json.

I then click on “view Columns” → “Add Column”, Colum Type Remote is not there, just value and formula.

Could it be a bug in the interface?

[Wietse]

This is the screenshot in the next add column screen:

[Wietse]

I did a clean docker install on a test server and immediately the Remote column is there. The issue is our current installation which is the same install and version. Not sure how fix the current installation yet without a reinstall, we have a pretty big environment running.