Lesson 6 of 8
Parabola Integration
Learn how to integrate your Excel SpreadsheetWeb applications with Parabola platform, improve your workflow and boost your business.
2 min readStep 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 Body:
{
"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
- 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.