Breadcrumbs

API example - filter responses by single line number type

API example on how to filter the form responses by the single line number type values

Question type - Single Line

Answer Type - Number

image-20230324-103652.png


Request:

curl --location 'https://app.form.com/gw/v3/results/list?formId=41659267&limit=100&offset=0' \
--header 'Authorization: Bearer 83a36c26-6b7a-4e3d-a737-d73e0779f7b5' \
--header 'Content-Type: application/json' \
--data '{
    "items": [{
        "sourceItemKey": "Q96342785.A314750706",
        "operator": "GREATER_THAN",
        "operand":{
            "value": "2015"
        }
    }]
}'


Response

{
    "results": [
        {
            "respondentId": 1395862180,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "Samanta"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "07/04/1975"
                        },
                        {
                            "answerId": 314750706,
                            "answerType": "SINGLE_LINE",
                            "value": "2018"
                        }
                    ]
                },
                {
                    "questionId": 96344945,
                    "questionType": "PICK_ONE_NO_OTHER",
                    "answers": [
                        {
                            "answerId": 314751796,
                            "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": 314752896,
                            "answerType": "DROPDOWN",
                            "value": "500 - 1000 $"
                        }
                    ]
                },
                {
                    "questionId": 96342794,
                    "questionType": "LIST_BOX",
                    "answers": [
                        {
                            "answerId": 314750736,
                            "answerType": "LIST_BOX",
                            "value": "Sunday"
                        }
                    ]
                },
                {
                    "questionId": 96344953,
                    "questionType": "RATE_DIFFERENT",
                    "answers": [
                        {
                            "answerId": 314751826,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751827,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751828,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751829,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145124
                        },
                        {
                            "answerId": 314751830,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145124
                        }
                    ]
                },
                {
                    "questionId": 96345911,
                    "questionType": "MATRIX_3D",
                    "answers": [
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "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, spoons, plates"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        }
                    ]
                },
                {
                    "questionId": 96344957,
                    "questionType": "OBJECT_LOOKUP",
                    "answers": [
                        {
                            "answerId": 314751835,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403718"
                        },
                        {
                            "answerId": 314751836,
                            "answerType": "SINGLE_LINE",
                            "value": "Home goods"
                        },
                        {
                            "answerId": 314751837,
                            "answerType": "SINGLE_LINE",
                            "value": "1326403718"
                        },
                        {
                            "answerId": 314751838,
                            "answerType": "SINGLE_LINE",
                            "value": "Home goods"
                        }
                    ]
                }
            ]
        },
        {
            "respondentId": 1395860926,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "Michael"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "06/08/1982"
                        },
                        {
                            "answerId": 314750706,
                            "answerType": "SINGLE_LINE",
                            "value": "2019"
                        }
                    ]
                },
                {
                    "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": 314750727,
                            "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": 314750742,
                            "answerType": "LIST_BOX",
                            "value": "Saturday"
                        }
                    ]
                },
                {
                    "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": 3145123
                        },
                        {
                            "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": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "TV"
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "keyboard"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "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": 314750264,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "curtains"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145148
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "wheels"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        }
                    ]
                },
                {
                    "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"
                        }
                    ]
                }
            ]
        },
        {
            "respondentId": 1395862366,
            "results": [
                {
                    "questionId": 96342785,
                    "questionType": "SINGLE_LINE",
                    "answers": [
                        {
                            "answerId": 314750704,
                            "answerType": "SINGLE_LINE",
                            "value": "Christopher"
                        },
                        {
                            "answerId": 314750705,
                            "answerType": "SINGLE_LINE",
                            "value": "06/17/1980"
                        },
                        {
                            "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"
                        }
                    ]
                },
                {
                    "questionId": 96343988,
                    "questionType": "DROPDOWN",
                    "answers": [
                        {
                            "answerId": 314752895,
                            "answerType": "DROPDOWN",
                            "value": "200 - 500 $"
                        }
                    ]
                },
                {
                    "questionId": 96342794,
                    "questionType": "LIST_BOX",
                    "answers": [
                        {
                            "answerId": 314750741,
                            "answerType": "LIST_BOX",
                            "value": "Friday"
                        },
                        {
                            "answerId": 314750742,
                            "answerType": "LIST_BOX",
                            "value": "Saturday"
                        }
                    ]
                },
                {
                    "questionId": 96344953,
                    "questionType": "RATE_DIFFERENT",
                    "answers": [
                        {
                            "answerId": 314751826,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145124
                        },
                        {
                            "answerId": 314751827,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751828,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145122
                        },
                        {
                            "answerId": 314751829,
                            "answerType": "PICK_ONE_COLUMN",
                            "columnId": 3145123
                        },
                        {
                            "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": "TV"
                        },
                        {
                            "answerId": 314750261,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "keysboard"
                        },
                        {
                            "answerId": 314750262,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750263,
                            "answerType": "SINGLE_LINE_COLUMN",
                            "columnId": 3145150,
                            "value": "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": "curtains"
                        },
                        {
                            "answerId": 314750264,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "Yes"
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "CHECK_ALL_COLUMN",
                            "columnId": 3145149
                        },
                        {
                            "answerId": 314750265,
                            "answerType": "DROPDOWN_COLUMN",
                            "columnId": 3145151,
                            "value": "No"
                        }
                    ]
                },
                {
                    "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-103636.png