Sahil
Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Length in using expression
Hi, I have a scenario where I need to filter out json based on length of a particular element. so in Source if json is like this:- [ { “SaleDatas”: { “DataId”: “”, “AmazonDataId”: “Sale.purchase_4”, “AmazonDataName”: “”, “Name”: “Sale.purchase_4”, “DataType”: “”, “Value”: “Windows 11 Pro”, “AmazonDataIdf”: “” } }, { “SaleDatas”: { “DataId”: “”, “AmazonDataId”: “2036”, “AmazonDataName”: “”, “Name”: “colour_name”, “DataType”: “”, “Value”: “Platinum”, “AmazonDataIdf”: “” } } ] in target I need only :- [ { “SaleDatas”: { “DataId”: “”, “AmazonDataId”: “2036”, “AmazonDataName”: “”, “Name”: “supplier_colour_name”, “DataType”: “”, “Value”: “Platinum”, “AmazonDataIdf”: “” } } ] I need a filter snaps expession either using length or numeric of “AmazonDataId”. i.e if AmazonDataId.length==‘4’ then only pass through filter snaps.Re: Join 2 arrays
Hi,Thank you for the pipeline. There are 2 issues in the pipeline:- If we use jsonPath($, “$ContentObjectProperty[*][‘$’]”).filter(x=>x!='feature ') it picks all the content even from shortText and longText. We need to pick only Name. 2)I see an error at JSON Splitter3 Failure: Json Splitter expects a list, Reason: Found an object of type class java.util.LinkedHashMap, Resolution: The path $.ObjectRef needs to refer to a list in the incoming document3.4KViews1like8CommentsJoin 2 arrays
I have 2 different arrays, one having id, header and another having id,name. Need to join these 2 arrays and get an output file of id,header,name. I need json splitter json path, I have just for id which is jsonPath($, “id[*]”). How do I include both id and header. File.txt (4.2 KB)Solved13KViews1like15Comments