OpenAI Agents SDK WorkPaper Tools

import { Agent, RunContext, invokeFunctionTool, tool } from '@openai/agents'
import { z } from 'zod'
import { WorkPaper } from '@bilig/workpaper'

const workbook = WorkPaper.buildFromSheets({
  Inputs: [
    ['Metric', 'Value'],
    ['Qualified opportunities', 20],
    ['Win rate', 0.25],
    ['Average ARR', 12000],
  ],
  Summary: [
    ['Metric', 'Value'],
    ['Expected ARR', '=Inputs!B2*Inputs!B3*Inputs!B4'],
  ],
})

const setWorkPaperInputCell = tool({
  name: 'set_workpaper_input_cell',
  description: 'Set one validated WorkPaper input cell and return formula readback.',
  parameters: z.object({
    sheetName: z.literal('Inputs'),
    address: z.string().regex(/^[A-Z]+[1-9][0-9]*$/),
    value: z.union([z.string(), z.number(), z.boolean(), z.null()]),
  }),
  execute: async ({ sheetName, address, value }) => {
    const sheet = workbook.getSheetId(sheetName)
    const summarySheet = workbook.getSheetId('Summary')
    if (sheet === undefined) {
      throw new Error(`Unknown sheet: ${sheetName}`)
    }
    if (summarySheet === undefined) {
      throw new Error('Summary sheet is missing')
    }
    const cell = workbook.simpleCellAddressFromString(address, sheet)
    const summaryRange = workbook.simpleCellRangeFromString('Summary!A1:B2', summarySheet)
    if (cell === undefined) {
      throw new Error(`Invalid cell: ${sheetName}!${address}`)
    }
    if (summaryRange === undefined) {
      throw new Error('Summary range is invalid')
    }

    const before = workbook.getRangeValues(summaryRange)
    workbook.setCellContents(cell, value)

    return {
      editedCell: `${sheetName}!${address}`,
      before,
      after: workbook.getRangeValues(summaryRange),
    }
  },
})

const agent = new Agent({
  name: 'WorkPaper verification agent',
  instructions: 'Use WorkPaper tools and answer only from computed readback.',
  tools: [setWorkPaperInputCell],
})

const result = await invokeFunctionTool({
  tool: setWorkPaperInputCell,
  runContext: new RunContext(),
  input: JSON.stringify({
    sheetName: 'Inputs',
    address: 'B3',
    value: 0.4,
  }),
})

console.log(agent.name, result)

import { Agent, MCPServerStdio, RunContext, getAllMcpTools, invokeFunctionTool } from '@openai/agents'

const server = new MCPServerStdio({
  name: 'bilig-workpaper-stdio',
  fullCommand: 'npm run --silent agent:mcp-stdio',
  cwd: 'examples/headless-workpaper',
})

await server.connect()
try {
  const agent = new Agent({
    name: 'WorkPaper MCP verification agent',
    instructions: 'Answer only from computed WorkPaper MCP readback.',
    mcpServers: [server],
  })
  const runContext = new RunContext()
  const tools = await getAllMcpTools({
    mcpServers: [server],
    runContext,
    agent,
    convertSchemasToStrict: true,
  })
  const setInput = tools.find((tool) => tool.name === 'set_workpaper_input_cell')
  if (setInput === undefined) {
    throw new Error('Missing set_workpaper_input_cell')
  }

  const result = await invokeFunctionTool({
    tool: setInput,
    runContext,
    input: JSON.stringify({ sheetName: 'Inputs', address: 'B3', value: 0.4 }),
  })
  console.log(result)
} finally {
  await server.close()
}

import { Agent, MCPServerStreamableHttp, RunContext, getAllMcpTools, invokeFunctionTool } from '@openai/agents'

const server = new MCPServerStreamableHttp({
  name: 'bilig-workpaper-hosted',
  url: 'https://bilig.proompteng.ai/mcp',
  cacheToolsList: false,
  timeout: 15_000,
})

await server.connect()
try {
  const agent = new Agent({
    name: 'WorkPaper hosted MCP verification agent',
    instructions: 'Answer only from computed WorkPaper MCP readback.',
    mcpServers: [server],
  })
  const runContext = new RunContext()
  const tools = await getAllMcpTools({
    mcpServers: [server],
    runContext,
    agent,
    convertSchemasToStrict: true,
  })
  const setInput = tools.find((tool) => tool.name === 'set_cell_contents_and_readback')
  if (setInput === undefined) {
    throw new Error('Missing set_cell_contents_and_readback')
  }

  const result = await invokeFunctionTool({
    tool: setInput,
    runContext,
    input: JSON.stringify({
      sheetName: 'Inputs',
      address: 'B3',
      value: '=0.4',
      readbackRange: 'Summary!A1:B4',
    }),
  })
  console.log(result)
} finally {
  await server.close()
}