Test before publishing

How to try a service with your own values while it is still a draft, using the test panel on the service page, and how this differs from the API tester.

What the test panel is

The test panel calculates with the workbook that is open in your browser. It needs no publishing and no saving, it makes no API call, and it does not count against your plan's calls. Use it to check that inputs reach the right cells and outputs show the right results.

Run a test

1. Open the service and stay on the Configuration (Konfiguration) tab so the workbook is loaded.
2. Define at least one input or output. The test button appears only then.
3. Click the play button at the top right, left of Save or Publish.
4. The panel Test Current Parameters (Aktuelle Parameter testen) opens with one field per input.
5. Enter values and click Calculate (Berechnen).
6. Read the outputs under Results (Ergebnisse).

Change a value and click Calculate again for the next test.

Reading the result

Three views are above the result:

• Result (Ergebnis): every output with its title and its value, formatted like the cell. A cell range is shown as a table, each column in its number format and with as many rows as its formulas fill.
• JSON: the inputs and outputs as data, with the calculation time.
• Request: the address your callers will use for these values once the service is published.

For the exact request, with the token and the request body as a caller sends them, use API → Test or API → Code after publishing. See The API tester and Code examples.

Test panel or API tester

A sensible order: test in the panel, save, publish, then make one real call in API → Test.

Limits

• The workbook must be loaded. If the panel says "The spreadsheet is not loaded. Please open the Configuration tab first.", open the Configuration tab, wait for the workbook and try again.
• The panel writes your test values into the input cells of the open workbook to calculate.
• The panel does not check a token and does not apply the per-minute or monthly limits. Those apply to real calls only.

Related

• Add inputs and Add outputs
• Input validation
• Publish, republish and unpublish

For developers and agents

• A panel test happens in the owner's browser. Nothing can be observed from outside and no call is logged.
• To verify a published service from outside, make a real call; see Call a service over the API.

FAQ

Can I test my service without publishing it?

Yes. Click the play button at the top right of the service page, enter values and click Calculate. The test runs on the draft in your browser.

Where is the test button?

It is the play button at the top right, left of Save or Publish. It appears once the service has at least one input or output.

Do tests in the panel count against my monthly calls?

No. The panel calculates in your browser and makes no API call. Calls from API → Test are real calls and do count.

Does the test use my unsaved changes?

Yes. The panel calculates with the workbook and parameters as they are open right now, saved or not.

Why does the panel say "Spreadsheet not loaded"?

The workbook is not loaded in this session yet. Open the Configuration tab, wait until the workbook is shown, then test again.

What is the difference between the test panel and API → Test?

The test panel calculates on your draft in the browser. API → Test sends a real call to the published service, with token and limits, exactly as your callers do.

The test result is right, but the API returns something else. Why?

The API answers from the published version, not from your draft. Save and republish, and send percentages as decimals; see Wrong or old results.

As an agent, can I trigger the test panel?

No, the panel is part of the owner's browser page. An agent tests a published service with a real call, or a draft through the account connection described in What a connected agent can do.