View as Markdown
Bilig WorkPaper icon

Bilig WorkPaper ACTION

Verify Formula Readback

Write a Bilig WorkPaper forecast input cell and return verified recalculated formula output. See the documentation
  • Action
  • Writes data
  • API key
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Bilig WorkPaper account once, then configure and run Verify Formula Readback from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "bilig_workpaper-verify-formula-readback",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    bilig_workpaper: { authProvisionId: "apn_xxxxxxx" },
    sheetName: "Sheet Name",
    address: "Cell",
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Verify Formula Readback inputs
Property Type Description
sheetName Sheet Name string
Forecast input sheet to edit. Example: Inputs.
Required
address Cell string
Editable forecast input cell.
Required
value Value integer
Numeric value to write before formula readback.
Required
valueDivisor Value Divisor integer
Divide Value by this number before sending. Use 100 for percentages like 40 -> 0.4.
Required

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
bilig_workpaper-verify-formula-readback
Version
0.0.1
App
Bilig WorkPaper
Authentication
API key
Read-only
No
Destructive
No
Open world
Yes