JSON path and case insensitive search
I'm having issues trying to find all instances that match a particular email address using JSONPath. The example below is just an array of email objects, but the real data is an array or personnell ...
Forum Discussion
Find the attached sample pipeline. It uses array filter function for filtering the elements.
Hope it will helps.
While this would be a functional workaround, I was hoping to perform the whole operation through a purely jsonPath query.
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.
