{"name":"ebay-active-get public API","description":"eBayセラー向け管理アプリの外部アプリ向け公開API。7アカウント分の在庫高(仕入価格×在庫数)を1時間ごとに記録。","base_url":"https://ebay-active-get.vercel.app","auth":{"type":"bearer","header":"Authorization","format":"Bearer <PUBLIC_API_KEY>","note":"PUBLIC_API_KEYはアプリ管理者から払い出してもらう"},"endpoints":[{"path":"/api/public/inventory-snapshot","method":"GET","description":"各eBayアカウントの直近の在庫高スナップショットを取得","auth_required":true,"response":{"status":200,"schema":{"snapshots":"Array<SnapshotRow> - アカウント別の最新スナップショット","total_value_jpy":"number - 全アカウント在庫高合計(円)","total_item_count":"number - 全アカウント出品件数合計","account_count":"number - スナップショット数","fetched_at":"string (ISO 8601) - レスポンス生成時刻"},"snapshot_row":{"account_name":"string - アカウント識別子(例: 'monoshare')","display_name":"string - UI表示名(例: 'Monoshare')","recorded_at":"string (ISO 8601) - 記録時刻","total_value_jpy":"number - このアカウントの在庫高(円)","item_count":"number - eBay Active出品件数","matched_count":"number - Kintone突合成功件数","unmatched_count":"number - 突合失敗件数","error":"string | null - 取得エラー('トークン未設定'等)"}},"errors":[{"status":401,"message":"Unauthorized - Bearerトークンが正しくない"},{"status":500,"message":"API未設定(PUBLIC_API_KEY) - サーバー側未設定"},{"status":500,"message":"Supabase未設定"},{"status":500,"message":"Supabase読取エラー"}],"example_request":{"method":"GET","url":"https://ebay-active-get.vercel.app/api/public/inventory-snapshot","headers":{"Authorization":"Bearer YOUR_API_KEY"}},"example_response":{"snapshots":[{"account_name":"monoshare","display_name":"Monoshare","recorded_at":"2026-04-22T08:03:39.936584+00","total_value_jpy":53927288,"item_count":8918,"matched_count":2518,"unmatched_count":6400,"error":null}],"total_value_jpy":53927288,"total_item_count":8918,"account_count":1,"fetched_at":"2026-04-22T09:15:23.456Z"}},{"path":"/api/public/returns","method":"POST","description":"ebay-returns-manager から返品レコードを受信し external_returns に upsert する。duplicate=true は同一SKU/itemIdの返品が既に登録済みであることを示す(重複出品チェック用)","auth_required":true,"request_body":{"return_id":"string (必須) - eBay returnId。upsert のキー","ebay_account":"string - eBayアカウント識別子","item_id":"string - eBay itemId","sku":"string - 自社SKU(商品番号)","transaction_id":"string","buyer_login":"string","status":"string - 返品の内部ステータス","item_title":"string","source":"string - 送信元(既定 'ebay-returns-manager')"},"response":{"status":200,"schema":{"ok":"boolean","return_id":"string","duplicate":"boolean - 同一SKU/itemIdの別返品が既存か","received_at":"string (ISO 8601)"}},"errors":[{"status":400,"message":"return_id は必須です / 不正なJSON"},{"status":401,"message":"Unauthorized"},{"status":500,"message":"Supabase未設定 / 書き込みエラー"}],"example_request":{"method":"POST","url":"https://ebay-active-get.vercel.app/api/public/returns","headers":{"Authorization":"Bearer YOUR_API_KEY","Content-Type":"application/json"},"body":{"return_id":"5000123456","ebay_account":"monoshare","item_id":"111222333","sku":"4480145","status":"IMPORTED","source":"ebay-returns-manager"}},"example_response":{"ok":true,"return_id":"5000123456","duplicate":false,"received_at":"2026-06-03T12:00:00.000Z"}},{"path":"/api/public/returns","method":"GET","description":"指定キーの返品が登録済みか確認する(重複チェック用)","auth_required":true,"query":{"sku":"string - SKUで検索","item_id":"string - itemIdで検索","return_id":"string - returnIdで検索"},"response":{"status":200,"schema":{"exists":"boolean","count":"number","returns":"Array - 該当返品レコード(最大50件)","fetched_at":"string (ISO 8601)"}},"errors":[{"status":400,"message":"sku / item_id / return_id のいずれか必須"},{"status":401,"message":"Unauthorized"}],"example_request":{"method":"GET","url":"https://ebay-active-get.vercel.app/api/public/returns?sku=4480145","headers":{"Authorization":"Bearer YOUR_API_KEY"}},"example_response":{"exists":true,"count":1,"returns":[{"return_id":"5000123456","sku":"4480145","status":"IMPORTED"}],"fetched_at":"2026-06-03T12:00:00.000Z"}},{"path":"/api/public/sku-status","method":"GET","description":"SKU 1件の eBay での状況。OAuth の鍵があるアカウントを全部調べ、始まりがいちばん遅い出品を返す。売れていれば支払い・出荷・キャンセル、返品の状態も返す。数字6桁で5から始まる SKU は S を付けた SKU も一緒に調べる。読むだけ","auth_required":true,"query":{"sku":"string (必須) - 自社SKU(商品番号)"},"response":{"status":200,"schema":{"sku":"string - 渡した SKU","checkedSkus":"string[] - 実際に調べた SKU(例: ['591845','S591845'])","account":"{ name, displayName } | null - 出品が見つかったアカウント","listing":"{ itemId, sku, listingStatus(Active/Completed 等), startTime, endTime, listingDuration(GTC/Days_5 等。GTC は30日ごとに自動更新され、endTime は次の更新の時刻), quantitySold, url } | null - 出品が無ければ null。見るのは終わる日時が過去119日〜先119日の出品だけ（それより古い出品も null）","sale":"{ transactionId, soldAt, paidAt, shippedAt, orderStatus(Active/Completed/Cancelled 等), cancelStatus, cancelledAt(キャンセルした時刻の代わり。返金の時刻、無ければ取引の最終更新), cancelledAtSource('refund'|'last_modified'|null), trackingNumber, carrier } | null - 売れていなければ null。quantitySold が1以上なのに null なら、売れているが取引が読めなかった","return":"{ returnId, state, status, createdAt } | null - 返品が無ければ null","checkedAccounts":"string[] - 調べたアカウント","fetched_at":"string (ISO 8601)"}},"errors":[{"status":400,"message":"sku は必須です"},{"status":401,"message":"Unauthorized"},{"status":500,"message":"API未設定(PUBLIC_API_KEY)"},{"status":502,"message":"eBayに確かめられませんでした: ... - どこかで eBay に聞けなかった。「出品なし」とは読まないこと"}],"example_request":{"method":"GET","url":"https://ebay-active-get.vercel.app/api/public/sku-status?sku=5854373","headers":{"Authorization":"Bearer YOUR_API_KEY"}},"example_response":{"sku":"5854373","checkedSkus":["5854373"],"account":{"name":"monoshare","displayName":"Monoshare"},"listing":{"itemId":"940016785318","sku":"5854373","listingStatus":"Completed","startTime":"2026-10-17T02:56:48.000Z","endTime":"2026-10-22T02:56:48.000Z","listingDuration":"Days_5","quantitySold":1,"url":"https://www.ebay.com/itm/940016785318"},"sale":{"transactionId":"10084766150124","soldAt":"2026-10-22T02:56:54.000Z","paidAt":"2026-10-22T13:33:05.391Z","shippedAt":"2026-10-23T05:58:50.000Z","orderStatus":"Completed","cancelStatus":"NotApplicable","cancelledAt":null,"cancelledAtSource":null,"trackingNumber":"1Z...","carrier":"UPS"},"return":null,"checkedAccounts":["monoshare","pict","wonderland"],"fetched_at":"2026-10-24T16:45:37.945Z"}},{"path":"/api/public/sku-shipped","method":"POST","description":"SKU をまとめて、eBay で出荷済みかを返す(1回200件まで)。SKU ごとに全アカウントを通していちばん新しい出品を選び、その取引に出荷日があれば shipped。キャンセルされた取引は shipped にしない。売れた数があるのに取引が読めなかったときは sale_unknown(出荷されたかは分からない)。見るのは終わる日時が過去119日〜明日までの出品。数字6桁で5から始まる SKU は S 付きも調べる。読むだけ。200件で数十秒かかることがある","auth_required":true,"request_body":{"skus":"string[] (必須) - 自社SKU(商品番号)。1〜200件"},"response":{"status":200,"schema":{"results":"Record<sku, { state: 'shipped'|'not_shipped'|'sale_unknown'|'no_listing', ebaySku, itemId, account, soldAt, shippedAt, orderStatus }>","fetched_at":"string (ISO 8601)"}},"errors":[{"status":400,"message":"不正なJSON / skus（文字列の配列）は必須です / skus が空です / skus は1回 200 件までです"},{"status":401,"message":"Unauthorized"},{"status":500,"message":"API未設定(PUBLIC_API_KEY)"},{"status":502,"message":"eBayに確かめられませんでした: ... - どこかで eBay に聞けなかった。「出荷されていない」とは読まないこと"}],"example_request":{"method":"POST","url":"https://ebay-active-get.vercel.app/api/public/sku-shipped","headers":{"Authorization":"Bearer YOUR_API_KEY","Content-Type":"application/json"},"body":{"skus":["592325","1031354"]}},"example_response":{"results":{"592325":{"state":"shipped","ebaySku":"S592325","itemId":"...","account":"monoshare","soldAt":"2026-10-22T...","shippedAt":"2026-10-23T...","orderStatus":"Completed"},"1031354":{"state":"no_listing","ebaySku":null,"itemId":null,"account":null,"soldAt":null,"shippedAt":null,"orderStatus":null}},"fetched_at":"2026-10-25T00:00:00.000Z"}}],"notes":["データは1時間ごとのCronで更新される(最大1時間の遅延あり)","直近24時間以内に記録のないアカウントはレスポンスに含まれない","Cron失敗時のエラーは error フィールドで判別可能"],"llms_txt":"https://ebay-active-get.vercel.app/llms.txt"}