How to Integrate Retool with Etsy API

To access Etsy's API, you must register a developer application and complete the OAuth 2.0 authorization flow. Go to developers.etsy.com and sign in with your Etsy account. Navigate to 'Your Apps' and click 'Create a new app'. Fill in the application name (e.g., 'Retool Shop Manager'), describe the intended use, and set the redirect URI to your Retool instance URL or a local redirect URL you control for the one-time authorization step. After creating the app, Etsy displays your Application Key (also called client_id). Etsy's Open API v3 uses OAuth 2.0 with PKCE for the authorization flow — you need to generate a code_verifier (a random 43-128 character string), compute its SHA-256 hash, base64url-encode it as the code_challenge, and direct the user to Etsy's authorization URL with the appropriate scopes. Required scopes for a seller dashboard: listings_r (read listings), listings_w (write listings), transactions_r (read orders/receipts), billing_r (read financial data). Complete the authorization by directing your browser to: https://www.etsy.com/oauth/connect?response_type=code&redirect_uri={your_redirect}&scope={scopes}&client_id={app_key}&state={random_state}&code_challenge={code_challenge}&code_challenge_method=S256. After authorizing, Etsy redirects to your redirect URI with a code parameter. Exchange this code for tokens by POSTing to https://api.etsy.com/v3/public/oauth/token with your client_id, redirect_uri, code, code_verifier, and grant_type=authorization_code. The response contains an access_token (valid for 1 hour) and a refresh_token (valid for 90 days). Store both tokens securely in Retool configuration variables.

1{
2  "token_endpoint": "https://api.etsy.com/v3/public/oauth/token",
3  "grant_type": "authorization_code",
4  "required_fields": {
5    "client_id": "your_etsy_app_key",
6    "redirect_uri": "your_redirect_uri",
7    "code": "authorization_code_from_redirect",
8    "code_verifier": "your_pkce_code_verifier"
9  },
10  "note": "Response includes access_token (1hr) and refresh_token (90 days)"
11}

In Retool, navigate to the Resources tab and click '+ Create new'. Select 'REST API'. In the Name field, enter 'Etsy API' or include your shop name if managing multiple shops. For the Base URL, enter https://openapi.etsy.com/v3. For Authentication, select 'Bearer token' and paste your Etsy OAuth 2.0 access token into the token field. Add default headers: Content-Type set to application/json and x-api-key set to your Etsy Application Key (client_id) — this header is required on all Etsy API requests in addition to the Bearer token. Click 'Save resource'. All requests through this resource are proxied server-side by Retool, so neither the Bearer token nor the API key is visible to browser clients. Note that Etsy access tokens expire after 1 hour. For a production Retool app, implement token refresh automation: create a Retool Workflow on a 50-minute schedule that POSTs to Etsy's token endpoint with grant_type=refresh_token and your stored refresh_token, receives a new access_token, and updates the Retool configuration variable. Reference this configuration variable in the resource's Bearer token field using {{ retoolContext.configVars.ETSY_ACCESS_TOKEN }}. Refresh tokens themselves expire after 90 days of inactivity — if your app is used regularly, the chain of refresh operations will keep the tokens active indefinitely.

Open your Retool app or create a new one. In the Code panel, click '+ New query' and select your Etsy API resource. First, find your shop ID or shop name: create a getShop query with Method GET, path /application/shops and param shop_name set to your Etsy shop name. The response includes your shop_id, which is required in subsequent endpoint paths. Alternatively, if you know your shop_id, skip this query. Create a getListings query: Method GET, path /application/shops/{shop_id}/listings/active (replace {shop_id} with your actual shop ID or reference it from a config variable). Add params: limit set to 100, offset set to {{ listingsTable.paginationOffset || 0 }}, sort_on set to 'created', sort_order set to 'desc'. Name this query getListings. Create a getReceipts query: Method GET, path /application/shops/{shop_id}/receipts. Add params: limit set to 100, offset set to {{ receiptsTable.paginationOffset || 0 }}, was_shipped set to false (to show unshipped orders only), and was_paid set to true (to show paid orders). Name this query getReceipts. Run each query to inspect the response — Etsy wraps all list responses in a { count, results: [...] } envelope where count is the total number and results is the current page's data array.

