shuo
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Convert JSON array to key-value object array with a fixed key name
Hi, the input is an array of numbers: [“324”,“1209”,“4849”,“2”] then i want to transform them into an array like below: [ {“number”:“324”}, {“number”:“1209”}, {“number”:“4849”}, {“number”:“2”} ] I tried reduce() and also tried convert it to an object and then replace the key, but seems no luck for both. Can anyone help with this transformation? thanks!How to use proxy to setup a sftp connection
file writer snap provides function of sftp, but I don’t see it supports proxy(socks5) in-between? Another way I can think of is to use the script snap and python script to connect, but not sure how to do it? Could anyone give some hint? either an alternaive snap that support proxy(socks5) for sftp or a python script to use the proxy(socks5) for sftp connection? thank you !!1.4KViews0likes0CommentsHow to cite entries in an array of JSON (position of entries is not fixed)
Hi, Below is just an example JSON: { "entity": { "entries": [ { "ID": "1", "Pipeline": "Pipeline_Completed", "Numbers": "10" }, { "ID": "3", "Pipeline": "Pipeline_Failed", "Numbers": "1" }, { "ID": "10", "Pipeline": "Pipeline_Stopped", "Numbers": "3" } ], "duration": 1074, "create_time": "2010-10-10" } } Constraints: the position of entries is not fixed, Say this time we have pipeline_Failed, so Pipeline_Stopped is the index[2] of the array; but next time if we don’t have pipeline_Failed, then Pipeline_Stopped will have the index[1]. What i did(step1): jsonPath($, "$entity.entries[*].Pipeline").indexOf("Pipeline_Stopped") to retrive the index, and then use it to get the Numbers(step2): jsonPath($, "$entity.entries[**jsonPath($, "$entity.entries[*].Pipeline").indexOf("Pipeline_Stopped")**].Numbers") I replaced the [*] with the index I got from the step 1 But, in the mapper, step2 expression gives me error. How to fix that, or Do we have an alternative way to do this? Also, if there is no Pipeline_Stopped, where indexOf will return -1, will it give error or just null value?(null value is good, just don’t want to get an error in the snap) Thank you so much!!