Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Fairing connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Fairing connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Fairing connector:
- Questions
- Responses
Questions
Purpose: To get a list of all the questions in your EnquireLabs account.
Replication: Full Load.
Fields
Field Name |
Datatype |
|---|---|
allow_other |
BOOLEAN |
customer_type |
STRING |
frequency_type |
STRING |
id |
NUMERIC |
inserted_at |
TIMESTAMP |
other_placeholder |
STRING |
prompt |
STRING |
published_at |
TIMESTAMP |
randomize_responses |
BOOLEAN |
responses |
RECORD |
id |
NUMERIC |
value |
STRING |
clarification_question |
RECORD |
allow_other |
BOOLEAN |
id |
NUMERIC |
prompt |
STRING |
randomize_responses |
BOOLEAN |
responses |
RECORD |
type |
STRING |
submit_text |
STRING |
type |
STRING |
| updated_at | TIMESTAMP |
Responses
Purpose: To get a list of all the responses received in your EnquireLabs.
Replication: Incremental.
Replication Key: since & until.
Fields
Field Name |
Datatype |
|---|---|
utm_source |
STRING |
customer_id |
STRING |
inserted_at |
TIMESTAMP |
order_currency_code |
STRING |
response |
STRING |
order_total |
STRING |
order_id |
STRING |
clarification_question |
BOOLEAN |
email |
STRING |
order_platform |
STRING |
response_id |
NUMERIC |
id |
STRING |
other |
BOOLEAN |
order_total_usd |
STRING |
utm_medium |
STRING |
order_source |
STRING |
customer_order_count |
NUMERIC |
order_number |
STRING |
available_responses |
STRING |
referring_site |
STRING |
updated_at |
TIMESTAMP |
question_type |
STRING |
submit_delta |
NUMERIC |
response_provided_at |
TIMESTAMP |
question_id |
NUMERIC |
question |
STRING |
response_position |
NUMERIC |
referring_question |
STRING |
referring_question_response |
STRING |
referring_question_response_id |
NUMERIC |
referring_question_id |
NUMERIC |
coupon_amount |
STRING |
coupon_type |
STRING |
coupon_code |
STRING |
| other_response | STRING |