I have this json:
{
"data": [
{
"id": 1,
"date": "2018-10-10 13:11:21",
"title": "Test 1"
},
{
"id": 2,
"date": "2018-10-11 03:04:41",
"title": "Test 2"
},
{
"id": 3,
"date": "2018-10-12 06:51:21",
"title": "Test 3"
}
]
}
And I set date column like this:
But when I try to test data I get mydate field set to null:
{
"entries": [
{
"data": [
{
"id": 1,
"date": "2018-10-10 13:16:08",
"title": "Test 1"
},
{
"id": 2,
"date": "11/10/2018 03:09:28",
"title": "Test 2"
},
{
"id": 3,
"date": "2018-10-12 06:56:08",
"title": "Test 3"
}
]
}
],
"number": 1,
"processed": [
[
{
"myid": 1,
"mydate": null,
"mytitle": "Test 1"
},
{
"myid": 2,
"mydate": null,
"mytitle": "Test 2"
},
{
"myid": 3,
"mydate": null,
"mytitle": "Test 3"
}
]
],
"messages": [
"Processing 1 results into 3 potential columns",
"Processing Result with Data Root data",
"DataRoot is an array",
"Processing 0",
"Processing 1",
"Processing 2",
"Consolidating entries",
"There are 3 entries in total"
]
}
I tried to change the format of the dates but I get always null