There are probably javascript solutions out there to more reliably convert JSON to csv for excel. The jsontosheet function takes in an Array, whereas your data argument is an Object. (Things would get a bit more complicated if you could not guarantee this. This code does assume that each object has the same elements in the same order. Use FME transformers like the JSONExtractor, JSONFragmenter, JSONFormatter, and JSONFlattener to do things like map the contents of JSON datasets into their. R=>console.log(Object.values(r).map( v=>`"$ is replaced with its value Upload your JSON files, set table style if needed, choose the save format type and click on Convert button.
HI entirely clear how you’re getting your data out from the response into Excel, but if you’re just copying and pasting you could try something like const res = pm.response.json() Ĭonst DMR = res & res
0 kommentar(er)
