Schema Information of Alchemer
This topic provides a structured reference to assist you in working with Daton's Alchemer connector and the associated fields and tables.
Schema Information of Alchemer
This topic provides a structured reference to assist you in working with Daton's Alchemer connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Alchemer connector:
Account
Retrieves the list of accounts associated with the Alchemer account. For more information on the API, see Account- Alchemer.
Fields
| Field Name | Data Type |
|---|---|
| id | NUMERIC |
| organization | STRING |
| contact_phone | STRING |
| reseller | BOOLEAN |
| date_created | TIMESTAMP |
| login_link | STRING |
Account_Teams
Retrieves the information of update, delete, and creation teams associated with the Alchemer account. For more information on the API, see Account_Teams- Alchemer.
Fields
| Field Name | Data Type |
|---|---|
| id | STRING |
| team_name | STRING |
| status | STRING |
Account_Users
Retrieves the information regarding update, deletion, and creation of account users associated with the Alchemer account. For more information on the API, see Account_Users- Alchemer.
Fields
| Field Name | Data Type |
|---|---|
| id | STRING |
| username | STRING |
| STRING | |
| admin | NUMERIC |
| phone_support | NUMERIC |
| license | STRING |
| defaultteam | STRING |
| status | STRING |
| last_login | TIMESTAMP |
| api_key | STRING |
| api_secret | STRING |
Survey
Retrieves the information regarding update, deletion, and creation of a survey associated with the Alchemer account. For more information on the API, see Survey- Alchemer.
Fields
| Field Name | Data Type |
|---|---|
| id | STRING |
| team | STRING |
| type | STRING |
| status | STRING |
| created_on | TIMESTAMP |
| modified_on | TIMESTAMP |
| title | STRING |
| statistics | RECORD |
| links | RECORD |
Survey_Page
| Field Name | Data Type |
|---|---|
| id | NUMERIC |
| surveyID | STRING |
| title | RECORD |
| properties | RECORD |
| description | RECORD |
| questions | RECORD |
Survey_Response
| Field Name | Data Type |
|---|---|
| id | STRING |
| surveyID | STRING |
| contact_id | STRING |
| status | STRING |
| is_test_data | STRING |
| date_submitted | STRING |
| session_id | STRING |
| language | STRING |
| date_started | STRING |
| link_id | STRING |
| ip_address | STRING |
| referer | STRING |
| user_agent | STRING |
| response_time | NUMERIC |
| data_quality | RECORD |
| longitude | STRING |
| latitude | STRING |
| country | STRING |
| city | STRING |
| region | STRING |
| postal | STRING |
| dma | STRING |
| survey_data | RECORD |
