Newer Version Available

This content describes an older version of this product. View Latest

DRTransformFromStripe

This Omnistudio Data Mapper is used to transform and trim the Stripe response.

Sample Input

1{
2  "api_version": "2020-03-02",
3  "created": 1604488590,
4  "data": {
5    "object": {
6      "amount": 2000,
7      "amount_capturable": 0,
8      "amount_received": 2000,
9      "application": null,
10      "application_fee_amount": null,
11      "canceled_at": null,
12      "cancellation_reason": null,
13      "capture_method": "automatic",
14      "charges": {
15        "data": [
16          {
17            "amount": 2000,
18            "amount_captured": 2000,
19            "amount_refunded": 0,
20            "application": null,
21            "application_fee": null,
22            "application_fee_amount": null,
23            "balance_transaction": "txn_1HjjycKOGFB3U5JQOYg3kJlS",
24            "billing_details": {
25              "address": {
26                "city": null,
27                "country": null,
28                "line1": null,
29                "line2": null,
30                "postal_code": null,
31                "state": null
32              },
33              "email": null,
34              "name": null,
35              "phone": null
36            },
37            "calculated_statement_descriptor": "Stripe",
38            "captured": true,
39            "created": 1604488590,
40            "currency": "inr",
41            "customer": "cus_IIVZ89MepIRw0u",
42            "description": null,
43            "destination": null,
44            "dispute": null,
45            "disputed": false,
46            "failure_code": null,
47            "failure_message": null,
48            "fraud_details": {},
49            "id": "ch_1HjjycKOGFB3U5JQMF9FkOCH",
50            "invoice": null,
51            "livemode": false,
52            "metadata": {
53              "AccountId": "0013t00001hC8s6AAC",
54              "orderId": "52287"
55            },
56            "object": "charge",
57            "on_behalf_of": null,
58            "order": null,
59            "outcome": {
60              "network_status": "approved_by_network",
61              "reason": null,
62              "risk_level": "normal",
63              "risk_score": 4,
64              "seller_message": "Payment complete.",
65              "type": "authorized"
66            },
67            "paid": true,
68            "payment_intent": "pi_1HjjybKOGFB3U5JQK4m3Xw9V",
69            "payment_method": "card_1HifbFKOGFB3U5JQmq1KoLGS",
70            "payment_method_details": {
71              "card": {
72                "brand": "visa",
73                "checks": {
74                  "address_line1_check": null,
75                  "address_postal_code_check": null,
76                  "cvc_check": null
77                },
78                "country": "US",
79                "exp_month": 11,
80                "exp_year": 2022,
81                "fingerprint": "2yNCV5uyUTRDaoJu",
82                "funding": "credit",
83                "installments": null,
84                "last4": "4242",
85                "network": "visa",
86                "three_d_secure": null,
87                "wallet": null
88              },
89              "type": "card"
90            },
91            "receipt_email": null,
92            "receipt_number": null,
93            "receipt_url": "https://pay.stripe.com/receipts/acct_1HCNrvKOGFB3U5JQ/ch_1HjjycKOGFB3U5JQMF9FkOCH/rcpt_IKOm3V6gnJn6ZFOQJ1efZ79fygB4uOJ",
94            "refunded": false,
95            "refunds": {
96              "data": [],
97              "has_more": false,
98              "object": "list",
99              "total_count": 0,
100              "url": "/v1/charges/ch_1HjjycKOGFB3U5JQMF9FkOCH/refunds"
101            },
102            "review": null,
103            "shipping": null,
104            "source": {
105              "address_city": null,
106              "address_country": null,
107              "address_line1": null,
108              "address_line1_check": null,
109              "address_line2": null,
110              "address_state": null,
111              "address_zip": null,
112              "address_zip_check": null,
113              "brand": "Visa",
114              "country": "US",
115              "customer": "cus_IIVZ89MepIRw0u",
116              "cvc_check": null,
117              "dynamic_last4": null,
118              "exp_month": 11,
119              "exp_year": 2022,
120              "fingerprint": "2yNCV5uyUTRDaoJu",
121              "funding": "credit",
122              "id": "card_1HifbFKOGFB3U5JQmq1KoLGS",
123              "last4": "4242",
124              "metadata": {},
125              "name": null,
126              "object": "card",
127              "tokenization_method": null
128            },
129            "source_transfer": null,
130            "statement_descriptor": null,
131            "statement_descriptor_suffix": null,
132            "status": "succeeded",
133            "transfer_data": null,
134            "transfer_group": null
135          }
136        ],
137        "has_more": false,
138        "object": "list",
139        "total_count": 1,
140        "url": "/v1/charges?payment_intent=pi_1HjjybKOGFB3U5JQK4m3Xw9V"
141      },
142      "client_secret": "pi_1HjjybKOGFB3U5JQK4m3Xw9V_secret_Xiw2B8pAhDfQNCX1bjNsuZ7NB",
143      "confirmation_method": "automatic",
144      "created": 1604488589,
145      "currency": "inr",
146      "customer": "cus_IIVZ89MepIRw0u",
147      "description": null,
148      "id": "pi_1HjjybKOGFB3U5JQK4m3Xw9V",
149      "invoice": null,
150      "last_payment_error": null,
151      "livemode": false,
152      "metadata": {
153        "AccountId": "0013t00001hC8s6AAC",
154        "orderId": "52287"
155      },
156      "next_action": null,
157      "object": "payment_intent",
158      "on_behalf_of": null,
159      "payment_method": null,
160      "payment_method_options": {
161        "card": {
162          "installments": null,
163          "network": null,
164          "request_three_d_secure": "automatic"
165        }
166      },
167      "payment_method_types": [
168        "card"
169      ],
170      "receipt_email": null,
171      "review": null,
172      "setup_future_usage": null,
173      "shipping": null,
174      "source": "card_1HifbFKOGFB3U5JQmq1KoLGS",
175      "statement_descriptor": null,
176      "statement_descriptor_suffix": null,
177      "status": "succeeded",
178      "transfer_data": null,
179      "transfer_group": null
180    }
181  },
182  "id": "evt_1HjjycKOGFB3U5JQ2sIYz9nt",
183  "livemode": false,
184  "object": "event",
185  "pending_webhooks": 1,
186  "request": {
187    "id": "req_YY2j54ABsegx7j",
188    "idempotency_key": null
189  },
190  "type": "payment_intent.succeeded"
191}

