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

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

Last updated