Remote Datasets Not Updating

Hi
I’m trying to work with remote datasets. I’ve setup some test data as per one of the examples on here. I’ve created some columns and under test data URL the results seem to match up and the data pulls through:

{
“entries”: [
{
“base”: “EUR”,
“date”: “2017-12-22”,
“rates”: {
“GBP”: 0.88568,
“THB”: 38.83,
“USD”: 1.1853
}
}
],
“number”: 1,
“processed”: [
[
{
“Col1”: “GBP”,
“Col2”: “0.88568”
},
{
“Col1”: “THB”,
“Col2”: “38.83”
},
{
“Col1”: “USD”,
“Col2”: “1.1853”
}
]
],
“messages”: [
“Processing 1 results into 2 potential columns”,
“Processing Result with Data Root rates”,
“DataRoot is an object”,
“Processing as Multiple Rows”,
“Processing GBP”,
“Processing THB”,
“Processing USD”,
“Consolidating entries”,
“There are 3 entries in total”
]
}

However, no data ever pulls through in view data.

And the task fetch remote dataset never shows a successful last status.

Could someone please advise where I’m going wrong? I can’t see any issues in the logs.

Thanks

Could you confirm for me the CMS version you have?
also is it docker or manual installation?

It seems a bit odd for the Last Duration to be 0.

On the DataSets page, do you have a correct date in Last Sync column next to your remote dataSet?
What do you have in your remote dataSet for Refresh and Truncate DataSet ?

Could you show us a screenshot of the Edit column form to double check that it is correctly set there (especially the column type and remote data path)?

You may also want to go through Report Fault Wizard on Report Fault page ie enable auditing, recreate the issue (let the task fetch remote datasets run and finish), collect the logs - you can send the logs to me via private message (you’ll need to upload it somewhere and share the link with me via pm).

Hi Peter,
We’re running version 1.8.7 and its a manual installation. On the dataset page the last sync is blank. Refresh and Truncate settings:

Example edit column:

I’ll also send the details/logs via pm.

Thanks for your help.