Hello,
I’m having trouble with a remote dataset in Json format.
The ‘test data url’ gives a list and processed data, but the table is empty.
Did a ‘Fetch Remote DataSets’ task and waited for several hours. But the table shows nothing. I use version 1.8.11.
I would expect that the ‘test data url’ values in processed would be the list values in the table.
What could be wrong?
The output of the 'test data url" is:
{
“entries”: [
{
“condor”: [
{
“location”: “warehouse 1”,
“units_power”: “kWh”,
“Recent_energy”: “151800.36”,
“Dag_energy”: “151676.74”,
“Jaar_energy”: “139652.83”,
“units_volume”: “liters”,
“Recent_volume”: “2473.00”,
“Dag_volume”: “2473.00”,
“Jaar_volume”: “2188.69”
},
{
“location”: “warehouse 2”,
“units_power”: “kWh”,
“Recent_energy”: “103580.04”,
“Dag_energy”: “103309.26”,
“Jaar_energy”: “94388.97”,
“units_volume”: “liters”,
“Recent_volume”: “1629.00”,
“Dag_volume”: “1608.62”,
“Jaar_volume”: “1464.38”
}
]
}
],
“number”: 1,
“processed”: [
[
{
“Recent”: “151800.36”,
“Dag”: “151676.74”,
“Jaar”: “139652.83”
},
{
“Recent”: “103580.04”,
“Dag”: “103309.26”,
“Jaar”: “94388.97”
}
]
],
“messages”: [
“Processing 1 results into 3 potential columns”,
“Processing Result with Data Root condor”,
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Consolidating entries”,
“There are 2 entries in total”
]
}