Hi Community!
I have a JSON payload that I want to get a specific piece of data from.
Here is the payload (with private information removed):
{
"id": "114106571079",
"recipient_id": "",
"collection_mode": "default",
"response_status": "completed",
"custom_value": "",
"first_name": "",
"last_name": "",
"email_address": "",
"ip_address": "",
"logic_path": {},
"metadata": {
"respondent": {
"user_agent": {
"type": "number",
"value": 000
},
"language": {
"type": "string",
"value": "en"
}
},
"contact": {}
},
"page_path": [],
"collector_id": "422326501",
"survey_id": "402862451",
"custom_variables": {},
"edit_url": "",
"analyze_url": "",
"total_time": 13,
"date_modified": "2022-08-31T01:44:54+00:00",
"date_created": "2022-08-31T01:44:41+00:00",
"href": "",
"questions": [
{
"id": "87023139",
"answers": [
{
"choice_id": "682016455",
"simple_text": "Integrated Assurance"
}
],
"family": "single_choice",
"subtype": "menu",
"heading": ""
},
{
"id": "87019079",
"answers": [
{
"choice_id": "682001918",
"row_id": "681994084",
"choice_metadata": {
"weight": "-10"
},
"simple_text": ""
},
{
"choice_id": "682001919",
"row_id": "681994085",
"choice_metadata": {
"weight": "-5"
},
"simple_text": ""
},
{
"choice_id": "682001921",
"row_id": "681994086",
"choice_metadata": {
"weight": "5"
},
"simple_text": ""
},
{
"choice_id": "682001920",
"row_id": "681994087",
"choice_metadata": {
"weight": "0"
},
"simple_text": ""
}
],
"family": "matrix",
"subtype": "rating",
"heading": ""
}
]
}
I am trying to get to the "answers/choice_id" of "questions/id"=87023139
How would I format this in xpath?
Thanks in advance!
