Breadcrumbs

API example - filter responses by 3D Matrix values

API example on how to filter the form responses by 3D Matrix question type values

Question type: 3D Matrix

image-20230324-105253.png
image-20230324-105259.png


Request

curl --location 'https://app.form.com/gw/v3/results/list?formId=41659267&limit=100&offset=0' \
--header 'Authorization: Bearer ea924012-3b17-49e9-b820-74b06e9e799b' \
--header 'Content-Type: application/json' \
--data '{
   "items":[
      {
         "operator":"IN",
         "sourceItemKey":"Q96345911.A314750265.C3145151",
         "operand":{
            "selected":[
                "Q96345911.A314750265.C3145151.O0"
            ]  
         }
      }
   ]
}'


Response

{
    "results": [
        {
            "respondentId": 1395860559,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "James"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "10/10/1983"
                        },
                        {
                            "answerId": 314750706,
                            "answerType": "SINGLE_LINE",
                            "value": "2015"
                        }
                    ]
                },
                {
                    "questionId": 96344945,
                    "questionType": "PICK_ONE_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314751797,
                            "answerType": "PICK_ONE"
                        }
                    ]
                },
                {
                    "questionId": 96342791,
                    "questionType": "CHECK_ALL_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314750727,
                            "answerType": "CHECK_ALL"
                        },
                        {
                            "answerId": 314750728,
                            "answerType": "CHECK_ALL"
                        }
                    ]
                },
                {
                    "questionId": 96343988,
                    "questionType": "DROPDOWN",
                    "answers": [
                        {
                            "answerId": 314752894,
                            "answerType": "DROPDOWN",
                            "value": "100 - 200 $"
                        }
                    ]
                },
                {
                    "questionId": 96342794,
                    "questionType": "LIST_BOX",
                    "answers": [
                        {
                            "answerId": 314750736,
                            "answerType": "LIST_BOX",
                            "value": "Sunday"
                        },
                        {
                            "answerId": 314750737,
                            "answerType": "LIST_BOX",
                            "value": "Monday"
                        },
                        {
                            "answerId": 314750739,
                            "answerType": "LIST_BOX",
                            "value": "Wednesday"
                        }
                    ]
                },
                {
                    "questionId": 96343991,
                    "questionType": "MULTI_LINE",
                    "answers": [
                        {
                            "answerId": 314752898,
                            "answerType": "MULTI_LINE"
                        }
                    ]
                },
                {
                    "questionId": 96344953,
                    "questionType": "RATE_DIFFERENT",
                    "answers": [
                        {
                            "answerId": 314751828,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751829,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751830,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145124
                        }
                    ]
                },
                {
                    "questionId": 96345911,
                    "questionType": "MATRIX_3D",
                    "answers": [
                        {
                            "answerId": 314750261,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "smartphoneSmartphones"
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "washing machine, refrigerator"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "spoons, plates"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "wheels, filers"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        }
                    ]
                },
                {
                    "questionId": 96344957,
                    "questionType": "OBJECT_LOOKUP",
                    "answers": [
                        {
                            "answerId": 314751835,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403719"
                        },
                        {
                            "answerId": 314751836,
                            "answerType": "SINGLE_LINE",
                            "value": "Tools and auto goods"
                        },
                        {
                            "answerId": 314751837,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403719"
                        },
                        {
                            "answerId": 314751838,
                            "answerType": "SINGLE_LINE",
                            "value": "Tools and auto goods"
                        }
                    ]
                }
            ]
        },
        {
            "respondentId": 1395862205,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "Josephina"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "10/22/1986"
                        },
                        {
                            "answerId": 314750706,
                            "answerType": "SINGLE_LINE",
                            "value": "2015"
                        }
                    ]
                },
                {
                    "questionId": 96344945,
                    "questionType": "PICK_ONE_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314751797,
                            "answerType": "PICK_ONE"
                        }
                    ]
                },
                {
                    "questionId": 96342791,
                    "questionType": "CHECK_ALL_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314750724,
                            "answerType": "CHECK_ALL"
                        },
                        {
                            "answerId": 314750726,
                            "answerType": "CHECK_ALL"
                        },
                        {
                            "answerId": 314750728,
                            "answerType": "CHECK_ALL"
                        }
                    ]
                },
                {
                    "questionId": 96343988,
                    "questionType": "DROPDOWN",
                    "answers": [
                        {
                            "answerId": 314752895,
                            "answerType": "DROPDOWN",
                            "value": "200 - 500 $"
                        }
                    ]
                },
                {
                    "questionId": 96342794,
                    "questionType": "LIST_BOX",
                    "answers": [
                        {
                            "answerId": 314750736,
                            "answerType": "LIST_BOX",
                            "value": "Sunday"
                        },
                        {
                            "answerId": 314750740,
                            "answerType": "LIST_BOX",
                            "value": "Thursdays"
                        }
                    ]
                },
                {
                    "questionId": 96344953,
                    "questionType": "RATE_DIFFERENT",
                    "answers": [
                        {
                            "answerId": 314751826,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751827,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751828,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751829,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751830,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        }
                    ]
                },
                {
                    "questionId": 96345911,
                    "questionType": "MATRIX_3D",
                    "answers": [
                        {
                            "answerId": 314750261,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "smartphone"
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "washing machine"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "filers"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        }
                    ]
                },
                {
                    "questionId": 96344957,
                    "questionType": "OBJECT_LOOKUP",
                    "answers": [
                        {
                            "answerId": 314751835,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403720"
                        },
                        {
                            "answerId": 314751836,
                            "answerType": "SINGLE_LINE",
                            "value": "Smartphones, TV and electronics"
                        },
                        {
                            "answerId": 314751837,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403720"
                        },
                        {
                            "answerId": 314751838,
                            "answerType": "SINGLE_LINE",
                            "value": "Smartphones, TV and electronics"
                        }
                    ]
                }
            ]
        },
        {
            "respondentId": 1395860668,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "Bob"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "03/01/2005"
                        },
                        {
                            "answerId": 314750706,
                            "answerType": "SINGLE_LINE",
                            "value": "2020"
                        }
                    ]
                },
                {
                    "questionId": 96344945,
                    "questionType": "PICK_ONE_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314751796,
                            "answerType": "PICK_ONE"
                        }
                    ]
                },
                {
                    "questionId": 96342791,
                    "questionType": "CHECK_ALL_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314750724,
                            "answerType": "CHECK_ALL"
                        },
                        {
                            "answerId": 314750725,
                            "answerType": "CHECK_ALL"
                        }
                    ]
                },
                {
                    "questionId": 96343988,
                    "questionType": "DROPDOWN",
                    "answers": [
                        {
                            "answerId": 314752894,
                            "answerType": "DROPDOWN",
                            "value": "100 - 200 $"
                        }
                    ]
                },
                {
                    "questionId": 96342794,
                    "questionType": "LIST_BOX",
                    "answers": [
                        {
                            "answerId": 314750736,
                            "answerType": "LIST_BOX",
                            "value": "Sunday"
                        },
                        {
                            "answerId": 314750742,
                            "answerType": "LIST_BOX",
                            "value": "Saturday"
                        }
                    ]
                },
                {
                    "questionId": 96343991,
                    "questionType": "MULTI_LINE",
                    "answers": [
                        {
                            "answerId": 314752898,
                            "answerType": "MULTI_LINE"
                        }
                    ]
                },
                {
                    "questionId": 96344953,
                    "questionType": "RATE_DIFFERENT",
                    "answers": [
                        {
                            "answerId": 314751826,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751827,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751828,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "answerId": 314751829,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145124
                        },
                        {
                            "answerId": 314751830,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        }
                    ]
                },
                {
                    "questionId": 96345911,
                    "questionType": "MATRIX_3D",
                    "answers": [
                        {
                            "answerId": 314750261,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "notebook"
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "mouseGoods"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "forks, cups"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "wheelsTools"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        }
                    ]
                },
                {
                    "questionId": 96344957,
                    "questionType": "OBJECT_LOOKUP",
                    "answers": [
                        {
                            "answerId": 314751835,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403701"
                        },
                        {
                            "answerId": 314751836,
                            "answerType": "SINGLE_LINE",
                            "value": "Goods for gamers"
                        },
                        {
                            "answerId": 314751837,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403701"
                        },
                        {
                            "answerId": 314751838,
                            "answerType": "SINGLE_LINE",
                            "value": "Goods for gamers"
                        }
                    ]
                }
            ]
        }
    ]
}


Example in postman
image-20230324-105239.png