UIPath Integration

Step 1: Set Up UIPath Project

1. Launch UIPath Studio and create a New Project.
2. Choose the Manual Automation template.
3. Name the project and open the workflow editor.

Step 2: Create Input Variables

1. Add three Set Variable activities to define input variables:
   • originZIP (e.g., “10001”)
   • destinationZIP (e.g., “90001”)
   • weight (e.g., “1”)
2. Leave default values blank to allow runtime inputs.

Step 3: Construct the API Request Body

1. Add a Set Value activity to build the JSON request body.

2. Use the following structure:

   { "request": { "workspaceId": "your-workspace-id", "applicationId": "your-application-id", "inputs": { "originZIP": "{{originZIP}}", "destinationZIP": "{{destinationZIP}}", "weight": "{{weight}}" }, "outputs": ["cost"] } }

3. Replace placeholders with dynamic input variables.

Step 4: Configure the HTTP Request

1. Add the HTTP Request activity to the workflow.
2. Set the properties:

   • Method: POST

   • Endpoint:

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

   • Headers:

     • Content-Type: application/json

   • Body: Reference the JSON request variable (requestBody).

3. Ensure SSL Certification is enabled and Accept is set to JSON.

Step 5: Log the API Response

1. Add a Log Message activity after the HTTP request.
2. Log the Response Content from the HTTP Request activity to verify the raw response.

Step 6: Deserialize JSON Response

1. Add a Deserialize JSON activity to convert the API response into a usable format.
2. Map the Response Content to the JSON String field.
3. The result will be a structured object for accessing specific fields.

Step 7: Log the Deserialized Output

1. Add a Log Message activity.

2. Log the specific output (e.g., cost) from the deserialized JSON object:

   deserializedObject("response")("outputs")("cost").ToString

   Step 8: Test the Workflow

3. Run the automation and provide test values for:

   • originZIP
   • destinationZIP
   • weight

4. Check the logs:

   • Ensure the API response contains the expected cost value.
   • Verify the deserialized output is accurate.