Prompt: Beag API Integration

Copy and paste this prompt into your AI assistant to set up full Beag API integration with database sync. Replace [YOUR_API_KEY] with your actual API key.

The Prompt

Integrate Beag API to sync subscription data for this SaaS application:

**Beag API Key:** [YOUR_API_KEY] (store in .env as BEAG_API_KEY)

## Beag API Reference

- Base URL: https://my-saas-basic-api-d5e3hpgdf0gnh2em.eastus-01.azurewebsites.net/api/v1/saas
- Endpoint: GET /clients/by-email/{email}
- Header: X-API-KEY: BEAG_API_KEY

Response format:
```json
{
  "email": "[email protected]",
  "status": "PAID",
  "plan_id": 123,
  "start_date": "2023-10-26T10:00:00Z",
  "end_date": "2024-10-26T10:00:00Z",
  "my_saas_app_id": "bgapp_xx_x.xxxxx",
  "client_id": 456
}
```

Possible status values: PAID, FAILED, CANCELLED, REFUNDED, PAUSED, RESUMED

## Implementation Requirements

### 1. Database Setup

- Check if a database already exists in the project
- If exists, check if a users table exists:
  - If users table exists: use it, add any missing fields listed below
  - If no users table: ASK ME before creating one
- If no database exists: ASK ME before setting up SQLite

User table fields:
- id (auto-increment primary key)
- email (unique)
- status
- plan_id
- start_date
- end_date
- client_id
- my_saas_app_id
- access_token
- last_synced
- created_at

### 2. Create API Endpoint to Add/Update User

Create an endpoint (e.g., POST /api/user/sync) that:
- Receives user data from client-side after successful login
- Expected payload from localStorage:
  ```json
  {
    "access_token": "x_access_token value",
    "email": "x_email value",
    "plan_id": "x_plan_id value",
    "start_date": "x_start_date value",
    "end_date": "x_end_date value",
    "status": "x_status value"
  }
  ```
- If user email doesn't exist in database: create new user
- If user email exists: update the existing record
- Update last_synced timestamp

### 3. Client-Side: Call Sync Endpoint Once Per Session

Add code that runs when user accesses the main app after login:
- Only sync once per browser session (use sessionStorage flag)
- Get data from localStorage
- Call the sync endpoint to add/update user in database

```javascript
// Reference implementation
async function syncUserToDatabase() {
  const accessToken = localStorage.getItem("x_access_token");
  if (!accessToken) return;

  if (sessionStorage.getItem("beag_synced")) return;

  const userData = {
    access_token: accessToken,
    email: localStorage.getItem("x_email"),
    plan_id: localStorage.getItem("x_plan_id"),
    start_date: localStorage.getItem("x_start_date"),
    end_date: localStorage.getItem("x_end_date"),
    status: localStorage.getItem("x_status")
  };

  try {
    await fetch("/api/user/sync", {
      method: "POST",
      headers: { "Content-Type": "application/json" },
      body: JSON.stringify(userData)
    });
    sessionStorage.setItem("beag_synced", "true");
  } catch (error) {
    console.error("Failed to sync user:", error);
  }
}

syncUserToDatabase();
```

### 4. Create Beag Sync Function (Server-Side)

```javascript
async function syncUserFromBeag(email) {
  // 1. Call Beag API: GET /clients/by-email/{email}
  // 2. If user exists in database: update their record
  // 3. If user doesn't exist: create new record
  // 4. Update last_synced timestamp
  // 5. Return the user data
}
```

### 5. Create Scheduled Worker

Detect the backend framework and implement accordingly:
- Node.js/Express: use node-cron
- Next.js: use Vercel Cron or route handler with cron
- Python/FastAPI/Flask: use APScheduler or Celery
- Other: suggest appropriate scheduler

The worker should:
- Run every 1 hour
- Fetch all users from database
- For each user, call Beag API and update their subscription data
- Log sync results

### 6. Security

- Store BEAG_API_KEY in .env file
- Never expose API key to client-side code
- All Beag API calls must be server-side only

## Show me:
1. What database/user table was detected (or ask me before creating)
2. All created/modified files
3. How to start/test the worker