Pedro Silva
05/07/2021, 4:10 PM"fromDateTime(JSONPATHSTRING(result,'$.AudioLength','00:00:00.000'), 'HH:mm:ss.SSS')"
where the transformed field is of type Long
?Neha Pawar
Pedro Silva
05/10/2021, 1:52 PM"transformFunction": "fromDateTime(Groovy({(result =~ /([aA]udio[lL]ength[^0-9.]*)([0-9:.]*)/)[0][2]}, result), 'HH:mm:ss.SSSSSSS')"
This is retrieving a field from a json string (which may have similar but distinct keys (audioLength or AudioLength) and then parsing that string into milliseconds since epoch. I am unable to define this transformation in the UI, getting the following message:Pedro Silva
05/10/2021, 1:52 PMPedro Silva
05/10/2021, 1:59 PM"transformFunction": "Groovy({(result =~ /([aA]udio[lL]ength[^0-9.]*)([0-9:.]*)/)[0][2]}, result)"
Seems to work though.