Solved
Converting an array to a JSON payload
Hello all, I need to convert an array of ID values into a JSON payload, and I cannot find any array function that can iterate the values of the list to generate what I need. My array of IDs looks l...
Forum Discussion
Hi Surendar,
Assuming this is just a CSV, I plugged in your example data into a CSV generator, followed by a ‘group by N’ snap, which will group csv docs(up to 10,000) into a single doc assigned to any key you want, I chose ‘group’ for my key.
Then that will flow into a mapper with the expression as : “$.group.map(val => parseFloat(val.value))” with target field as ‘amount’ and you will be left with a list of all your values.
If you don’t care about the value being a string, you can leave out the parseFloat() call in the expression.
Hope this achieves your goal
