Abhishek_Soni37
Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: To convert Json to XML with multiple attribute elements with ids and values
Hi plviji , I created a sample pipeline with what you mentioned and I invoked this pipeline in POSTMAN. The result XML doesn't have element=3d in any tags. Could it be possible that it is getting appended in the target system? Below is the response from Postman: XML Generator: Mapper Expression: Make sure the output view of mapper is binary. Hope this helps. Thanks, AbhishekRe: Converting Snowflake Lookup results into an array
Hi jfpelletier , I did the below to get the UIDs in an array, maybe you fine-tune it a bit more to reduce the snaps: Input: [ {"UID":"UID1"}, {"UID":"UID2"}, {"UID":"UID3"}, {"UID":"UID4"} ] I used a mapper snap after this and since we want to get all documents in a single array, I added the below expression to extend the UID doc with a common value that I can use later in group by fields snap to group all the records. $.extend({"group":"1"}) The output of this mapper looks like this: Later I added a group by fields snap and grouped the input based on the group tag: The output will be an array of all documents where the group has same value, in our case it'll be the same for all records of UIDs. Added another mapper with the below expression: jsonPath($, "group[*].UID") The final o/p looks like this: Hope this helps. Cheers, AbhishekRe: Using list of values in Filter snap
Hi darshthakkar , I used the dummy data below to create a working solution. Input: [ {"txt":"abc"}, {"txt":"efg"}, {"txt":"c - abc"}, {"txt":"c - xyz"} ] In the pipeline properties, I've defined a parameter filterValues that will contain the strings based on which you want to filter the records. Use the below expression in the filter snap: JSON.parse(_filterValues).map(x => $txt.contains(x)).filter(y => y == true).length == 1 The result based on the input above looks like this: The record that doesn't have the matching string defined in the filterValues parameter will be omitted. Hope this helps! Cheers😉, AbhishekRe: How to Convert Timestamp from 1 min to 5 min
Hi @vaidyarm If you just want to filter the records where time is multiple of 5, then may be you can use below expression the filter snap: Date.parse($inputDate.substring(0,19)).getMinutes() != 0 && Date.parse($inputDate.substring(0,19)).getMinutes() % 5 == 0 Output will look like this: I hope this helps 🙂
