First post, so hi to everybody
I'm trying to display a mysql result to a chart and for this using JSONata in a change note to rename the key fields of the resulting array to X/Y. Unfortunately one field of my sql return set is named MIN(timeStamp) and I'm not able to find the right syntax for replacing it. If I only have timeStamp as key it works. Below screenshots should help to understand my situation:
Working (w/o MIN in key field of the array):
Not working (w MIN in key field of the array):
If I change line 5 to
"x": MIN(timeStamp), I get an Attempted to invoke a non-function error.
Is there an easy way to archive my goal?