Hi all, I have a field in QS called priceitems of string datatype that can also take NULL’s. There are records that priceitems have values like [{“id”:27,“amount”:6.50,“explainer”:null,“quantity”:1.00000000,“quantityunit”:0,“total”:6.50,“billable”:false,“name”:“Catering”,“taxable”:false,“servicecos…

@Fotis_flex , In the dataset preparation mode, the parse json does work as @imaitri explained by using the dot notation. [image] calculation ifelse(isNull({jarry}),'no value found', parseJson({jarry},"$.0.name")) Kind regards, Koushik

hi Fotis_flex, The syntax for parsing JSON in Quick Sight calculated fields uses dot notation rather than square brackets. Try updating your calculated field to: isNull({priceitems}), null, parseJson({priceitems}, ‘0.name’) This uses the dot notation ‘0.name’ rather than ‘[0].name’ to extract the n…

Hi @imaitri . No this still crashes loading the dataset. It does not work. I wonder if the reason is that the values of the field priceitems uses [ ] initially instead of { }. According to documentation the field should start with { } instead of [ ]. And I can’t find a way to extract the key val…

How to extract key value from a .json array?

Q&A

Fotis_flex April 2, 2024, 9:34am 4

Hello @imaitri Do you perhaps have any more ideas regarding my above comment? Thx

How to Parse JSON Column and Extract Specific convertedValue in Amazon Quick Sight

Topic		Replies	Views
parseJSON returns only the first json key value from an array Q&A data-source , quick-sight , calculations	5	1604	May 11, 2023
Parsing json and assoicating it to the row Q&A admin , quick-sight	9	145	December 11, 2024
parseJson() function referencing a JSON key with space Q&A error , quick-sight , calculations	5	1684	January 24, 2023
How to Parse JSON Column and Extract Specific convertedValue in Amazon Quick Sight Q&A quick-sight , dataset , calculations , Business-Intelligence-Engineer	3	134	September 19, 2025
What's parsejson syntax for parsing TA key value pair Q&A quick-sight	3	319	May 11, 2023

How to extract key value from a .json array?

Related topics