Forum Discussion

Dhivya_Aroma1's avatar
Dhivya_Aroma1
New Contributor III
6 years ago

Can we read or write a file from our local machine? If yes, how can we achieve it?

I have a csv file in my local, can I read it using File Reader / Directory Browser. When I tried with the below settings in Directory Browser I get this error { “error”:“Error browsing t...
tstack's avatar
tstack
Former Employee
8 years ago
Copy LinkReport

You can use the mapValues() method to iterate over the values of the object and perform the transformation. The result of that operation is still an object, so you’ll need to use the jsonPath() function with a path of ‘$*’ to get the values of the object into an array. So, the following should do what you want to create the “custom_fields” property:

jsonPath($.mapValues((value, key) => { value: value, id: parseInt(key.match(/\d+/)[0]) }), "$*")