Sellstory Open API v1

{
  "workspaceId": "your-workspace-id",
  "requestedBy": "your-email@company.com",
  "purpose": "Integration with CRM System",
  "environment": "production"
}

{
  "success": true,
  "data": {
    "apiKey": "sk_live_xxxxxxxxxxxxxxxx",
    "apiSecret": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "environment": "production",
    "scopes": ["customer:read", "customer:write", "product:read", "product:write", "card:read", "card:write", "card:delete", "board:read", "lane:read", "member:read"],
    "rateLimit": 100,
    "createdAt": "2025-11-06T07:00:00.000Z"
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "success": true,
  "data": {
    "accessToken": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...",
    "tokenType": "Bearer",
    "expiresIn": 3600,
    "scope": "customer:read customer:write product:read product:write"
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

Authorization: Bearer {accessToken}
Content-Type: application/json

Authorization: Bearer {accessToken}
Content-Type: application/json

GET /api/v1/products?page=1&limit=10&category=เสื้อผ้า&inStock=true&sortBy=price&sortOrder=asc
Authorization: Bearer {accessToken}

{
  "success": true,
  "data": {
    "products": [
      {
        "id": "prod123xyz",
        "sku": "SKU-001",
        "barcode": "8850999320014",
        "name": "เสื้อยืดคอกลม สีขาว",
        "price": 299,
        "availableStock": 75,
        "category": "เสื้อผ้า",
        "status": "active"
      }
    ],
    "pagination": {
      "page": 1,
      "limit": 10,
      "total": 1,
      "totalPages": 1,
      "hasMore": false
    }
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

Authorization: Bearer {accessToken}
Content-Type: application/json

{
  "status": "In Progress",
  "priority": "Urgent",
  "customFields": [ { "templateFieldUid": "fld_area", "value": "ทั้งบ้าน" } ]
}

{
  "success": true,
  "data": { "id": "card_XYZ", "action": "soft-deleted" },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "success": true,
  "data": {
    "boards": [
      { "id": "board_abc", "name": "Sales Pipeline", "order": 0, "memberCount": 5 }
    ],
    "pagination": { "page": 1, "limit": 50, "total": 1, "totalPages": 1, "hasMore": false }
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "success": true,
  "data": {
    "lanes": [
      { "id": "lane_def", "name": "To Do", "order": 0, "boardId": "board_abc", "rules": [] }
    ]
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "success": true,
  "data": {
    "boardId": "board_abc",
    "customFields": [
      { "templateFieldUid": "fld_area", "name": "พื้นที่", "type": "text", "options": [], "required": false },
      { "templateFieldUid": "fld_type", "name": "ประเภทงาน", "type": "select", "options": ["ติดตั้ง", "ซ่อม"], "required": true }
    ]
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "success": true,
  "data": {
    "members": [
      { "uid": "uid_seller_7", "displayName": "สมชาย", "email": "somchai@company.com", "photoURL": null }
    ],
    "pagination": { "page": 1, "limit": 100, "total": 1, "totalPages": 1, "hasMore": false }
  },
  "requestId": "req_xxxxxxxxxxxxx"
}

{
  "error": "error_code",
  "message": "Human readable error message",
  "details": {
    "additional": "error details"
  },
  "requestId": "req_xxxxxxxxxxxxx",
  "timestamp": "2025-11-06T07:00:00.000Z"
}

// 1. Get JWT Token
async function getAccessToken() {
  const response = await fetch('/api/v1/auth/token', {
    method: 'POST',
    headers: { 'Content-Type': 'application/json' },
    body: JSON.stringify({
      apiKey: 'your-api-key',
      apiSecret: 'your-api-secret'
    })
  });
  const data = await response.json();
  return data.data.accessToken;
}

// 2. Create Customer
async function createCustomer(token, customerData) {
  const response = await fetch('/api/v1/customers/upsert', {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      'Authorization': `Bearer ${token}`,
      'Idempotency-Key': `create-${Date.now()}`
    },
    body: JSON.stringify(customerData)
  });
  return response.json();
}

// 3. List Customers
async function listCustomers(token, page = 1, limit = 20) {
  const response = await fetch(
    `/api/v1/customers?page=${page}&limit=${limit}`,
    {
      headers: { 'Authorization': `Bearer ${token}` }
    }
  );
  return response.json();
}

async function callAPIWithRetry(url, options, maxRetries = 3) {
  for (let i = 0; i < maxRetries; i++) {
    const response = await fetch(url, options);

    // Check rate limit headers
    const remaining = parseInt(response.headers.get('X-RateLimit-Remaining'));
    console.log(`API calls remaining: ${remaining}`);

    if (response.status === 429) {
      const retryAfter = parseInt(response.headers.get('Retry-After'));
      console.log(`Rate limited. Retry after ${retryAfter} seconds`);
      await new Promise(resolve => setTimeout(resolve, retryAfter * 1000));
      continue;
    }

    return response;
  }

  throw new Error('Max retries exceeded');
}

// Core pattern (ไฟล์เต็มพร้อมเมนู UI + sync ทั้งชีต อยู่ที่
// testscript/google-apps-script/SellstoryOrderSync.gs)

var CONFIG = {
  BASE_URL: 'https://openapi.sellstory.me/',
  WORKSPACE_ID: 'your-workspace-id'
};

function httpJson_(method, path, token, body) {
  var options = {
    method: method,
    muteHttpExceptions: true,
    headers: {
      'User-Agent': 'Mozilla/5.0 (compatible; SellstoryGoogleSheetsSync/1.0)',
      'Accept': 'application/json'
    }
  };
  if (token) options.headers.Authorization = 'Bearer ' + token;
  if (body) {
    options.contentType = 'application/json';
    options.payload = JSON.stringify(body);
  }
  var res = UrlFetchApp.fetch(CONFIG.BASE_URL + path, options);
  return { status: res.getResponseCode(), json: JSON.parse(res.getContentText()) };
}

function syncRowToJobCard(token, boardId, laneId, row) {
  var jobcard = httpJson_('POST', '/api/v1/jobcards', token, {
    boardId: boardId,
    laneId: laneId,
    title: '[GSHEET] ' + row.customerName,
    status: 'Pending',
    items: [{ productId: row.productId, name: row.productName, quantity: row.qty, pricePerUnit: row.price }]
  });
  return jobcard.json.data;
}