Tadabase Integration

Step 1: Configuring the SpreadsheetWeb API in Tadabase

1.1 Set Up API Authentication

1. Go to Settings → Data Sources → External API in Tadabase.
2. If OAuth 2.0 is required:

   • Authorization URL:

     https://hub.spreadsheetweb.com/identity/connect/token

   • Client ID and Client Secret: Use the credentials provided by SpreadsheetWeb.

3. Save the configuration.

1.2 Add a New API Call

1. Go to API Calls → Add New API Call.

2. Configure the API call:

   • Method: POST

   • Endpoint:

     https://api.spreadsheetweb.com/calculations/calculatesinglesimple

3. Headers:

   Content-Type: application/json Authorization: Bearer {oauth_token} (if using OAuth)

4. Body:

   { "workspaceId": "your-workspace-id", "applicationId": "your-application-id", "inputs": { "Input1": "{Input1}", "Input2": "{Input2}", "Table1": "{Table1}" }, "outputs": ["Output1", "Output2", "Table2"] }

   Replace placeholders ({Input1}, {Input2}) with dynamic form inputs.

5. Test the API: Send a sample request and verify the response.

Step 2: Build the Tadabase User Interface

2.1 Create an Input Form

1. Go to the Pages section and create a new form.
2. Add fields:
   • Text Inputs: For Input1 and Input2.
   • Table Input: For Table1 if required.
3. Bind form fields to the API call placeholders.

2.2 Add a Submit Button

1. Create a button to trigger the API call.
2. Set the button’s action to execute the API call.

Step 3: Display API Results

3.1 Configure Output Fields

1. Go to API Calls → Select the configured call.
2. In the Response tab:

   • Define outputs:

     response.outputs.Output1 → Output1 response.outputs.Output2 → Output2

     • Set the Data Type (e.g., String for single values).

3.2 Display Results in the UI

1. Add text fields or tables to display the output data dynamically.
2. Map the output fields to the UI elements.

Step 4: Test the Application

1. Submit sample inputs through the form.
2. Verify that the results from the SpreadsheetWeb API are displayed correctly.