Skip to main content

Caspeco

Connect Exopen to Caspeco to ingest data from Caspeco's dynamic reports (RMS) — for example payroll, staff costs, and other report data exposed in your Caspeco system.

Manual setup

Caspeco is connected manually by Exopen support. There is no self-service flow in the portal today — instead you gather the credentials from Caspeco and email them to us following the steps below.

Prerequisites​

Before we can connect, Caspeco needs to expose the reports you want to bring into Exopen via their external reports API and issue access credentials for each report. Reach out to your contact at Caspeco to obtain these.

Step 1: Gather the credentials from Caspeco​

For each report you want to connect we need the following four fields, exactly as Caspeco provides them:

  • name — Caspeco's identifier for the report. Format: {GUID}_{ReportName}.
  • token — Bearer token granting read access to that specific report.
  • system — System identifier for your Caspeco tenant (e.g. se_example). The same across all reports for the same company.
  • parameters — JSON describing the dimension constraints that filter the report per period. This structure is report-specific and comes from Caspeco — forward it to us exactly as you receive it.
info

The token and system identifier grant access to your Caspeco data and should be treated as passwords.

Example​

Send the credentials as a JSON array — one entry per report. A single entry looks like this:

{
  "name": "00000000-0000-0000-0000-000000000000_PayrollFollowup",
  "token": "ABCDEF1234567890ABCDEF1234567890ABCDEF1234567890ABCDEF1234567890-1",
  "system": "se_example",
  "parameters": {
    "dimensionConstraints": {
      "Payroll": [
        {
          "id": "dimension.period",
          "values": ["<from>", "<to>"],
          "valueType": "DateTime",
          "constraintType": "Range"
        }
      ]
    }
  }
}

Keep the <from> and <to> placeholders — Exopen fills them in for each sync run.

Step 2: Send the credentials to Exopen support​

Email support@exopen.se and include:

  • Which Exopen company the data source should be linked to.
  • The JSON array from Step 1, with one entry per report.
  • An optional historical start date per report if you know it. Otherwise we sync as far back as Caspeco returns data.

We set up the connection and trigger the first sync once we have the credentials.

Sync behaviour​

Exopen fetches each report month by month. The initial run backfills history as far as Caspeco returns data. After that, new months are synced continuously, and the most recent months are re-fetched on a recurring basis so that any corrections in Caspeco are picked up.

Maintaining the connection​

If you need to add new reports, swap out a token (for example after a rotation in Caspeco), or remove a report — email support@exopen.se with the new or updated JSON entry.