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”
]
}
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).