Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Etsy connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Etsy connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Etsy connector:
- ListingsbyShop
- Receipts
- Reviews
- Transactions
- User Addresses
Source documentation: https://developer.etsy.com/documentation/
ListingsbyShop
Purpose: To get information about all the listings & corresponding listing images.
Replication: Incremental (Limit & Offset)
Fields
Field name |
Datatype |
|---|---|
price |
RECORD |
production_partners |
RECORD |
ListingImages |
RECORD |
ListingInventory |
RECORD |
listing_id |
INTEGER |
user_id |
INTEGER |
shop_id |
INTEGER |
title |
STRING |
description |
STRING |
state |
STRING |
creation_timestamp |
INTEGER |
ending_timestamp |
INTEGER |
original_creation_timestamp |
INTEGER |
last_modified_timestamp |
INTEGER |
state_timestamp |
INTEGER |
quantity |
INTEGER |
featured_rank |
INTEGER |
url |
STRING |
num_favorers |
INTEGER |
non_taxable |
BOOLEAN |
is_taxable |
BOOLEAN |
is_customizable |
BOOLEAN |
is_personalizable |
BOOLEAN |
personalization_is_required |
BOOLEAN |
listing_type |
STRING |
tags |
STRING |
shipping_profile_id |
NUMERIC |
processing_min |
INTEGER |
processing_max |
INTEGER |
who_made |
STRING |
when_made |
STRING |
is_supply |
BOOLEAN |
item_weight |
NUMERIC |
item_weight_unit |
STRING |
item_length |
NUMERIC |
item_width |
NUMERIC |
item_height |
INTEGER |
item_dimensions_unit |
STRING |
is_private |
BOOLEAN |
file_data |
STRING |
has_variations |
BOOLEAN |
should_auto_renew |
BOOLEAN |
language |
STRING |
taxonomy_id |
INTEGER |
skus |
STRING |
item_height_nu |
NUMERIC |
ListingImagesVariants |
RECORD |
Receipts
Purpose: To get all the receipts from your store.
Replication: Incremental
Replication Key: Last_modified
Fields
Field name |
Datatype |
|---|---|
grandtotal |
RECORD |
subtotal |
RECORD |
total_price |
RECORD |
total_shipping_cost |
RECORD |
total_tax_cost |
RECORD |
total_vat_cost |
RECORD |
discount_amt |
RECORD |
gift_wrap_price |
RECORD |
transactions |
RECORD |
receipt_id |
NUMERIC |
receipt_type |
INTEGER |
seller_user_id |
INTEGER |
seller_email |
STRING |
buyer_user_id |
INTEGER |
buyer_email |
STRING |
name |
STRING |
first_line |
STRING |
second_line |
STRING |
city |
STRING |
state |
STRING |
zip |
INTEGER |
status |
STRING |
formatted_address |
STRING |
country_iso |
STRING |
payment_method |
STRING |
payment_email |
STRING |
message_from_buyer |
STRING |
is_shipped |
BOOLEAN |
is_paid |
BOOLEAN |
create_timestamp |
INTEGER |
update_timestamp |
INTEGER |
is_gift |
BOOLEAN |
gift_message |
STRING |
shipments |
RECORD |
zip_st |
STRING |
receipt_id_in |
INTEGER |
Reviews
Purpose: To get information about all the listing reviews.
Replication: Incremental (Limit & Offset)
Fields
Field name |
Datatype |
|---|---|
shop_id |
INTEGER |
listing_id |
INTEGER |
transaction_id |
NUMERIC |
buyer_user_id |
INTEGER |
rating |
INTEGER |
review |
STRING |
language |
STRING |
create_timestamp |
INTEGER |
update_timestamp |
INTEGER |
image_url_fullxfull |
STRING |
transaction_id_in |
INTEGER |
Transactions
Purpose: To get information about all the transactions from your shop.
Replication: Incremental (Limit & Offset)
Fields
Field name |
Datatype
|
|---|---|
price |
RECORD |
shipping_cost |
RECORD |
transaction_id |
NUMERIC |
title |
STRING |
description |
STRING |
seller_user_id |
INTEGER |
buyer_user_id |
INTEGER |
create_timestamp |
INTEGER |
paid_timestamp |
INTEGER |
shipped_timestamp |
INTEGER |
quantity |
INTEGER |
listing_image_id |
NUMERIC |
receipt_id |
NUMERIC |
is_digital |
BOOLEAN |
file_data |
STRING |
listing_id |
INTEGER |
sku |
STRING |
product_id |
NUMERIC |
transaction_type |
STRING |
shipping_profile_id |
NUMERIC |
min_processing_days |
INTEGER |
max_processing_days |
INTEGER |
expected_ship_date |
INTEGER |
receipt_id_in |
INTEGER |
transaction_id_in |
INTEGER |
variations |
RECORD |
User Addresses
Purpose: To get information about all your user's addresses
Replication: Incremental (Limit & Offset)
Fields
Field name |
Datatype |
|---|---|
user_address_id |
NUMERIC |
user_id |
INTEGER |
name |
STRING |
first_line |
STRING |
second_line |
STRING |
city |
STRING |
state |
STRING |
zip |
INTEGER |
iso_country_code |
STRING |
country_name |
STRING |
is_default_shipping_address |
BOOLEAN |
zip_st |
STRING |