Workato Integration

Step 1: Create a Project in Workato

1. Log in to your Workato account.
2. Navigate to the Projects section from the left-hand panel.
3. Click Create (top-right corner) to create a new project.
4. Provide a descriptive name, e.g., “Excel Calculation Integration”.

Step 2: Create a Recipe

1. Inside the project, click Create → New Recipe.
2. Name the recipe: “SpreadsheetWeb API Integration Recipe”.
3. For the trigger, choose Function Call:
   • Allows dynamic input values for testing and automation.

Step 3: Define Input Schema for Dynamic Data

1. In the recipe builder, select Add Step → Function Call.
2. Create a schema to define input variables:
   Example JSON Schema:

   {
   
     "originZIP": "string",
   
     "destinationZIP": "string",
   
     "weight": "string"
   
   }

    

3. If workspaceIdand applicationId are static, exclude them from the schema. They will be set directly in the API request.

Step 4: Send an HTTP Request to SpreadsheetWeb API

1. Add a step → Select Send Request via HTTP.
2. Configure the HTTP Request:
   • Authentication: Select No Authentication.
   • URL: https://api.spreadsheetweb.com/calculations/calculatesinglesimple
   • Method: POST.
3. Request Body: Enter the JSON structure below and map dynamic variables:

{

  "request": {

    "workspaceId": "your-workspace-id",

    "applicationId": "your-application-id",

    "inputs": {

      "originZIP": "<originZIP>",

      "destinationZIP": "<destinationZIP>",

      "weight": "<weight>"

    }, 
 "outputs": ["cost"]}}

1. Replace your-workspace-id and your-application-id with your SpreadsheetWeb credentials.

Use dynamic input variables (e.g., <originZIP>) to send data from the schema.

2. Add a header:

1. 1. Content-Type: application/json.

Step 5: Handle and Display API Response

1. Add a Log Message to Job Report step to view API results:
   • Message Field: Map the output field containing the cost value from the API response.
     Example:

$response.request.outputs.cost

2. This step logs the API result for debugging and validation.

Step 6: Test the Integration

1. Run the recipe with test inputs:
   • Provide originZIP, destinationZIP, and weight via the Function Call trigger.
2. Verify the steps:
   • Confirm the HTTP request is sent with the correct inputs.
   • Review the Job Report for the API response and ensure the cost value is displayed correctly.