JavaScript API

const dataUrl = window.risksheet.dataUrlTemplate({
  baseUrl: window.risksheet.baseUrl,
  projectId: 'PROJ001',
  documentId: 'risksheet-v1',
  revision: '2024-01-15'
});
// Result: /risksheet/api/data?project=PROJ001&doc=risksheet-v1&rev=2024-01-15

{
  id: 'severity',
  header: 'Severity',
  type: 'enum',
  binding: 'fields.severity',
  width: 120,
  sortable: true,
  filterable: true,
  editable: true,
  dataSource: 'SeverityEnum',
  tooltip: 'Risk severity rating'
}

{
  task: {
    type: 'Task',           // Polarion work item type
    role: 'mitigates',       // Link role to parent risk
    name: 'Mitigation Task', // Display name
    zoomColumn: 'id',
    showInMenu: true
  }
}

const severityEnum = window.risksheet.enums['SeverityEnum'];
if (severityEnum) {
  severityEnum.values.forEach(value => {
    console.log(`${value.id}: ${value.name}`);
  });
}

const relations = window.risksheet.relations;
const mitigatesRelation = relations.find(r => r.role === 'mitigates');
if (mitigatesRelation) {
  console.log(`From: ${mitigatesRelation.fromType}`);
  console.log(`To: ${mitigatesRelation.toType}`);
}

// Fetch document metadata
fetch(`${window.risksheet.baseUrl}/api/document`)
  .then(r => r.json())
  .then(metadata => {
    console.log('Version:', metadata.version);
    console.log('Revision:', metadata.revision);
    console.log('License Status:', metadata.licenseStatus);
  });

// Keep-alive endpoint prevents automatic logout
setInterval(() => {
  fetch(`${window.risksheet.baseUrl}/api/keepalive`)
    .catch(e => console.error('Keep-alive failed:', e));
}, 5 * 60 * 1000); // Every 5 minutes

if (window.risksheet.appConfig.readonly) {
  console.log('RISKSHEET is in read-only mode');
  console.log('Viewing revision:', window.risksheet.revision);
}

// Access column rendering context
const columnContext = {
  column: window.risksheet.appConfig.columns[0],
  data: rowData,
  settings: window.risksheet.appConfig
};

// Listen for configuration changes
document.addEventListener('risksheet:config-changed', (event) => {
  console.log('Config updated:', event.detail.changes);
});

// Listen for data refresh
document.addEventListener('risksheet:data-refreshed', (event) => {
  console.log('Grid refreshed at:', new Date());
});

const culture = window.risksheet.appConfig.global.culture;
console.log('Current culture:', culture); // e.g., 'en-US', 'de-DE'

// Format dates according to culture
const formatter = new Intl.DateTimeFormat(culture);
const formatted = formatter.format(new Date());

if (window.risksheet.debug) {
  console.log('Debug output enabled');
  console.log('Full config:', window.risksheet.appConfig);
  console.log('Available enums:', window.risksheet.enums);
}