hello all i have this below from the suiteQL, i want to take iban from this. how can i achieve this? could anyone please help me?
{"columns":null,"types":["STRING"],"results":[{"values":["{\"bic\":\"ABCDEFGH\",\"iban\":\"AB12121212121222\"}"]}],"metadataProvider":"SUITE_QL"}
n
Nathan L
04/17/2023, 2:44 PM
JSON.parse(test.results[0].values[0]).iban
Nathan L
04/17/2023, 2:45 PM
results.value is an array of stringified json objects. So if you loop through those and parse the results.values you get an object you can reference