Integration Specifications

This page will help you learn about how Daasity replicates data from Fairing, limitations to the data we can extract and where the data is stored in the Fairing schema.

Integration Overview

The Daasity Fairing integration allows merchants to compare post-purchase survey responses with other order channel attribution models. This allows the customer to compare, e.g. GA last click channel with a customer’s survey response to form a more holistic view of which marketing channels drive a customer to make an order.

Integration Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

This extractor is based on this API documentation. The following endpoints are used by Daasity to replicate data into Daasity:

• List all questions

• List all responses

Entity Relationship Diagram (ERD)

Fairing V2 Schema

The Fairing V2 extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Question Response Clarification Question Responses
• Question Responses
• Questions
• Responses

Questions

• Endpoint: List all questions
• Update Method: UPSERT

• Table Name: [fairing.questions]

JSON Element	Column
$.data[].allow_other	allow_other
$.data[].customer_type	customer_type
$.data[].frequency_type	frequency_type
$.data[].id	id
$.data[].inserted_at	inserted_at
$.data[].other_placeholder	other_placeholder
$.data[].prompt	prompt
$.data[].published_at	published_at
$.data[].randomize_responses	randomize_responses
$.data[].submit_text	submit_text
$.data[].type	type
$.data[].updated_at	updated_at
MD5($.data[].id)	__sync_key

Question Responses

• Endpoint: List all questions
• Update Method: UPSERT

• Table Name: [fairing.question_responses]

JSON Element	Column
$.data[].responses[].clarification_question.allow_other	clarification_question__allow_other
$.data[].responses[].clarification_question.base_settings.auto_advance	clarification_question__base_settings__auto_advance
$.data[].responses[].clarification_question.base_settings.date_type	clarification_question__base_settings__date_type
$.data[].responses[].clarification_question.base_settings.left_label	clarification_question__base_settings__left_label
$.data[].responses[].clarification_question.base_settings.placeholder	clarification_question__base_settings__placeholder
$.data[].responses[].clarification_question.base_settings.presentation	clarification_question__base_settings__presentation
$.data[].responses[].clarification_question.base_settings.right_label	clarification_question__base_settings__right_label
$.data[].responses[].clarification_question.description	clarification_question__description
$.data[].responses[].clarification_question.id	clarification_question__id
$.data[].responses[].clarification_question.other_placeholder	clarification_question__other_placeholder
$.data[].responses[].clarification_question.prompt	clarification_question__prompt
$.data[].responses[].clarification_question.randomize_responses	clarification_question__randomize_responses
$.data[].responses[].clarification_question.settings.auto_advance	clarification_question__settings__auto_advance
$.data[].responses[].clarification_question.settings.date_type	clarification_question__settings__date_type
$.data[].responses[].clarification_question.settings.left_label	clarification_question__settings__left_label
$.data[].responses[].clarification_question.settings.placeholder	clarification_question__settings__placeholder
$.data[].responses[].clarification_question.settings.right_label	clarification_question__settings__right_label
$.data[].responses[].clarification_question.type	clarification_question__type
$.data[].responses[].id	id
$.data[].responses[].value	value
MD5($.data[].responses.id)	__sync_key

Question Response Clarification Question Responses

• Endpoint: List all questions
• Update Method: UPSERT

• Table Name: [fairing.question_response_clarification_question_responses]

JSON Element	Column
$.data[].responses[].clarification_question.responses[].id	id
$.data[].responses[].clarification_question.responses[].value	value
$.data[].responses[].id	questions_responses_id

Responses

• Endpoint: List all responses
• Update Method: UPSERT

• Table Name: [fairing.responses]

JSON Element	Column
$.data[].available_responses	available_responses
$.data[].clarification_question	clarification_question
$.data[].coupon_amount	coupon_amount
$.data[].coupon_code	coupon_code
$.data[].coupon_type	coupon_type
$.data[].customer_id	customer_id
$.data[].customer_order_count	customer_order_count
$.data[].email	email
$.data[].id	id
$.data[].inserted_at	inserted_at
$.data[].landing_page_path	landing_page_path
$.data[].order_created_at	order_created_at
$.data[].order_currency_code	order_currency_code
$.data[].order_id	order_id
$.data[].order_number	order_number
$.data[].order_platform	order_platform
$.data[].order_source	order_source
$.data[].order_total	order_total
$.data[].order_total_usd	order_total_usd
$.data[].original_response	original_response
$.data[].other	other
$.data[].other_response	other_response
$.data[].question	question
$.data[].question_id	question_id
$.data[].question_type	question_type
$.data[].referring_question	referring_question
$.data[].referring_question_id	referring_question_id
$.data[].referring_question_response	referring_question_response
$.data[].referring_question_response_id	referring_question_response_id
$.data[].referring_site	referring_site
$.data[].response	response
$.data[].response_id	response_id
$.data[].response_position	response_position
$.data[].response_provided_at	response_provided_at
$.data[].submit_delta	submit_delta
$.data[].updated_at	updated_at
$.data[].utm_campaign	utm_campaign
$.data[].utm_content	utm_content
$.data[].utm_medium	utm_medium
$.data[].utm_source	utm_source
$.data[].utm_term	utm_term
MD5($.data[].id)	__sync_key