{
"created_at": "2025-02-24 09:20:30",
"status": "ACTIVE",
"new": "0",
"flag": "0",
"notes": "",
"updated_at": "2025-02-24 09:20:30",
"answers": {
"157": {
"name": "OK",
"order": "14",
"text": "Are you OK to answer this question?",
"type": "ctl_radio",
"answer": "No"
},
"158": {
"name": "submission",
"order": "1",
"sublabels": "{\"day\":\"Day\",\"hour\":\"Hour\",\"last\":\"Last\",\"litemode\":\"Date\",\"minutes\":\"Minutes\",\"month\":\"Month\",\"year\":\"Year\"}",
"text": "Submission",
"timeFormat": "24 Hour",
"type": "control_datetime"
},
"150": {
"name": "date",
"order": "5",
"sublabels": "{\"day\":\"Day\",\"month\":\"Month\",\"year\":\"Year\",\"last\":\"Last Name\",\"hour\":\"Hour\",\"minutes\":\"Minutes\",\"litemode\":\"Date\"}",
"text": "Date",
"timeFormat": "AM/PM",
"type": "control_datetime",
"answer": {
"month": "02",
"day": "23",
"year": "2025",
"datetime": "2025-02-23 00:00:00"
},
"FormattedDate": "02-23-2025"
}
}
}
xpath(
xml(json(concat('{"Root":{"Item":', outputs('Compose'), '}}'))),
'//Item/answers/*[text="Date"]/FormattedDate/text()'
)
split(split(trim(string(variables('JsonData'))),'"FormattedDate":"')[1], '"}')[0]
{"created_at":"2025-02-24 09:20:30","status":"ACTIVE","new":"0","flag":"0","notes":"","updated_at":"2025-02-24 09:20:30","answers":{"150":{"name":"date","order":"5","sublabels":"{\"day\":\"Day\",\"month\":\"Month\",\"year\":\"Year\",\"last\":\"Last Name\",\"hour\":\"Hour\",\"minutes\":\"Minutes\",\"litemode\":\"Date\"}","text":"Date","timeFormat":"AM/PM","type":"control_datetime","answer":{"month":"02","day":"23","year":"2025","datetime":"2025-02-23 00:00:00"},"FormattedDate":"02-23-2025"},"157":{"name":"OK","order":"14","text":"Are you OK to answer this question?","type":"ctl_radio","answer":"No"},"158":{"name":"submission","order":"1","sublabels":"{\"day\":\"Day\",\"hour\":\"Hour\",\"last\":\"Last\",\"litemode\":\"Date\",\"minutes\":\"Minutes\",\"month\":\"Month\",\"year\":\"Year\"}","text":"Submission","timeFormat":"24 Hour","type":"control_datetime"}}}
stampcoin
105
Michael E. Gernaey
84
Super User 2025 Season 1
David_MA
62
Super User 2025 Season 1