# Etsy
## **Locating Etsy Shop Name**
1. Open & login to your Etsy store ().
2. Navigate to your shop settings button, right new to the cart.
3\. The name above "view your profile" is your shop name, use that name while creating an integration.
## **Snapshot**
| **Features** | **Details** |
| ------------------------------- | --------------------------------- |
| Release Status | Released |
| Source API Version | V3 |
| Table Selection | Yes |
| Column Selection | Yes |
| Edit Integrations | Yes |
| Replication Type Selection | No |
| Authentication Parameters | Client ID
Client Secret
|
| Replication Type | Full Load
Incremental
|
| Replication Key | Date |
| Suggested Replication Frequency | 1 hr |
## **Integrate Etsy with Daton**
1\. Sign in to Daton.
2\. Select Etsy from the Integrations page.
3\. Provide Integration Name Replication Frequency and History.
4\. Provide your shop name here as explained [above](#locating-etsy-shop-name).
5\. A popup prompt will open to authorize Daton to access data, click the “Grant access” button.
6\. Post successful authentication you will be prompted to choose from the list of available tables.
7\. Submit the integration.
## **Etsy Payments Tables**
Source documentation:
1. **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 |
2\. **Receipts**\
Purpose: To get all the receipts from your store.\
Replication: Incremental\
Replication Key: Last\_modified
| **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 |
3\. **Reviews**\
Purpose: To get information about all the listing reviews.\
Replication: Incremental (Limit & Offset)
| **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 |
4\. **Transactions**\
Purpose: To get information about all the transactions from your shop.\
Replication: Incremental (Limit & Offset)
| **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 |
5\. **User Addresses**\
Purpose: To get information about all your user's addresses\
Replication: Incremental (Limit & Offset)
| **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 |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/etsy.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.