Metadata query
The metadata query (DESCRIBE TABLE) provides information about what fields are available for the survey data set, including data types and usage guidelines because not all fields may be used for list, query, list, aggregation, and distribution operations
Note: This query is available for the Survey table only.
Metadata queries provide the following information about each field:
| Column name | Data type | Description |
|---|---|---|
| Key | string | The identifying key of the field, to be used in MQL queries |
| Name | string | The name of the field, to be shown to the user |
| Encoding | enumeration | The encoding of the data in this field - one of TEXT, ENUMERATED, INTEGER, DATE, FLOAT |
| Alternativeset | integer | If the encoding is ENUMERATED, then this is the alternativesetid that should be used in a query on the Alternative table to obtain the possible values for this field. |
| list_query | boolean | True if this field can be used in a List query |
| aggregation_query | boolean | True if this field can be used in an Aggregation query (or aDistribution query) |
Sample MQL Client command
DESCRIBE TABLE surveySample query URL
https://api.medallia.com/mainstreet?user=john&pass=Ypass12&query=DESCRIBE+TABLE+survey&output=csv&version=1&apikey=5hxf4qz2qzjuxm46686csnwkSample response
key | name | encoding | alternativeset | list_query | aggregation_query |
address | Address | TEXT | 62 | true | false |
address2 | Address 2 | TEXT | 63 | true | false |
alert_status | Alert status of survey (if any) | TEXT | | true | false |
alert_type | Alert type of survey (if any) | TEXT | | true | false |
br_ability_resolve_issues | Cust. service resolves issues | ENUMERATED | 14 | true | true |
br_acc_statement | Account statements overall | ENUMERATED | 14 | true | true |
br_acc_statement_acc | Accuracy of account statements | ENUMERATED | 14 | true | true |
br_acc_statement_clarity | Clarity of account statements | ENUMERATED | 14 | true | true |
br_acc_statement_time | Timeliness of account statements | ENUMERATED | 14 | true | true |
br_acc_statement_useful | Usefulness of account statements | ENUMERATED | 14 | true | true |
br_account_setup_ease | Ease of setting up a new account | ENUMERATED | 14 | true | true |
br_account_setup_info | Usefulness of info. about acct. offerings | ENUMERATED | 14 | true | true |
br_account_setup_overall | Acct. set-up, options, & offerings overall | ENUMERATED | 14 | true | true |
br_additional_comments | Additional comments | TEXT | 16 | true | false |
br_assumes_resp | Assumes responsibility for errors | ENUMERATED | 14 | true | true |
br_cares_about_empl | Cares about its employees | ENUMERATED | 14 | true | true |
br_clarity_directions_order | Clarity of directions for placing orders | ENUMERATED | 14 | true | true |
br_contact_financial_adv | Ease of contacting | ENUMERATED | 14 | true | true |
br_conven_service_hours | Convenience of customer service hours | ENUMERATED | 14 | true | true |
br_cost_online_overall | Online Brokerage costs | ENUMERATED | 14 | true | true |
br_courtesy | Cust. service courtesy | ENUMERATED | 14 | true | true |
br_customer_serv_overall | Full-Service Brokerage cust service overall | ENUMERATED | 14 | true | true |
br_customer_value | Customer value | ENUMERATED | 85 | true | true |
br_ease_reach_rep | Ease of reaching a representative | ENUMERATED | 14 | true | true |
br_ease_trading_online | Ease of trading online | ENUMERATED | 14 | true | true |
br_effectitive_strategy | Effectiveness of recommended strategy | ENUMERATED | 14 | true | true |
br_fee_acc_reasonable | Reasonableness of acct. maint. fees | ENUMERATED | 14 | true | true |
br_fee_fair | Fairness of commissions | ENUMERATED | 14 | true | true |
br_fee_mgm_reasonable | Reasonableness on money mgmt. fees | ENUMERATED | 14 | true | true |
br_fee_performance | Fees & investment perf. overall | ENUMERATED | 14 | true | true |
br_fees_indiv_online_trades | Online trade order fees | ENUMERATED | 14 | true | true |
br_financial_advisor | Financial advisor or broker overall | ENUMERATED | 14 | true | true |
br_foreign_exch_rates | Foreign exchange rates | ENUMERATED | 14 | true | true |
br_gives_back_to_commun | Gives back to the community | ENUMERATED | 14 | true | true |
br_has_range_obr_prods | Provides products that meet my needs | ENUMERATED | 14 | true | true |
br_investment_performance | Investment performance | ENUMERATED | 14 | true | true |
br_investment_variety | Variety of investment options | ENUMERATED | 14 | true | true |
br_investor_type | Investor type | ENUMERATED | 96 | true | true |
br_is_a_good_bank | Is a good choice for people like me | ENUMERATED | 14 | true | true |
br_is_an_inst_advice | Is a good source for financial advice | ENUMERATED | 14 | true | true |
br_is_convenient | Is convenient | ENUMERATED | 14 | true | true |
br_is_corp_leader | Is a corporate leader | ENUMERATED | 14 | true | true |
br_is_easy_business | Is easy to do business with | ENUMERATED | 14 | true | true |
br_is_flexible | Is flexible | ENUMERATED | 14 | true | true |
br_is_friendly | Is friendly | ENUMERATED | 14 | true | true |
br_is_innovative | Is innovative | ENUMERATED | 14 | true | true |
br_is_international_focus | Is international in focus | ENUMERATED | 14 | true | true |
br_is_quick | Is quick and efficient | ENUMERATED | 14 | true | true |
br_is_stable | Is stable and secure | ENUMERATED | 14 | true | true |
br_is_well_mged | Is well managed | ENUMERATED | 14 | true | true |
br_knowl_financial_adv | Advisor’s or broker’s knowledge | ENUMERATED | 14 | true | true |
br_knowl_serv_rep | Knowledge of cust. service reps. | ENUMERATED | 14 | true | true |
br_length_obr_membership | Tenure | ENUMERATED | 81 | true | true |
br_likely_to_buy_next_prod | Likelihood to buy next product | ENUMERATED | 28 | true | true |
br_likely_to_recommend | Likelihood to recommend | ENUMERATED | 28 | true | true |
br_makes_feel_valued | Feel my business is valued | ENUMERATED | 14 | true | true |
br_monthly_fees | Monthly account administration fees | ENUMERATED | 14 | true | true |
br_new_product_info | Making you aware new products & services | ENUMERATED | 14 | true | true |
br_object_advisor | Objectivity of advisor/broker | ENUMERATED | 14 | true | true |
br_offers_customized_serv | Offers customized service | ENUMERATED | 14 | true | true |
br_ol_customer_service | Online brokerage customer service | ENUMERATED | 14 | true | true |
br_overal_interaction | Recent interaction | ENUMERATED | 14 | true | true |
br_overall_experience | Overall experience | ENUMERATED | 14 | true | true |
br_pr_account_discrpency | Account discrepancy | ENUMERATED | 12 | true | true |
br_pr_comment | Tell us about the problem | TEXT | 16 | true | false |
br_pr_experienced | Problem incidence | ENUMERATED | 13 | true | true |
br_pr_other | Other | ENUMERATED | 12 | true | true |
br_pr_other_text | Other | TEXT | 16 | true | false |
br_pr_trade_exec | Trade execution problem | ENUMERATED | 12 | true | true |
br_pr_unable_to_fulfill | Failure to fulfill order | ENUMERATED | 12 | true | true |
br_pr_website | Website problem | ENUMERATED | 12 | true | true |
br_processing_trades_at_quote | Processing of trades at quoted price | ENUMERATED | 14 | true | true |
br_provides_consist_service | Provides consistent service across depts. | ENUMERATED | 14 | true | true |
br_quality_market_data | Quality of market data | ENUMERATED | 14 | true | true |
br_responsiveness | Cust. service responsiveness | ENUMERATED | 14 | true | true |
br_rewards_loyalty | Rewards customers for their loyalty | ENUMERATED | 14 | true | true |
br_time_financial_adv | Amount of time advisor devotes to acct. | ENUMERATED | 14 | true | true |
br_time_to_confirm | Trade confirmation time | ENUMERATED | 14 | true | true |
br_time_to_execute | Trade execution time | ENUMERATED | 14 | true | true |
br_timeliness_quotes | Timeliness of quotes | ENUMERATED | 14 | true | true |
br_timely_resolution | Timely response to request | ENUMERATED | 14 | true | true |
br_uses_technology | Makes good use of technology | ENUMERATED | 14 | true | true |
br_wants_all_bus | Wants all of my business | ENUMERATED | 14 | true | true |
br_web_navigation | Ease of navigating website | ENUMERATED | 14 | true | true |
br_web_online_tools | Online portfolio management tools | ENUMERATED | 14 | true | true |
br_web_site_availability | Website availability | ENUMERATED | 14 | true | true |
br_web_speed | Website speed | ENUMERATED | 14 | true | true |
br_works_with_bus | Works with me on my financial goals | ENUMERATED | 14 | true | true |
city | City | TEXT | 64 | true | false |
comments | All surey comments concatenated | TEXT | | true | false |
cookies | HTTP client cookies | TEXT | | true | false |
customerid | The customer id for this survey | INTEGER | | true | true |
email | Email | TEXT | 7 | true | false |
firstname | First name | TEXT | 6 | true | false |
fulladdress | Address | TEXT | | true | false |
fullname | Name | TEXT | | true | false |
has_alert | Survey has alert (1 or 0) | INTEGER | | true | true |
has_comment | Survey has comment (1 or 0) | INTEGER | | true | true |
has_open_alert | Survey has open alert (1 or 0) | INTEGER | | true | true |
ipaddress | The IP address from which the survey was taken | TEXT | | true | false |
lastname | Last name | TEXT | 5 | true | false |
log_notes | All log notes combined (if any) | TEXT | | true | false |
personal_age_alt0 | Age | ENUMERATED | 22 | true | true |
personal_children | Children under 18 at home | ENUMERATED | 13 | true | true |
personal_gender | Gender | ENUMERATED | 21 | true | true |
personal_income_alt0 | Income | ENUMERATED | 23 | true | true |
personal_marital | Marital status | ENUMERATED | 24 | true | true |
phone | Phone | TEXT | 11 | true | false |
postalcode | Zip/Postal code | TEXT | 66 | true | false |
rapid_response_status | Rapid Response status for this survey (e.g. sent or not) | ENUMERATED | 1151 | true | true |
responsedate | Response Date | DATE | 60 | true | false |
startdate | The date when the survey was first accessed | DATE | 60 | true | false |
state | State/Province | TEXT | 65 | true | false |
survey_assignee | Alert assignee | ENUMERATED | 1149 | true | true |
survey_language | Survey language | ENUMERATED | 1175 | true | true |
survey_method | Survey Method | ENUMERATED | 1148 | true | true |
survey_program | Survey Program | TEXT | | true | false |
surveyid | Surveyid for internal use (e.g. RI link) | INTEGER | | true | true |
unit_city | Property city | TEXT | | true | false |
unit_postal_code | Property postal code | TEXT | | true | false |
unit_street_address | Property street address | TEXT | | true | false |
unitid | Unitid | TEXT | 3 | true | false |