Forecast to Airtable Log and Slack Alert

arazzo: 1.0.1
info:
  title: Forecast to Airtable Log and Slack Alert
  summary: Fetch a forecast, log it to Airtable, then alert the team in Slack.
  description: >-
    A weather operations workflow that retrieves a forecast for a location from
    WeatherAPI, logs it as a record in an Airtable base, and posts a summary alert to a
    Slack channel. Demonstrates chaining a weather provider, a no-code database
    provider, and a team messaging provider for forecast tracking and alerting.
  version: 1.0.0
sourceDescriptions:
  - name: weatherapiApi
    url: https://raw.githubusercontent.com/api-evangelist/weatherapi/refs/heads/main/openapi/weatherapi-openapi-original.yml
    type: openapi
  - name: airtableApi
    url: https://raw.githubusercontent.com/api-evangelist/airtable/refs/heads/main/openapi/airtable-airtable-api-openapi.yml
    type: openapi
  - name: slackChatApi
    url: https://raw.githubusercontent.com/api-evangelist/slack/refs/heads/main/openapi/slack-chat-openapi.yml
    type: openapi
workflows:
  - workflowId: forecast-log-alert
    summary: Fetch a forecast, log it to Airtable, and alert Slack.
    description: >-
      Retrieves a forecast from WeatherAPI, logs it to an Airtable base, and posts an
      alert to Slack via chat.postMessage.
    inputs:
      type: object
      properties:
        location:
          type: string
        days:
          type: integer
        baseId:
          type: string
        tableIdOrName:
          type: string
        channel:
          type: string
    steps:
      - stepId: get-forecast
        description: Fetch the forecast for the requested location.
        operationId: $sourceDescriptions.weatherapiApi.getForecast
        parameters:
          - name: q
            in: query
            value: $inputs.location
          - name: days
            in: query
            value: $inputs.days
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          locationName: $response.body#/location/name
          forecastText: $response.body#/forecast/forecastday/0/day/condition/text
          maxTemp: $response.body#/forecast/forecastday/0/day/maxtemp_c
      - stepId: log-forecast
        description: Log the forecast as a record in the Airtable base.
        operationId: $sourceDescriptions.airtableApi.createRecords
        parameters:
          - name: baseId
            in: path
            value: $inputs.baseId
          - name: tableIdOrName
            in: path
            value: $inputs.tableIdOrName
        requestBody:
          contentType: application/json
          payload:
            records:
              - fields:
                  Location: $steps.get-forecast.outputs.locationName
                  Condition: $steps.get-forecast.outputs.forecastText
                  MaxTemp: $steps.get-forecast.outputs.maxTemp
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          recordId: $response.body#/records/0/id
      - stepId: alert-slack
        description: Post a forecast alert to the Slack channel.
        operationId: $sourceDescriptions.slackChatApi.postChatPostmessage
        requestBody:
          contentType: application/x-www-form-urlencoded
          payload:
            channel: $inputs.channel
            text: $steps.get-forecast.outputs.forecastText
        successCriteria:
          - condition: $statusCode == 200
          - condition: $response.body#/ok == true
        outputs:
          messageTs: $response.body#/ts
    outputs:
      forecastText: $steps.get-forecast.outputs.forecastText
      recordId: $steps.log-forecast.outputs.recordId
      messageTs: $steps.alert-slack.outputs.messageTs