Convert UTC date to date
How do you convert this date “2020-09-01T00:00:00.000” to this “20200901”?
Forum Discussion
Those square bracket is for visually stating you need to replace those with actual value without the bracket itself and you are missing the ampersand character between any variable you are passing.
Thanks for the clarification. it is working now.
Not sure if JSONPath itself natively support case-insensitive comparison or regex matching directly(considering that it only returns single value).
Case insensitivity in native JSONpath is based on the engine. The example from the first message in the thread :
[?(@.email =~/yomomma@notreal.com/i )] [?(/yomomma@notreal.com/i.test(@.email))]are from two of the libraries supported in jsonquerytoole.com (dchester and Goessner).
I have no idea which one Snaplogic is using, but I'm guessing neither of those as those examples don't work.
