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

Allows you to programmatically retrieve your questions and response data.

For more information, see Fairing - Questions.

FIELDS

Field Name	Data Type
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

Field Name	Data Type
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