Airtable Contact to SendGrid Marketing Contact

arazzo: 1.0.1
info:
  title: Airtable Contact to SendGrid Marketing Contact
  summary: Read an Airtable contact, then upsert it into SendGrid Marketing.
  description: >-
    A productivity and internal-ops workflow that reads contact records from an
    Airtable table and upserts them into SendGrid Marketing Campaigns, syncing a
    database of contacts into the email platform. Demonstrates chaining a
    database provider and a communications provider in a single Arazzo workflow.
  version: 1.0.0
sourceDescriptions:
  - name: airtableApi
    url: https://raw.githubusercontent.com/api-evangelist/airtable/refs/heads/main/openapi/airtable-airtable-api-openapi.yml
    type: openapi
  - name: sendgridContactsApi
    url: https://raw.githubusercontent.com/api-evangelist/sendgrid/refs/heads/main/openapi/tsg_mc_contacts_v3.yaml
    type: openapi
workflows:
  - workflowId: contact-to-sendgrid
    summary: List an Airtable contact, then upsert it into SendGrid.
    description: >-
      Lists records from an Airtable contacts table and upserts the first
      contact's email into SendGrid Marketing Campaigns.
    inputs:
      type: object
      properties:
        baseId:
          type: string
        tableIdOrName:
          type: string
        listId:
          type: string
    steps:
      - stepId: list-contacts
        description: List contact records from the Airtable table.
        operationId: $sourceDescriptions.airtableApi.listRecords
        parameters:
          - name: baseId
            in: path
            value: $inputs.baseId
          - name: tableIdOrName
            in: path
            value: $inputs.tableIdOrName
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          contactEmail: $response.body#/records/0/fields/Email
          contactName: $response.body#/records/0/fields/Name
      - stepId: upsert-contact
        description: Upsert the contact into SendGrid Marketing Campaigns.
        operationId: $sourceDescriptions.sendgridContactsApi.UpdateContact
        requestBody:
          contentType: application/json
          payload:
            list_ids:
              - $inputs.listId
            contacts:
              - email: $steps.list-contacts.outputs.contactEmail
                first_name: $steps.list-contacts.outputs.contactName
        successCriteria:
          - condition: $statusCode == 202
        outputs:
          jobId: $response.body#/job_id
    outputs:
      contactEmail: $steps.list-contacts.outputs.contactEmail
      jobId: $steps.upsert-contact.outputs.jobId