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
Allows you to programmatically retrieve your questions and response data.
For more information, see Fairing - Questions.
FIELDS
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
submit_text
STRING
type
STRING
updated_at
TIMESTAMP
Responses
The Fairing API Responses asks survey questions after purchase to collect information directly from the user. This helps to avoid the issue of lost or missing attribution.
For more information, see Fairing - Responses.
FIELDS
utm_source
STRING
customer_id
STRING
inserted_at
TIMESTAMP
order_currency_code
STRING
response
STRING
order_total
STRING
order_id
STRING
clarification_question
BOOLEAN
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
Last updated