I can get the format in to 2024-05-02 20:00:00 easily enough.
However the source app outputs in local time, which as I am in the UK is currently +1 UTC. That I can’t change.
It does generate the UTC time format, however it doesn’t label the column, so I cannot get it in to JSON easily. I even asked ChatGPT to have a go and it failed as well, so I am stuck with converting the separate local time fields in to a time stamp.
Further update (10 mins later), I have now reformatted the time to this as a test.
datetime: 2024-05-02T20:00:00+00:00
However the same error is being returned, and of course it is an hour out as I am not on UTC.