Step 1: Create a New Flow in Parabola.io

  1. Log in to Parabola.io.
  2. From the Dashboard, click New Flow to open a blank canvas for your workflow.

Step 2: Add the Pull From API Step

  1. In the left-hand control bar, click Integration.
  2. Under Triggers/API, select Pull From API.
  3. Drag the Pull From API step onto the canvas.

Step 3: Configure the API Request

  1. Select the Pull From API step to open its settings.
  2. Configure the following:
    • Request Type: POST
    • API Endpoint:

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

    • Request Body:
      Paste the following JSON structure:
      { "request": { "workspaceId": "your-workspace-id", "applicationId": "your-application-id", "inputs": { "originZIP": "10001", "destinationZIP": "90001", "weight": "1" }, "outputs": ["cost"] } }
    • Content-Type: application/json

5.1 Add or Rename Columns

  1. Use Parabola’s Transform tools to clean or enhance the data:
    • Add Column: Manually add a response column.
    • Rename Column: Standardize column names for clarity.

                5.2 Remove Unnecessary Columns

  1. Select columns you don’t need and remove them to keep the output clean.

Step 6: Save the Data to a Parabola Table

  1. In the Integration menu, select Send to Parabola Table.
  2. Drag the step onto the canvas and connect it to your Pull From API step.
  3. Configure it to save the API response (e.g., the cost field) into a table.

Bonus Tip: Use Dynamic Data Sources

  1. If you’re using external inputs:
    • Add a Pull Data From… step at the start of your flow.
    • Map the dynamic inputs (e.g., originZIP, destinationZIP, weight) into your API request body.

Step 7: Finalize and Run the Flow

  1. Run the flow to ensure the API pulls, processes, and saves data correctly.
  2. Schedule the flow for automatic runs, if needed, to keep your data up-to-date.