Parameter

Required/Optional

AccountId

Required

address

Required

address_line1_check

Required

address_postal_code_check

Required

amount

Required

amount_capturable

Required

amount_captured

Required

amount_received

Required

amount_refunded

Required

api_version

Required

application

Required

application_fee

Required

application_fee_amount

Required

balance_transaction

Required

billing_details

Required

brand

Required

calculated_statement_descriptor

Required

canceled_at

Required

cancellation_reason

Required

captured

Required

capture_method

Required

card

Required

charges

Required

checks

Required

city

Required

country

Required

created

Required

currency

Required

customer

Required

cvc_check

Required

data

Required

description

Required

destination

Required

dispute

Required

disputed

Required

email

Required

failure_code

Required

failure_message

Required

fraud_details

Required

id

Required

idempotency_key

Required

invoice

Required

line1

Required

line2

Required

livemode

Required

metadata

Required

name

Required

network_status

Required

object

Required

on_behalf_of

Required

order

Required

orderId

Required

outcome

Required

paid

Required

payment_intent

Required

payment_method

Required

payment_method_details

Required

pending_webhooks

Required

phone

Required

postal_code

Required

reason

Required

request

Required

risk_level

Required

risk_score

Required

seller_message

Required

state

Required

type

Required

Sample Output

1{
2  "Type": "payment_intent.succeeded",
3  "EventId": "evt_1HjjycKOGFB3U5JQ2sIYz9nt",
4  "Status": "succeeded",
5  "PaymentReceived": 2000,
6  "PaymentIntentId": "pi_1HjjybKOGFB3U5JQK4m3Xw9V",
7  "Customer": "cus_IIVZ89MepIRw0u",
8  "OrderId": "52287",
9  "AccountId": "0013t00001hC8s6AAC",
10  "PaymentMethod": "card_1HifbFKOGFB3U5JQmq1KoLGS"
11}

Called By

  • Workflow: Webhook IP, which listens to Stripe