ADO.NET Provider for Mailchimp

Build 26.0.9655

SurveyResponsesResults

Returns a list of answer objects in a survey response.

View-Specific Information

Select

The provider uses the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.

ColumnSupported Operators
ResponseId=

For example, the following query is processed server-side:

SELECT * FROM SurveyResponsesResults WHERE ResponseId = '4548'

Filtering Guidelines

The API returns results based solely on the validity of ResponseId. This means that you cannot filter by SurveyId, as it is not used to determine results regardless of whether a linked survey exists.

Recommended Approach for Accurate Mapping

To ensure accurate mapping between SurveyId and ResponseId, query the SurveyResponses view and use only validated mappings when populating or referencing this view.

Columns

Name Type References Description
SurveyId [KEY] String

Surveys.Id

The Id of the survey.
ResponseId [KEY] String

SurveyResponses.Id

The Id of the survey response.
QuestionId [KEY] String The Id of the survey question.
QuestionType String The survey question type.
Query String The survey question text.
Answer String The respondent's answer text.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655