Step 2: Connect Stripe Data Retrieval and Validation

This step filters for paid orders and pulls the line item details from Stripe.

1. In Validate Paid Orders, add two conditions: payment_status equals paid using {{ $json.payment_status }}, and amount_total greater than 0 using {{ $json.amount_total }}.
2. Connect Expand Items List → Validate Paid Orders.
3. Add Retrieve Line Items and set URL to =https://api.stripe.com/v1/payment_intents/{{ $json.payment_intent }}/amount_details_line_items.
4. Credential Required: Connect your stripeApi credentials in Retrieve Line Items.
5. Confirm parallel execution: Validate Paid Orders outputs to both Combine Order Streams and Retrieve Line Items in parallel.

Step 3: Process and Aggregate Line Items

Split out product details, map them into the required fields, and aggregate them into a line_items array.

1. Add Separate Products and set Field To Split Out to data.
2. Configure Map Item Fields with assignments: product_id = {{ $json.product_code }}, product_title = {{ $json.product_name }}, price = {{ $json.unit_cost/100 }}, quantity = {{ $json.quantity }}, variant_id = {{ $json.product_code }}, and sku = {{ $json.product_code }}.
3. Set Aggregate Item Data with Aggregate = aggregateAllItemData and Destination Field Name = line_items.
4. Connect Retrieve Line Items → Separate Products → Map Item Fields → Aggregate Item Data.

Step 4: Merge Order Streams and Build the Event Payload

This step combines the original order data with the aggregated line items and formats the payload for RD Station.

1. Configure Combine Order Streams with Mode = combine and Combine By = combineByPosition.
2. Connect Validate Paid Orders to input 1 and Aggregate Item Data to input 2 of Combine Order Streams.
3. In Compose Event Payload, set fields: currency = {{ $json.currency?.toUpperCase() }}, identifier = {{ $json.payment_intent }}, price = {{ $json.amount_total/100 }}, shipping_price = {{ $json.shipping_cost/100 }}, total_items = {{ $json.line_items.length || 0 }}, line_items = {{ $json.line_items }}, and email = {{ $json.customer_details?.email }}.
4. Connect Combine Order Streams → Compose Event Payload.

Step 5: Configure the RD Station Event Dispatch

Send the assembled order data to RD Station as an ecommerce order paid event.

1. Configure Dispatch RD Event with URL = https://api.rd.services/platform/events and Method = POST.
2. Enable Send Body, Send Query, and Send Headers.
3. Set body parameters: event_type = ECOMMERCE_ORDER_PAID, event_family = CDP, and payload = {{ $json }}.
4. Set query parameters: event_type = ECOMMERCE_ORDER_PAID.
5. Set headers: accept = application/json and content-type = application/json.
6. Credential Required: Connect your rdStationMarketingOAuth2Api credentials in Dispatch RD Event.
7. Connect Compose Event Payload → Dispatch RD Event.

Step 6: Test and Activate Your Workflow

Validate that paid orders create a correctly formatted event payload and that RD Station receives the event.

1. Click Execute Workflow and trigger a test Checkout Session in Stripe.
2. Confirm Validate Paid Orders passes only paid orders with amount_total > 0.
3. Verify Compose Event Payload outputs fields like currency, identifier, and line_items with expected values.
4. Check Dispatch RD Event for a successful HTTP response from RD Station.
5. Toggle the workflow to Active to enable real-time processing.