Bulk Export Deals

curl -X POST https://app.usehindsight.com/api/v1/deals/export \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "columns": ["name", "amount", "deal_status", "close_date", "owner_id"]
  }'

curl -X POST https://app.usehindsight.com/api/v1/deals/export \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "columns": [
      "name", "amount", "deal_status", "close_date",
      "drivers", "scorecard", "all_competitors", "summary"
    ],
    "filters": {
      "status": ["closedwon", "closedlost"],
      "close_date": {
        "from": "2026-01-01",
        "to": "2026-03-31"
      },
      "analyzed": true
    }
  }'

curl -X POST https://app.usehindsight.com/api/v1/deals/export \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "columns": [
      "name", "amount", "deal_status", "all_competitors",
      "drivers", "scorecard"
    ],
    "filters": {
      "competitors": ["comp_abc", "comp_xyz"],
      "competitors_filter_type": "is any of",
      "status": ["Lost"]
    }
  }'

curl https://app.usehindsight.com/api/v1/deals/export/exp_abc123 \
  -H "Authorization: Bearer YOUR_API_KEY"

const response = await fetch('https://app.usehindsight.com/api/v1/deals/export', {
  method: 'POST',
  headers: {
    'Authorization': `Bearer ${API_KEY}`,
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    columns: ['name', 'amount', 'deal_status', 'close_date', 'owner_id'],
    filters: {
      status: ['closedwon', 'closedlost'],
      close_date: {
        from: '2026-01-01',
        to: '2026-03-31'
      }
    }
  })
});

const { export_id } = await response.json();
console.log('Export started:', export_id);

async function waitForExport(exportId) {
  while (true) {
    const response = await fetch(
      `https://app.usehindsight.com/api/v1/deals/export/${exportId}`,
      {
        headers: { 'Authorization': `Bearer ${API_KEY}` }
      }
    );
    
    const status = await response.json();
    
    if (status.status === 'completed') {
      console.log('Export ready!', status.download_url);
      return status.download_url;
    } else if (status.status === 'failed') {
      throw new Error(`Export failed: ${status.error}`);
    }
    
    // Wait 5 seconds before checking again
    await new Promise(resolve => setTimeout(resolve, 5000));
  }
}

const downloadUrl = await waitForExport('exp_abc123');

import requests
import time

API_KEY = 'your_api_key_here'
BASE_URL = 'https://app.usehindsight.com/api/v1'

# Start export
response = requests.post(
    f'{BASE_URL}/deals/export',
    headers={
        'Authorization': f'Bearer {API_KEY}',
        'Content-Type': 'application/json'
    },
    json={
        'columns': ['name', 'amount', 'deal_status', 'close_date'],
        'filters': {
            'status': ['closewon', 'closedlost'],
            'analyzed': True
        }
    }
)

export_id = response.json()['export_id']
print(f'Export started: {export_id}')

# Poll for completion
while True:
    status_response = requests.get(
        f'{BASE_URL}/deals/export/{export_id}',
        headers={'Authorization': f'Bearer {API_KEY}'}
    )
    
    status = status_response.json()
    
    if status['status'] == 'completed':
        print(f'Export ready! Download from: {status["download_url"]}')
        print(f'Rows exported: {status["rows_exported"]}')
        break
    elif status['status'] == 'failed':
        print(f'Export failed: {status["error"]}')
        break
    
    print('Export still processing...')
    time.sleep(5)