HubSpot Contact to Salesforce Marketing Data Extension

arazzo: 1.0.1
info:
  title: HubSpot Contact to Salesforce Marketing Data Extension
  summary: Create a HubSpot contact, then insert into a Marketing Cloud data extension.
  description: >-
    A cross-provider workflow that creates a contact in HubSpot and writes that
    person's details into a Salesforce Marketing Cloud data extension row for
    use in segmentation and sends. Demonstrates feeding a CRM contact into the
    marketing platform's data layer that powers email campaigns.
  version: 1.0.0
sourceDescriptions:
  - name: hubspotContactsApi
    url: https://raw.githubusercontent.com/api-evangelist/hubspot/refs/heads/main/openapi/hubspot-contacts-api-openapi.yml
    type: openapi
  - name: salesforceMarketingCloudApi
    url: https://raw.githubusercontent.com/api-evangelist/salesforce/refs/heads/main/openapi/salesforce-data-extensions-api-openapi.yml
    type: openapi
workflows:
  - workflowId: hubspot-contact-to-data-extension
    summary: Create a HubSpot contact, then insert a Marketing Cloud DE row.
    description: >-
      Creates a HubSpot contact and inserts a corresponding row into a
      Salesforce Marketing Cloud data extension keyed by the data extension key.
    inputs:
      type: object
      properties:
        email:
          type: string
        firstName:
          type: string
        lastName:
          type: string
        dataExtensionKey:
          type: string
    steps:
      - stepId: create-contact
        description: Create the contact record in HubSpot CRM.
        operationId: $sourceDescriptions.hubspotContactsApi.createContact
        requestBody:
          contentType: application/json
          payload:
            properties:
              email: $inputs.email
              firstname: $inputs.firstName
              lastname: $inputs.lastName
        successCriteria:
          - condition: $statusCode == 201
        outputs:
          contactId: $response.body#/id
      - stepId: insert-de-row
        description: Insert a row into the Marketing Cloud data extension.
        operationId: $sourceDescriptions.salesforceMarketingCloudApi.insertDataExtensionRows
        parameters:
          - name: key
            in: path
            value: $inputs.dataExtensionKey
        requestBody:
          contentType: application/json
          payload:
            items:
              - EmailAddress: $inputs.email
                FirstName: $inputs.firstName
                LastName: $inputs.lastName
                CrmContactId: $steps.create-contact.outputs.contactId
        successCriteria:
          - condition: $statusCode == 200
        outputs:
          insertStatus: $statusCode
    outputs:
      contactId: $steps.create-contact.outputs.contactId
      insertStatus: $steps.insert-de-row.outputs.insertStatus