zoho-api

Qmop1967 的头像作者 Qmop1967

TSH客户端控制台的Zoho Books和Zoho Inventory API集成。使用场景:(1)创建调用Zoho端点的新API路由(2)调试API错误、令牌问题或速率限制(3)添加新的Zoho数据获取函数(4)理解使用Upstash Redis的OAuth令牌缓存(5)处理产品、订单、发票、付款或信用票据(6)排查"联系获取价格"或库存显示问题

📖 中文导读:TSH客户端控制台的Zoho Books和Zoho Inventory API集成。使用场景:(1)创建调用Zoho端点的新API路由(2)调试API错误、令牌问题或速率限制(3)添加新的Zoho数据获取函数(4)理解使用Upstash Redis的OAuth令牌缓存(5)处理产品、订单、发票、付款或信用票据(6)排查"联系获取价格"或库存显示问题 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: zoho-api description: | Zoho Books and Zoho Inventory API integration for TSH Clients Console. Use when: (1) Creating new API routes that call Zoho endpoints (2) Debugging API errors, token issues, or rate limits (3) Adding new Zoho data fetching functions (4) Understanding OAuth token caching with Upstash Redis (5) Working with products, orders, invoices, payments, or credit notes (6) Troubleshooting "Contact for price" or stock display issues

Zoho API Integration

Quick Reference

API Base URL
Zoho Inventory https://www.zohoapis.com/inventory/v1
Zoho Books https://www.zohoapis.com/books/v3

Organization ID: 748369814

Code Files

File Purpose
src/lib/zoho/client.ts OAuth client, token caching, zohoFetch
src/lib/zoho/products.ts Products, stock extraction
src/lib/zoho/price-lists.ts Price list constants and fetching
src/lib/zoho/customers.ts Customer lookup by email
src/lib/zoho/orders.ts Sales orders
src/lib/zoho/invoices.ts Invoices
src/lib/zoho/payments.ts Payments
src/lib/zoho/credit-notes.ts Credit notes

Using zohoFetch

import { zohoFetch } from '@/lib/zoho/client';

// GET request
const data = await zohoFetch('/inventory/v1/items', {
  params: {
    organization_id: process.env.ZOHO_ORGANIZATION_ID,
    page: 1,
    per_page: 100,
  },
});

// Single item with locations
const item = await zohoFetch(`/inventory/v1/items/${itemId}`, {
  params: { organization_id: process.env.ZOHO_ORGANIZATION_ID },
});

Token Caching (CRITICAL)

Memory Cache → Upstash Redis → Zoho OAuth Refresh
              (50-min TTL)    (rate limit: 10s guard)

If all prices show "Contact for price", check:

  1. Upstash env vars in Vercel
  2. UPSTASH_REDIS_REST_URL and UPSTASH_REDIS_REST_TOKEN
  3. Run: curl https://www.tsh.sale/api/debug/token

Common Endpoints

Inventory API

GET /items                      # List products
GET /items/{id}                 # Single product (includes locations)
GET /categories                 # List categories
GET /pricebooks/{id}            # Pricebook with items

Books API

GET /contacts                   # List customers
GET /salesorders                # Sales orders
GET /invoices                   # Invoices
GET /customerpayments           # Payments
GET /creditnotes                # Credit notes

Caching with unstable_cache

import { unstable_cache } from 'next/cache';

const getCachedProducts = unstable_cache(
  async () => await fetchProducts(),
  ['products'],
  { revalidate: 3600, tags: ['products'] }
);

Revalidate cache:

curl "https://www.tsh.sale/api/revalidate?tag=products&secret=tsh-revalidate-2024"

Error Handling Pattern

try {
  const data = await zohoFetch('/inventory/v1/items', { ... });
} catch (error) {
  if (error.message.includes('401')) {
    // Token expired - auto-refreshes
  } else if (error.message.includes('429')) {
    // Rate limited - wait and retry
  }
}

Creating New API Route

// src/app/api/zoho/[resource]/route.ts
import { NextResponse } from 'next/server';
import { zohoFetch } from '@/lib/zoho/client';

export async function GET(request: Request) {
  const data = await zohoFetch('/inventory/v1/items', {
    params: {
      organization_id: process.env.ZOHO_ORGANIZATION_ID,
    },
  });

  return NextResponse.json(data);
}

Rate Limits

API Limit
OAuth Refresh ~100/minute
Inventory API 100/minute
Books API 100/minute

Debug Commands

# Check token
curl "https://www.tsh.sale/api/debug/token"

# Check prices
curl "https://www.tsh.sale/api/debug/prices"

# Check stock
curl "https://www.tsh.sale/api/debug/stock"

# Revalidate cache
curl "https://www.tsh.sale/api/revalidate?tag=all&secret=tsh-revalidate-2024"