Step 1: Create a New Flow in Parabola.io
- Log in to Parabola.io.
- From the Dashboard, click New Flow to open a blank canvas for your workflow.
Step 2: Add the Pull From API Step
- In the left-hand control bar, click Integration.
- Under Triggers/API, select Pull From API.
- Drag the Pull From API step onto the canvas.
Step 3: Configure the API Request
- Select the Pull From API step to open its settings.
- 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"] } }
- Request Body:
-
- Content-Type: application/json
5.1 Add or Rename Columns
- 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
- Select columns you don’t need and remove them to keep the output clean.
Step 6: Save the Data to a Parabola Table
- In the Integration menu, select Send to Parabola Table.
- Drag the step onto the canvas and connect it to your Pull From API step.
- Configure it to save the API response (e.g., the cost field) into a table.
Bonus Tip: Use Dynamic Data Sources
- 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
- Run the flow to ensure the API pulls, processes, and saves data correctly.
- Schedule the flow for automatic runs, if needed, to keep your data up-to-date.