Airtable을 소셜 미디어에 연결하는 방법

// Airtable Scripting Extension
let table = base.getTable('콘텐츠 캘린더');
let query = await table.selectRecordsAsync();
let record = query.records.find(r => r.getCellValue('상태')?.name === 'Ready');

if (!record) {
  output.text('No records with Status = Ready');
} else {
  let formData = new FormData();
  formData.append('video_url', record.getCellValue('비디오 URL'));
  formData.append('title', record.getCellValue('캡션'));
  formData.append('user', 'mybrand');
  formData.append('platform[]', 'tiktok');
  formData.append('platform[]', 'instagram');

  let response = await fetch('https://api.upload-post.com/api/upload', {
    method: 'POST',
    headers: { '권한 부여': 'API 키 your-api-key-here' },
    body: formData
  });

  let result = await response.json();
  await table.updateRecordAsync(record, {
    '상태': { name: '게시됨' },
    '작업 ID': result.job_id
  });
  output.text('Published! Job ID: ' + result.job_id);
}

// Airtable Automation Script
let inputConfig = input.config();
let table = base.getTable('콘텐츠 캘린더');
let record = await table.selectRecordAsync(inputConfig.recordId);

let platforms = record.getCellValue('플랫폼');
let formData = new FormData();
formData.append('video_url', record.getCellValue('비디오 URL'));
formData.append('title', record.getCellValue('캡션'));
formData.append('user', 'mybrand');

for (let p of platforms) {
  formData.append('platform[]', p.name.toLowerCase());
}

let response = await fetch('https://api.upload-post.com/api/upload', {
  method: 'POST',
  headers: { '권한 부여': 'API 키 your-api-key-here' },
  body: formData
});

let result = await response.json();
await table.updateRecordAsync(record.id, {
  '상태': { name: '게시됨' },
  '작업 ID': result.job_id
});

// Add scheduling support
let scheduledDate = record.getCellValue('예약된 날짜');

if (scheduledDate) {
  formData.append('scheduled_date', new Date(scheduledDate).toISOString());
  formData.append('timezone', '미국/뉴욕');
}

// Or use the queue for automatic optimal timing
formData.append('add_to_queue', 'true');

// Batch publish all Ready records
let table = base.getTable('콘텐츠 캘린더');
let query = await table.selectRecordsAsync();
let readyRecords = query.records.filter(
  r => r.getCellValue('상태')?.name === 'Ready'
);

output.text('Found ' + readyRecords.length + ' records to publish');

for (let record of readyRecords) {
  let platforms = record.getCellValue('플랫폼');
  let formData = new FormData();
  formData.append('video_url', record.getCellValue('비디오 URL'));
  formData.append('title', record.getCellValue('캡션'));
  formData.append('user', 'mybrand');

  for (let p of platforms) {
    formData.append('platform[]', p.name.toLowerCase());
  }

  let scheduledDate = record.getCellValue('예약된 날짜');
  if (scheduledDate) {
    formData.append('scheduled_date', new Date(scheduledDate).toISOString());
  }

  try {
    let response = await fetch('https://api.upload-post.com/api/upload', {
      method: 'POST',
      headers: { '권한 부여': 'API 키 your-api-key-here' },
      body: formData
    });
    let result = await response.json();
    await table.updateRecordAsync(record, {
      '상태': { name: '게시됨' },
      '작업 ID': result.job_id
    });
    output.text('Published: ' + record.getCellValue('캡션'));
  } catch (err) {
    await table.updateRecordAsync(record, {
      '상태': { name: '실패' }
    });
    output.text('Failed: ' + record.getCellValue('캡션'));
  }
}

// Check upload status and update Airtable
let table = base.getTable('콘텐츠 캘린더');
let query = await table.selectRecordsAsync();
let pendingRecords = query.records.filter(
  r => r.getCellValue('상태')?.name === '게시됨'
    && r.getCellValue('작업 ID')
);

for (let record of pendingRecords) {
  let jobId = record.getCellValue('작업 ID');
  let response = await fetch(
    'https://api.upload-post.com/api/uploadposts/status?job_id=' + jobId,
    { headers: { '권한 부여': 'API 키 your-api-key-here' } }
  );
  let status = await response.json();

  if (status.status === 'completed') {
    await table.updateRecordAsync(record, {
      '상태': { name: 'Live' }
    });
  } else if (status.status === 'failed') {
    await table.updateRecordAsync(record, {
      '상태': { name: '실패' }
    });
  }
}