1{
2  "method": "GET",
3  "path": "/application/shops/YOUR_SHOP_ID/listings/active",
4  "params": {
5    "limit": "100",
6    "offset": "{{ listingsTable.paginationOffset || 0 }}",
7    "sort_on": "created",
8    "sort_order": "desc",
9    "includes": "[\"MainImage\",\"Images\"]"
10  }
11}

Etsy's API returns listings and receipts in nested formats that require flattening before binding to Retool components. In the getListings query editor, click 'Advanced' → toggle 'Transform results'. Write a transformer that maps each listing in data.results to a flat row. Key fields include listing_id, title, price.amount/price.divisor (price is returned as amount and divisor, so actual price = amount/divisor), quantity, views, num_favorers, state ('active', 'inactive', 'draft'), and images[0].url_570xN for a thumbnail. After writing the transformer, drag a Table component onto the canvas. Set its Data source to {{ getListings.data }}. Enable server-side pagination and set total row count to {{ getListings.rawData.count }}. For receipts, write a transformer on getReceipts that maps each receipt to a flat row with receipt_id, buyer name (name field), create_timestamp (Unix to date), total_price, shipping address details, and the first transaction's title as a summary. Drag a second Table, bind it to {{ getReceipts.data }}, and configure the same pagination pattern. Add a search TextInput above the listings table wired to a keyword search parameter. Add a detail Container for receipts that shows when a receipt row is selected, displaying all transaction items and a form to add tracking via POST /application/shops/{shop_id}/receipts/{receipt_id}/tracking. For complex multi-channel inventory management combining Etsy with Shopify or WooCommerce, RapidDev's team can help architect the unified Retool seller operations solution.

1// Transformer: flatten Etsy listing list
2const listings = data.results || [];
3return listings.map(listing => ({
4  listing_id: listing.listing_id,
5  title: listing.title,
6  price: listing.price
7    ? `$${(listing.price.amount / listing.price.divisor).toFixed(2)} ${listing.price.currency_code}`
8    : 'N/A',
9  quantity: listing.quantity,
10  views: listing.views,
11  favorites: listing.num_favorers,
12  state: listing.state,
13  shop_section_id: listing.shop_section_id || 'None',
14  tags: (listing.tags || []).slice(0, 3).join(', '),
15  image_url: listing.images && listing.images[0]
16    ? listing.images[0].url_570xN
17    : '',
18  created: listing.creation_timestamp
19    ? new Date(listing.creation_timestamp * 1000).toLocaleDateString()
20    : 'N/A',
21  last_modified: listing.last_modified_tsz
22    ? new Date(listing.last_modified_tsz * 1000).toLocaleDateString()
23    : 'N/A'
24}));

Complete the seller dashboard by adding write operations for listing updates and order shipping. For updating a listing's price or quantity, create a PUT query: Method PUT, path /application/listings/{{ listingsTable.selectedRow.listing_id }}, Body type JSON with fields { "price": {{ priceInput.value }}, "quantity": {{ quantityInput.value }}, "state": "active" }. Note that Etsy's price field in PUT requests expects a decimal number (not amount/divisor format), so use the input value directly. Create a shipping tracking query: Method POST, path /application/shops/{shop_id}/receipts/{{ receiptsTable.selectedRow.receipt_id }}/tracking, Body type JSON with { "tracking_code": "{{ trackingInput.value }}", "carrier_name": "{{ carrierSelect.value }}", "send_bcc": true }. The send_bcc option emails the buyer with their tracking information. Wire these queries to Button components in the detail panels. On the listing update query's Success event handler, trigger getListings to refresh the table and show a success notification. On the tracking POST Success handler, trigger getReceipts and show 'Shipment tracked successfully'. Implement a confirmation Modal before submitting price changes — accidental price updates on a live Etsy listing are visible to buyers immediately. Wire the Modal's Confirm button to the actual PUT query and the Cancel button to the Modal's close method.

1{
2  "method": "POST",
3  "path": "/application/shops/YOUR_SHOP_ID/receipts/{{ receiptsTable.selectedRow.receipt_id }}/tracking",
4  "body": {
5    "tracking_code": "{{ trackingInput.value }}",
6    "carrier_name": "{{ carrierSelect.value }}",
7    "send_bcc": true,
8    "note_to_buyer": "{{ noteInput.value || '' }}"
9  }
10}