Quickbase Integration

Step 1: Setting Up the Quickbase Table

1. Log in to your Quickbase account.
2. Create a new Table:
   • Name: Shipping Cost API Integration.
3. Add Fields:
   • originZIP (Text)
   • destinationZIP (Text)
   • weight (Number)
   • cost (Number, for API results).

Step 2: Prepare Input Fields in QuickBase UI

1. Go to Form Builder for your table.
2. Add input fields:
   • originZIP, destinationZIP, weight.
3. Add a Save button to submit the form and trigger the pipeline.

Step 3: Create a Pipeline in Quickbase

1. Go to Pipelines → Create New Pipeline.
2. Set the Trigger:
   • Event: Record Created (when new data is submitted).
3. Map the form fields:
   • originZIP, destinationZIP, weight → Dynamic placeholders.

Step 4: Make an API Request to SpreadsheetWeb

1. Add a “Make Request” step to the pipeline.
2. Configure the API request:
   • Method: POST
   • Endpoint:

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

1. • Content-Type: application/json
2. Request Body:

{ "workspaceId": "your-workspace-id", "applicationId": "your-application-id", "inputs": { "originZIP": "{{a.originZIP}}", "destinationZIP": "{{a.destinationZIP}}", "weight": "{{a.weight}}" } }

Replace workspaceId and applicationId with your credentials.

1. Authentication (Optional):
   • If using token-based authentication, add a header:

Authorization: Bearer

Step 5: Update Quickbase with API Results

1. Add an Update Record step after the API request.
2. Map the API response to the cost field:
   • cost → {{b.response.outputs.cost}}
   • Replace b with the step reference for your API response.

Step 6: Test the System

1. Open the form and input test data:
   • originZIP, destinationZIP, and weight.
2. Click Save to trigger the pipeline.
3. Verify:
   • The pipeline runs successfully.
   • The cost field in the table is updated with the API result.