Hi, sorry for this newbie JSON extractor question but I am using the JASONExtractor transformer and I am trying to populate a column called 'Temperature' and populate it with the value, such as '50' shown below. My query is this: json["beds"].["Weather"].["Temperature"] but this and many, many other variations also do not work. Can someone please, please help me?
[
{
"id": 3009,
"beds": {
"Time": "Morning",
"Weather": {
"Temperature": 50
},
{
"id": 2969,
"code": "STPAL",
"name": "Acme Co."
}
]