Data from Airtable to Stripe to create and send an Invoice. All the data is going through except the price!
All steps above and as you can see the output into stripe is…£0.00!
Help have built and rebuilt and swapped mapping around.
Welcome to the Make community!
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
3 Likes
module 1 output
[
{
"date": "2024-02-19T10:59:35.249Z",
"subject": "reclkwbVJeJ07vM3t",
"text": "2\n",
"html": "<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=us-ascii\">\n</head>\n<body>\n<p style=\"margin-top:0\"><span>2</span></p>\n</body>\n</html>\n",
"from": {
"address": "info@homepetpeople.co.uk",
"name": "Home pet people"
},
"to": [
{
"address": "t3r7iapnf8q41wu9orttswn71q5b8kit@hook.eu2.make.com",
"name": ""
}
],
"cc": [],
"bcc": [],
"attachments": [],
"headers": {
"arc-seal": "i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=HmIJgzn1GwE6Ubz6v/mUhDfBOyeY04awH8N1fpQXugltaB4iK8c7/hnGgPZqn/qwQiiEfmpEdaxwT11JcVaBN/egrD7DIDeLEXq53CdlxGte/xFl6FlqQsUCqqhoDstHaQ7cj9XGi9ZZw/jNh+YO4JLiL6A4wPTk13a4TS8r1YJDzUempI7eNr3kYCUrYipabhKk+IkzK1nvzQC+rIE+NJy6suK9aVXPjv8P3Qxxe+2AlMGam3rvTeDJJAw6UN7zS2sEm0fQnh8RwNpUNvwVkSNMjicZ6fHNvfTnDIOvZj03XSnV1oDhrJ9p5Pdrc3VPVaVa8EKu1BOEFlZEoKdCtw==",
"arc-message-signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=PF5QasvOo4EzvYsoIqFX/oTtv1RH+CSOvFeI1c1tKDs=; b=YzIVnU9+p+oCcxiZhtkarlyADx0lJj7W9X1qu/jItq6d8YuBR5V54E6czIgmuHK93semu346h1ueNPQS9vG2mpCzsEnyOo9vvK8kk/TuAuD9/3dVZrWSq9U428vsg0WDV2LcMA1S16PT5cRblPmhzWgyb8ftNFHphpcM2Rr7GaKrtk0Fa4MAe5FxAfJBSXzRwz+J63itVmztXh+iTsYyyghdeXoZkWzVD7lJTeA6kmjbG3OzgXhKECNcLXgE25BLjhCMoG/7jd4xr3lK3QWjYO1npdQQ8/9ePmhtXpGZpQs7877W7vG+hJRaqbqgF7zQtU0cOAxMkREllpUskoiIag==",
"arc-authentication-results": "i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=homepetpeople.co.uk; dmarc=pass action=none header.from=homepetpeople.co.uk; dkim=pass header.d=homepetpeople.co.uk; arc=none",
"received": [
"from LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:137::6) by CWLP265MB1811.GBRP265.PROD.OUTLOOK.COM (2603:10a6:400:5d::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7292.39; Mon, 19 Feb 2024 10:59:32 +0000",
"from LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM ([fe80::5c07:2a6d:4bce:5b1f]) by LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM ([fe80::5c07:2a6d:4bce:5b1f%6]) with mapi id 15.20.7292.036; Mon, 19 Feb 2024 10:59:32 +0000"
],
"from": "<info@homepetpeople.co.uk>",
"to": "<t3r7iapnf8q41wu9orttswn71q5b8kit@hook.eu2.make.com>",
"subject": "reclkwbVJeJ07vM3t",
"thread-topic": "reclkwbVJeJ07vM3t",
"thread-index": "AQHaYyK3uwqwINl8NU+wPViaQnAPmg==",
"date": "Mon, 19 Feb 2024 10:59:32 GMT",
"message-id": "<LNXP265MB24739C89A808E89B11CDDA778B512@LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM>",
"accept-language": "en-GB, en-US",
"content-language": "en-US",
"authentication-results": "dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=homepetpeople.co.uk;",
"x-ms-publictraffictype": "Email",
"x-ms-traffictypediagnostic": "LNXP265MB2473:EE_|CWLP265MB1811:EE_",
"x-ms-office365-filtering-correlation-id": "bbf2c5b3-4a50-4b4b-0dc8-08dc3139da7c",
"x-ms-exchange-senderadcheck": "1",
"x-ms-exchange-antispam-relay": "0",
"x-microsoft-antispam": "BCL:0;",
"x-microsoft-antispam-message-info": "FIgFPPj+AnuQsmRQIvspAd3C3u6J3Orn3wChBy2DGTQ3vF9Oyeq/S920aWpYeRfHT6xQonY1WyfB+/Td2bhByUdrgpUArmZqhPnzcw1rwctghBGR1bpBEpfpaCpDoCx1h6sXD178TJ/MDoinZ1CUxJZf80dDmkfSFo6aZp6r+HyEKVv5o6OFhHkKaFP7f5WDnTHBuARt1t1trfhJxJOvRAWFabRVntmRZAX+Fofy3E//MklS68PZA6hp4YZTXVbVCSmj8jhhtrtXb2A9zIKwUNjGy+6ryik2GoxfZ9WNCs8DIkw8dZiA2iVj/FyvS1JsZAkauZj+wbsl+Jbv0TIxjEHARQLwHvq3NlUbsf3cGTg=",
"x-forefront-antispam-report": "CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(38070700009);DIR:OUT;SFP:1102;",
"x-ms-exchange-antispam-messagedata-chunkcount": "1",
"x-ms-exchange-antispam-messagedata-0": "=?us-ascii?Q?z7DLLrWeJ2OCbhKcZzMx0hmhsd3nNYVvuHdhjiEql7bKX6hktT45xXWzW8v9?= =?us-ascii?Q?pf7LR+yfqxrH7J03lQ1bziFPKzz17QdbBl4K4sNROWwUMVCD48bouoZMmyTX?= =?us-ascii?Q?zT0CYpOkFqRwJ3ORwsIcB0xCs1wC22hB2VSKR+y6gSBm2dE5+UBvsm4coZiX?= =?us-ascii?Q?vMQ6SV3AB8oHIxzBL/DoyGQSJ0o8xs9mhim2tiTnwLVRcoGT1mzKbq92Plkx?= =?us-ascii?Q?8Xy5XUsIFHM+Y1FSbDc+UAm5Y5rae+4GQtKAEufX3qlo5hnFzTMp9h3kkYIY?= =?us-ascii?Q?uF3fZ/E+tCZPKEYmm4kPe2vZ+c2KFrN0Fj0L+9uJDrKHXiUwwIFr1YcuHNKz?= =?us-ascii?Q?pfDG3Hx3qPsW2VzFwiIq+cR6f3vylMsxQ/9atRzlHSNExIAWxmLs7aVu9K8j?= =?us-ascii?Q?jbiGkKCveaMcRCq243JngEFSFA6fKqn24pf0QR8z1TgGIxkj0bCauGKtqW1D?= =?us-ascii?Q?xnWbZUYtRdzyBobTIIPyiVF/pAVq5HysEb3m1yIeudFvBRNQ2gGJKXBrioZz?= =?us-ascii?Q?ZOzwcRkAOUwcjYgSkoxyC+fnkKO0QNrqE9FKJo9MQFVhohK9z3BTPwkfnRgE?= =?us-ascii?Q?XVm7ws/YPCa9Gj5jbEZkhxy/Kt32CWAIj4B7JG1NHU3TnYdcDGPTZlL8K1Q+?= =?us-ascii?Q?XxJXyAnEenz5Ub5Wl26qXl8kXbijUXcq6UHMAmNrylIEuQMvyu/8EPJ4gm+A?= =?us-ascii?Q?Zkwd90m5rLu9n+HMwXRt3gWisznzfspyLCzqc5qW2Mpa/ogLOLgCRs2v+5gy?= =?us-ascii?Q?cTKaOLYTGbnKraqzcAmF0sJlCnpbyEFwo5R9afuJ8McVuqwNsncUvL/mjnt9?= =?us-ascii?Q?fNXEtbmIdA9Oug81xQfUWSvAc01Rjl+oElGhdpzSfJXwW7A9dpVJKMiofjl1?= =?us-ascii?Q?RQHrLbCOp01ryVPc5Lf3lCUvVm5Ip1TmzNtsZgpV+pcSUoQUjhbVi2MIgVQ6?= =?us-ascii?Q?ppQ+MeSP9ghIPWFIHUSlB4+jMzTH/7PVtTe84DtJMyksrRzSndjEzjG+Grb8?= =?us-ascii?Q?9MzPzkzSMZ1RvBkomG1qb0M3o0Lq1N0KYUugOBmVm+MJTgddcHy71qmwjuvj?= =?us-ascii?Q?BxaIKYJ2m7dNv4IPVDC0Y9SssGTcIF6Gg0xG1nOkTJiJO1MsIIPelyLiVLxc?= =?us-ascii?Q?j6b6kRIu1YplcQGHpXcWuShe6o45EgcxFn0+DfnGtLP+UqrFe6nEkOFXKTHW?= =?us-ascii?Q?4hAhKwqAYyxLMYv3uTZXOsNHj/Vx4j8Qv7s3VD3Zc3BzCowmZtI/M18sTUWV?= =?us-ascii?Q?sPDi6sZvo0BQ9L7/Ck32hp8wXVZ9WSNehayxP/V1MSc7xHAF6vTE7guv+1lg?= =?us-ascii?Q?O/IBISSCss4W2flRC9WiXiI6rHBDHJTs5ruSci4pwo+KDtwp4T8gAtWQBPQs?= =?us-ascii?Q?qSOXMLZOA+gMCk11uockemerlmxubgHCJ9hQ4GRBI1JFlR1x4HN6v6BQqk8n?= =?us-ascii?Q?HXUb/YIxzpg6nZ0LZBkKp1NgpND68vKar14BUOBW29l2BOCkn8K+4LnM8C09?= =?us-ascii?Q?F0Gg4VTX0b2QBF3OXc5k23T2Gb6oAp5BOa5ut6TQhdccpPlCcfDSVnQeb0ZK?= =?us-ascii?Q?AiEGvi5IaJUJcmQ8iykfcdyg6sqGtl98eOPdkdsw?=",
"content-type": "multipart/alternative; boundary=_000_LNXP265MB24739C89A808E89B11CDDA778B512LNXP265MB2473GBRP_",
"mime-version": "1.0",
"x-originatororg": "homepetpeople.co.uk",
"x-ms-exchange-crosstenant-authas": "Internal",
"x-ms-exchange-crosstenant-authsource": "LNXP265MB2473.GBRP265.PROD.OUTLOOK.COM",
"x-ms-exchange-crosstenant-network-message-id": "bbf2c5b3-4a50-4b4b-0dc8-08dc3139da7c",
"x-ms-exchange-crosstenant-originalarrivaltime": "19 Feb 2024 10:59:32.7692 (UTC)",
"x-ms-exchange-crosstenant-fromentityheader": "Hosted",
"x-ms-exchange-crosstenant-id": "c5a60c2b-f6e8-4fb6-a8b7-61008782c726",
"x-ms-exchange-crosstenant-mailboxtype": "HOSTED",
"x-ms-exchange-crosstenant-userprincipalname": "9rJoUN33HJjvnwn4neAzYKbRUlVWWPf02cjN+DYVE4zkjIcJP+0mWgBXqYaNL7lrJRY41rBP3KkKW/siy/QzkxaqGFGpEMx2o7nfJx8nbUU=",
"x-ms-exchange-transport-crosstenantheadersstamped": "CWLP265MB1811"
}
}
]
Module 2 Input
[
{
"id": "reclkwbVJeJ07vM3t",
"base": "appIKi0PuD6CptgZH",
"table": "tblLEdmFTtqHka3Xi",
"useColumnId": false
}
]
Module 2 output
[
{
“Invoice Tracker”: 2,
“Client”: [
“recYVk1ljWmPlBkwZ”
],
“Service”: “new”,
“Price”: 1500,
“Client Stripe ID”: [
“cus_PaeTHXP93c5jB1”
],
“Invoice Record ID”: “reclkwbVJeJ07vM3t”,
“Due Date”: “2024-02-12”,
“id”: “reclkwbVJeJ07vM3t”,
“createdTime”: “2024-02-09T15:37:11.000Z”
}
]
Module 3 Input
[
{
"amount": 150000,
"period": {
"end": null,
"start": null
},
"invoice": null,
"currency": "gbp",
"customer": "cus_PaeTHXP93c5jB1",
"metadata": [],
"tax_rates": [],
"description": "new",
"input_amount": "total",
"subscription": null
}
]
Module 3 Output
[
{
“id”: “ii_1OlUZPRrFcw9RYiqxc6W4rXt”,
“amount”: 150000,
“currency”: “gbp”,
“customer”: “cus_PaeTHXP93c5jB1”,
“date”: “2024-02-19T10:59:35.000Z”,
“description”: “new”,
“discountable”: true,
“discounts”: ,
“invoice”: null,
“livemode”: true,
“metadata”: {},
“period”: {
“end”: “2024-02-19T10:59:35.000Z”,
“start”: “2024-02-19T10:59:35.000Z”
},
“plan”: null,
“price”: {
“id”: “price_1OhyVqRrFcw9RYiqyup4xLQP”,
“object”: “price”,
“active”: false,
“billing_scheme”: “per_unit”,
“created”: “2024-02-09T18:09:22.000Z”,
“currency”: “gbp”,
“custom_unit_amount”: null,
“livemode”: true,
“lookup_key”: null,
“metadata”: {},
“nickname”: null,
“product”: “prod_PX2bi7H7I0AtUq”,
“recurring”: null,
“tax_behavior”: “unspecified”,
“tiers_mode”: null,
“transform_quantity”: null,
“type”: “one_time”,
“unit_amount”: 150000,
“unit_amount_decimal”: “150000”
},
“proration”: false,
“quantity”: 1,
“subscription”: null,
“tax_rates”: ,
“test_clock”: null,
“unit_amount”: 150000,
“unit_amount_decimal”: “150000”
}
]
’ ‘’
MODUL4 input
[
{
"footer": null,
"customer": "cus_PaeTHXP93c5jB1",
"due_date": null,
"metadata": [],
"discounts": [],
"description": null,
"auto_advance": false,
"subscription": null,
"custom_fields": [],
"transfer_data": {
"amount": null
},
"days_until_due": 7,
"default_source": null,
"collection_method": "send_invoice",
"default_tax_rates": null,
"statement_descriptor": null,
"application_fee_amount": null,
"default_payment_method": null,
"pending_invoice_items_behavior": "exclude"
}
]
Module 4 output
[
{
"id": "in_1OlUZQRrFcw9RYiqcbZ6O8tH",
"account_country": "GB",
"account_name": "Home Pet People",
"account_tax_ids": null,
"amount_due": 0,
"amount_paid": 0,
"amount_remaining": 0,
"amount_shipping": 0,
"application": null,
"application_fee_amount": null,
"attempt_count": 0,
"attempted": false,
"auto_advance": false,
"automatic_tax": {
"enabled": false,
"liability": null,
"status": null
},
"billing_reason": "manual",
"charge": null,
"collection_method": "send_invoice",
"created": "2024-02-19T10:59:36.000Z",
"currency": "gbp",
"custom_fields": null,
"customer": "cus_PaeTHXP93c5jB1",
"customer_address": null,
"customer_email": "treena@homepetpeople.co.uk",
"customer_name": "treena cooper",
"customer_phone": null,
"customer_shipping": null,
"customer_tax_exempt": "none",
"customer_tax_ids": [],
"default_payment_method": null,
"default_source": null,
"default_tax_rates": [],
"description": null,
"discount": null,
"discounts": [],
"due_date": "2024-02-26T10:59:36.000Z",
"effective_at": null,
"ending_balance": null,
"footer": null,
"from_invoice": null,
"hosted_invoice_url": null,
"invoice_pdf": null,
"issuer": {
"type": "self"
},
"last_finalization_error": null,
"latest_revision": null,
"lines": {
"object": "list",
"data": [],
"has_more": false,
"total_count": 0,
"url": "/v1/invoices/in_1OlUZQRrFcw9RYiqcbZ6O8tH/lines"
},
"livemode": true,
"metadata": {},
"number": null,
"on_behalf_of": null,
"paid": false,
"paid_out_of_band": false,
"payment_intent": null,
"payment_settings": {
"default_mandate": null,
"payment_method_options": null,
"payment_method_types": null
},
"period_end": "2024-02-19T10:59:36.000Z",
"period_start": "2024-02-19T10:59:36.000Z",
"post_payment_credit_notes_amount": 0,
"pre_payment_credit_notes_amount": 0,
"quote": null,
"receipt_number": null,
"rendering": {
"amount_tax_display": null,
"pdf": {
"page_size": "auto"
}
},
"rendering_options": null,
"shipping_cost": null,
"shipping_details": null,
"starting_balance": 0,
"statement_descriptor": null,
"status": "draft",
"status_transitions": {},
"subscription": null,
"subscription_details": {
"metadata": null
},
"subtotal": 0,
"subtotal_excluding_tax": 0,
"tax": null,
"test_clock": null,
"total": 0,
"total_discount_amounts": [],
"total_excluding_tax": 0,
"total_tax_amounts": [],
"transfer_data": null,
"webhooks_delivered_at": "1970-01-01T00:00:00.000Z"
}
]
Module 5 input
[
{
“invoice”: “in_1OlUZQRrFcw9RYiqcbZ6O8tH”
}
]
Module 5 output
[
{
"id": "in_1OlUZQRrFcw9RYiqcbZ6O8tH",
"account_country": "GB",
"account_name": "Home Pet People",
"account_tax_ids": null,
"amount_due": 0,
"amount_paid": 0,
"amount_remaining": 0,
"amount_shipping": 0,
"application": null,
"application_fee_amount": null,
"attempt_count": 0,
"attempted": true,
"auto_advance": false,
"automatic_tax": {
"enabled": false,
"liability": null,
"status": null
},
"billing_reason": "manual",
"charge": null,
"collection_method": "send_invoice",
"created": "2024-02-19T10:59:36.000Z",
"currency": "gbp",
"custom_fields": null,
"customer": "cus_PaeTHXP93c5jB1",
"customer_address": null,
"customer_email": "treena@homepetpeople.co.uk",
"customer_name": "treena cooper",
"customer_phone": null,
"customer_shipping": null,
"customer_tax_exempt": "none",
"customer_tax_ids": [],
"default_payment_method": null,
"default_source": null,
"default_tax_rates": [],
"description": null,
"discount": null,
"discounts": [],
"due_date": "2024-02-26T10:59:36.000Z",
"effective_at": 1708340376,
"ending_balance": 0,
"footer": null,
"from_invoice": null,
"hosted_invoice_url": "https://invoice.stripe.com/i/acct_1NEz3kRrFcw9RYiq/live_YWNjdF8xTkV6M2tSckZjdzlSWWlxLF9QYWZ2b1JVZkJtTmFLT2M1M0kxMklua2pacFE3c09qLDk4ODgxMTc20200eEo57Bwm?s=ap",
"invoice_pdf": "https://pay.stripe.com/invoice/acct_1NEz3kRrFcw9RYiq/live_YWNjdF8xTkV6M2tSckZjdzlSWWlxLF9QYWZ2b1JVZkJtTmFLT2M1M0kxMklua2pacFE3c09qLDk4ODgxMTc20200eEo57Bwm/pdf?s=ap",
"issuer": {
"type": "self"
},
"last_finalization_error": null,
"latest_revision": null,
"lines": {
"object": "list",
"data": [],
"has_more": false,
"total_count": 0,
"url": "/v1/invoices/in_1OlUZQRrFcw9RYiqcbZ6O8tH/lines"
},
"livemode": true,
"metadata": {},
"number": "710282D1-0042",
"on_behalf_of": null,
"paid": true,
"paid_out_of_band": false,
"payment_intent": null,
"payment_settings": {
"default_mandate": null,
"payment_method_options": null,
"payment_method_types": null
},
"period_end": "2024-02-19T10:59:36.000Z",
"period_start": "2024-02-19T10:59:36.000Z",
"post_payment_credit_notes_amount": 0,
"pre_payment_credit_notes_amount": 0,
"quote": null,
"receipt_number": null,
"rendering": {
"amount_tax_display": null,
"pdf": {
"page_size": "letter"
}
},
"rendering_options": null,
"shipping_cost": null,
"shipping_details": null,
"starting_balance": 0,
"statement_descriptor": null,
"status": "paid",
"status_transitions": {
"finalized_at": "2024-02-19T10:59:36.000Z",
"paid_at": "2024-02-19T10:59:36.000Z"
},
"subscription": null,
"subscription_details": {
"metadata": null
},
"subtotal": 0,
"subtotal_excluding_tax": 0,
"tax": null,
"test_clock": null,
"total": 0,
"total_discount_amounts": [],
"total_excluding_tax": 0,
"total_tax_amounts": [],
"transfer_data": null,
"webhooks_delivered_at": "1970-01-01T00:00:00.000Z"
}
]
Module 6 Input
[
{
"id": "reclkwbVJeJ07vM3t",
"base": "appIKi0PuD6CptgZH",
"table": "tblLEdmFTtqHka3Xi",
"record": {
"fld0sdqt3uORCnN8X": "in_1OlUZQRrFcw9RYiqcbZ6O8tH"
},
"typecast": false,
"useColumnId": false
}
]
Module 6 Output
[
{
“Invoice Tracker”: 2,
“Client”: [
“recYVk1ljWmPlBkwZ”
],
“Service”: “new”,
“Price”: 1500,
“Client Stripe ID”: [
“cus_PaeTHXP93c5jB1”
],
“Invoice Record ID”: “reclkwbVJeJ07vM3t”,
“Due Date”: “2024-02-12”,
“Invoice ID”: “in_1OlUZQRrFcw9RYiqcbZ6O8tH”,
“id”: “reclkwbVJeJ07vM3t”,
“createdTime”: “2024-02-09T15:37:11.000Z”
}
]
have added more detail