Bubble.io Integration

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 (if using token-based authentication)

• Body:

{ "workspaceId": "", "applicationId": "", "inputs": { "Input1": "", "Input2": "", "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.