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}
ParameterRequired/Optional
AccountIdRequired
addressRequired
address_line1_checkRequired
address_postal_code_checkRequired
amountRequired
amount_capturableRequired
amount_capturedRequired
amount_receivedRequired
amount_refundedRequired
api_versionRequired
applicationRequired
application_feeRequired
application_fee_amountRequired
balance_transactionRequired
billing_detailsRequired
brandRequired
calculated_statement_descriptorRequired
canceled_atRequired
cancellation_reasonRequired
capturedRequired
capture_methodRequired
cardRequired
chargesRequired
checksRequired
cityRequired
countryRequired
createdRequired
currencyRequired
customerRequired
cvc_checkRequired
dataRequired
descriptionRequired
destinationRequired
disputeRequired
disputedRequired
emailRequired
failure_codeRequired
failure_messageRequired
fraud_detailsRequired
idRequired
idempotency_keyRequired
invoiceRequired
line1Required
line2Required
livemodeRequired
metadataRequired
nameRequired
network_statusRequired
objectRequired
on_behalf_ofRequired
orderRequired
orderIdRequired
outcomeRequired
paidRequired
payment_intentRequired
payment_methodRequired
payment_method_detailsRequired
pending_webhooksRequired
phoneRequired
postal_codeRequired
reasonRequired
requestRequired
risk_levelRequired
risk_scoreRequired
seller_messageRequired
stateRequired
typeRequired

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