Hello everyone,
Does anyone know how to retrieve (if possible) the date and price from the JSON data below? I would need the ‘C’ prices.
If the values were specified without quotation marks, it would be easy. But PP doesn’t understand it that way.
Thank you for your reply.
However, quotation marks are not the issue here. All my JSON sources use quotation marks, and they work perfectly in PP (working example below). Perhaps it is just Firefox that adds these quotation marks for convenience. I think the problem is with the date structure (date is the actual list instead of a sub-value).
Correct, PP will also convert Strings into numbers if needed.
PP is using the Jayway JSONPath library. I do not think it is possible to formulate a query to extract the dates with a JSONPath query if they are at the root of the object. $~ is not supported. If you want to play around, here is an online evaluator: https://jsonpath.fly.dev
Uups.
I have misinterpreted Json mit Komma als Dezimaltrenner - #2 by Rafa
1 Like