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
    • 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 <your-token>

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.