Site icon SpreadsheetWeb Help

Bubble.io Integration

admin

Step 1: Install API Connector Plugin

  1. Log into Bubble.io and open your project.
  2. Navigate to Plugins > Add Plugin > Search for API Connector > Install.

Step 2: Configure the SpreadsheetWeb API

  1. Open API Connector > Add another API.
  2. Name it (e.g., “SSWeb API”).
  3. Set Authentication to None or self-handled.

API Call Configuration:

  • Name: CalculateSimple
  • Method: POST
  • API Endpoint:
https://api.spreadsheetweb.com/calculations/calculatesinglesimple
  • Headers:
Content-Type: application/json  
Authorization: Bearer <your-token> (if using token-based authentication)
  • Body:
{
  "workspaceId": "<workspaceId>",
  "applicationId": "<applicationId>",
  "inputs": {
    "Input1": "<Input1>",
    "Input2": "<Input2>",
    "Table1": "<Table1>"
  },
  "outputs": ["Output1", "Output2", "Table2"]
}

Step 3: Design the User Interface

  1. Input Fields:
    • Add Text Input fields for Input1 and Input2.
    • Add a Multiline Input for Table1 (if table input is required).
  2. Output Fields:
    • Add Text elements for Output1 and Output2.
    • Use a Repeating Group for Table2 to display tabular data dynamically.
  3. Submit Button:
    • Add a button to trigger the API call.

Step 4: Configure the Workflow

  1. Go to the Workflows tab.
  2. Create a new workflow triggered by the Submit Button.
  3. Add the API Call:
    • Map inputs dynamically:
      • Input1 → Value of Input1 Field
      • Input2 → Value of Input2 Field
      • Table1 → Value of Table1 Field
  4. Display Results:
    • Set Output1 to Result of API call → response → Output1.
    • Set Output2 to Result of API call → response → Output2.
    • Use a Repeating Group to display Table2 data.

Step 5: Test the Integration

  1. Go to Preview Mode.
  2. Enter test values in Input1, Input2, and Table1.
  3. Click Submit and confirm that the outputs display correctly.
Exit mobile version