JSON / REST API Lists

The JSON data / REST answer type allows you create a list based on a remote HTTP endpoint returning JSON formatted object.

The format of the returned JSON must an array of objects with name and value properties as shown in the short sample below.

  [
    {
        "name": "Alabama",
        "value": "AL"
    },
    {
        "name": "Alaska",
        "value": "AK"
    },
    {
        "name": "American Samoa",
        "value": "AS"
    },
  ]

🔅 JSON lists properties

  • Type name display name of the list.

  • Layout defines how the list will be rendered either as a dropdown list or as autocomplete field that will filter the list based on the respondent entry.

  • JSON Data url http url of the endpoint returning the JSON list array eg: http://yourrestapiserver/jsonfile.json

  • Database connection string connection string to your SQL Server database.

  • SQL query Actual query that will be execute to retrieve the list items. You may also add parameters to generate dynamic queries.

Last updated

Was this helpful?