Skip to content

API reference

Data and BI

The analytics dataset Bizisy delivers to data tools (its schema and version), the OData feed's address and BI token status, pay sharing, and each export destination's last delivery. Exports themselves are connected tools (BigQuery, Cloud Storage, S3, Azure Blob). Creating the BI token and sharing pay happen in the web app.

5 actions · base URL https://api.bizisy.com/v1 · generated from the same definitions as the API.

Data and BI settings#

POST/v1/data/settings.getRead

What this company shares with data and BI tools: the OData feed address for Power BI and Excel (feed_url), whether a BI token exists (its last four characters, when it was made and last used; the token itself is shown only once, when created), whether pay is shared (pay.shared: off unless an owner, admin or HR member turned it on in Bizisy), whether Looker Studio is available, the dataset schema version, the federation details a cloud needs to trust Bizisy (issuer, this company's audience and subject; null when this server does not offer keyless delivery) and each export destination's last delivery. Owners, admins and HR. Part of the Reports & analytics module (included): companies with it switched off get module_disabled (an owner or admin switches it on in Manage → Settings → Modules); this read of stored data keeps working while it is off.

Who can call it
Manage key owner admin hr
MCP tool
data_settings_get on HR Assistant
Method
POST with a JSON body, or GET with the input as query parameters

Input

No input: send {}.

Returns

7 fields
  • feed_urlstringrequired
  • tokenobject | nullrequired
    3 fields
    • last4stringrequired
    • created_atstringrequired
    • last_used_atstring | nullrequired
  • payobjectrequired
    2 fields
    • sharedbooleanrequired
    • changed_atstring | nullrequired
  • looker_studioobjectrequired
    2 fields
    • availablebooleanrequired
    • urlstring | nullrequired
  • federationobject | nullrequired
    3 fields
    • issuerstringrequired
    • audiencestringrequired
    • subjectstringrequired
  • schema_versionintegerrequired
  • exportsobject[]required
    8 fields
    • connectorstringrequired
    • last_slotstring | nullrequired
    • last_delivered_atstring | nullrequired
    • rowsintegerrequired
    • bytesintegerrequired
    • tablesintegerrequired
    • formatstring | nullrequired
    • locationstring | nullrequired

Errors

validation_failed unauthenticated forbidden not_found rate_limited internal

curl
curl https://api.bizisy.com/v1/data/settings.get \
  -H "Authorization: Bearer $BIZISY_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
Response
{
  "data": {
    "feed_url": "https://api.bizisy.com/odata/v1/",
    "token": {
      "last4": "x7Qa",
      "created_at": "2026-10-03T09:12:00.000Z",
      "last_used_at": "2026-10-04T08:00:00.000Z"
    },
    "pay": {
      "shared": false,
      "changed_at": null
    },
    "looker_studio": {
      "available": true,
      "url": "https://lookerstudio.google.com/datasources/create?connectorId=AKfycb-example"
    },
    "federation": {
      "issuer": "https://api.bizisy.com/federation",
      "audience": "https://api.bizisy.com/federation/org/o1",
      "subject": "org:o1"
    },
    "schema_version": 1,
    "exports": [
      {
        "connector": "gcs",
        "last_slot": "2026-10-04",
        "last_delivered_at": "2026-10-04T05:00:12.000Z",
        "rows": 1240,
        "bytes": 318000,
        "tables": 9,
        "format": "parquet",
        "location": "gs://acme-hr/bizisy"
      }
    ]
  }
}

Data export schema#

POST/v1/data/schema.getRead

The analytics dataset Bizisy delivers to data tools (exports to BigQuery, Cloud Storage, S3, Azure Blob; the OData feed; Looker Studio): its version and tables (people as of a day, jobs history, teams, locations, legal entities, positions, monthly headcount, headcount by team, checklists, and pay only while pay sharing is on), each with its key and columns (name, type: string, date, integer, number, boolean, timestamp; custom: this company's own custom fields of public and job tier). Private details are never in it, and nothing planned after the day it describes. Owners, admins and HR. Part of the Reports & analytics module (included): companies with it switched off get module_disabled (an owner or admin switches it on in Manage → Settings → Modules); this read of stored data keeps working while it is off.

Who can call it
Manage key owner admin hr
MCP tool
data_schema_get on HR Assistant
Method
POST with a JSON body, or GET with the input as query parameters

Input

No input: send {}.

Returns

  • schema_versionintegerrequired
  • paybooleanrequired
  • tablesobject[]required
    4 fields
    • namestringrequired
    • descriptionstringrequired
    • keystring[]required
    • columnsobject[]required
      4 fields
      • namestringrequired
      • type"string" | "date" | "integer" | "number" | "boolean" | "timestamp"required
      • descriptionstringrequired
      • customboolean

Errors

validation_failed unauthenticated forbidden not_found rate_limited internal

curl
curl https://api.bizisy.com/v1/data/schema.get \
  -H "Authorization: Bearer $BIZISY_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
Response
{
  "data": {
    "schema_version": 1,
    "pay": false,
    "tables": [
      {
        "name": "people",
        "description": "One row per person employed on as_of, with their job that day.",
        "key": [
          "person_id"
        ],
        "columns": [
          {
            "name": "person_id",
            "type": "string",
            "description": "Person id (stable)."
          },
          {
            "name": "start_date",
            "type": "date",
            "description": "First day of the current employment."
          },
          {
            "name": "fte",
            "type": "number",
            "description": "Full-time equivalent (1 = full time)."
          },
          {
            "name": "custom_shirt_size",
            "type": "string",
            "description": "Custom field \"Shirt size\" (select).",
            "custom": true
          }
        ]
      }
    ]
  }
}

Create a BI token#

POST/v1/data/feed.token_createWrite

Creates the company's BI token for Power BI, Excel and Looker Studio (read-only: it can only read the analytics dataset through the OData feed; never anyone's private details, pay only while pay sharing is on). The token is shown once in the result: copy it into the BI tool (Power BI and Excel: Basic, any user name, the token as password). A company has one: creating another replaces it and the old one stops working at once. Owners and admins, in the app only. Part of the Reports & analytics module (included): companies with it switched off get module_disabled (an owner or admin switches it on in Manage → Settings → Modules).

Web app only
Refused for API keys and connected apps. An owner or admin creates the BI token in the app (Integrations → Power BI and Excel → Access): it is shown once there.
MCP tool
data_feed_token_create on HR Assistant
Preview
?dry_run=true runs every check and saves nothing
Retries
An Idempotency-Key prevents a second run, but the result is never stored (it holds a secret or personal data): a retry gets a 409 that points to Activity

Input

No input: send {}.

Returns

  • tokenstringrequired

    Shown once.

  • last4stringrequired
  • replacedbooleanrequired
  • feed_urlstringrequired

Errors

validation_failed unauthenticated forbidden not_found conflict rate_limited internal

curl
curl https://api.bizisy.com/v1/data/feed.token_create \
  -H "Authorization: Bearer $BIZISY_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{}'
Response
{
  "data": {
    "token": "bzbi_o1_shown-once-copy-it-now",
    "last4": "x7Qa",
    "replaced": false,
    "feed_url": "https://api.bizisy.com/odata/v1/"
  }
}

Revoke the BI token#

POST/v1/data/feed.token_revokeDestructive

Revokes the company's BI token: Power BI, Excel and Looker Studio reports using it stop refreshing at once (what they already loaded stays in them). Owners and admins, in the app only.

Web app only
Refused for API keys and connected apps. Revoking the BI token happens in the app.
MCP tool
data_feed_token_revoke on HR Assistant
Preview
?dry_run=true runs every check and saves nothing
Retries
An Idempotency-Key replays the first result

Input

No input: send {}.

Returns

  • revokedtruerequired

Errors

validation_failed unauthenticated forbidden not_found conflict rate_limited internal

curl
curl https://api.bizisy.com/v1/data/feed.token_revoke \
  -H "Authorization: Bearer $BIZISY_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{}'
Response
{
  "data": {
    "revoked": true
  }
}

Share pay with data tools#

POST/v1/data/pay.setWrite

Turns pay sharing with data tools on or off (share). On: exports and the BI feed include the pay table (everyone's pay history) and positions' pay ranges, to every destination this company connected and every report that uses the BI token. Off (the default): they never contain pay. Takes effect at the next delivery or refresh; files already delivered keep what they had. Recorded in Activity. Owners, admins and HR, in the app only.

Web app only
Refused for API keys and connected apps. Sharing pay with data tools is a person's choice in the app (Integrations → Power BI and Excel → Access), recorded in Activity.
MCP tool
data_pay_set on HR Assistant
Preview
?dry_run=true runs every check and saves nothing
Retries
An Idempotency-Key replays the first result

Input

  • sharebooleanrequired

Returns

  • sharedbooleanrequired
  • changedbooleanrequired

Errors

validation_failed unauthenticated forbidden not_found conflict rate_limited internal

curl
curl https://api.bizisy.com/v1/data/pay.set \
  -H "Authorization: Bearer $BIZISY_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{"share":false}'
Response
{
  "data": {
    "shared": true,
    "changed": true
  }
}

Something missing or wrong on this page? Write to hello@bizisy.com.

Developer docs