Problem with Notion Integration

Hi!
I have some troubles trying to append rows to Notion Database.

  1. In my last node I mapped all columns from the previous output (prepareData1) to Notion database.
    This process was too slow, select each column and assign the right field took me around 1 hour. Everytime I selected a field, n8n blocked it and ask to wait. Dissapointed.
  2. After finally mapped all columns, now send me a lot of errors.
    I know Notion is special with datatypes, so I prepared the data according in previous nodes. I don’t want to map again all the fields.

Can you please check and give a proper solution to update Notion.

Thanks

What is the error message (if any)?

ERROR: Bad request - please check your parameters
400 -

Share the output returned by the last node

{“object”:“error”,“status”:400,“code”:“validation_error”,“message”:“body failed validation. Fix one:\nbody.properties.2024-03-10T18:16:24-06:00.title should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.rich_text should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.number should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.url should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.select should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.multi_select should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.people should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.email should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.phone_number should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.date should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.checkbox should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.relation should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.files should be defined, instead was undefined.\nbody.properties.2024-03-10T18:16:24-06:00.status should be defined, instead was undefined.\nbody.properties.Order Number.id should be defined, instead was undefined.\nbody.properties.Order Number.name should be defined, instead was undefined.\nbody.properties.Order Number.start should be defined, instead was undefined.”,“request_id”:“6ce623e2-90fe-4117-b830-7e055e78134c”} - body failed validation. Fix one: body.properties.2024-03-10T18:16:24-06:00.title should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.rich_text should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.number should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.url should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.select should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.multi_select should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.people should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.email should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.phone_number should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.date should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.checkbox should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.relation should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.files should be defined, instead was undefined. body.properties.2024-03-10T18:16:24-06:00.status should be defined, instead was undefined. body.properties.Order Number.id should be defined, instead was undefined. body.properties.Order Number.name should be defined, instead was undefined. body.properties.Order Number.start should be defined, instead was `undefined

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

{
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “eb9b6d195aff9fd09385b0e2fedaf148374defa605095e683c0d196de6158d82”
},
“nodes”: [
{
“parameters”: {},
“id”: “1a7b0fff-d1d0-40f6-be37-4a19e41e0f1a”,
“name”: “When clicking "Test workflow"”,
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
-520,
-620
]
},
{
“parameters”: {
“authentication”: “accessToken”,
“operation”: “get”,
“orderId”: “5645282509020”,
“options”: {}
},
“id”: “902535d9-1366-4054-b6c7-e664bbd75da6”,
“name”: “Shopify”,
“type”: “n8n-nodes-base.shopify”,
“typeVersion”: 1,
“position”: [
-280,
-620
],
“credentials”: {
“shopifyAccessTokenApi”: {
“id”: “ueTyI6iYUlwy1yEp”,
“name”: “Shopify Access Token account”
}
}
},
{
“parameters”: {
“options”: {}
},
“id”: “280d507c-771e-4f44-bc31-614b3cd5ed62”,
“name”: “Loop Over Items”,
“type”: “n8n-nodes-base.splitInBatches”,
“typeVersion”: 3,
“position”: [
-60,
-620
]
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”
},
“conditions”: [
{
“id”: “e4efbe73-eb67-41f5-a7c1-a97dbd2ddfc6”,
“leftValue”: “={{Object.keys($items()[0].json).length === 0}}”,
“rightValue”: “true”,
“operator”: {
“type”: “boolean”,
“operation”: “true”,
“singleValue”: true
}
}
],
“combinator”: “and”
},
“options”: {}
},
“id”: “e8d6685c-263d-45fc-8d61-ccd1d029dd12”,
“name”: “If”,
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2,
“position”: [
1020,
-600
]
},
{
“parameters”: {
“resource”: “databasePage”,
“operation”: “getAll”,
“databaseId”: {
“__rl”: true,
“value”: “1550cc65-dc27-4b74-9757-19f07c08fb74”,
“mode”: “list”,
“cachedResultName”: “Pedidos Shopify 2024”,
“cachedResultUrl”: “https://www.notion.so/1550cc65dc274b74975719f07c08fb74
},
“simple”: false,
“filterType”: “manual”,
“filters”: {
“conditions”: [
{
“key”: “Order Number|title”,
“condition”: “=contains”,
“titleValue”: “5290”
}
]
},
“options”: {}
},
“id”: “1ca70bf0-b650-446d-8327-7faffe3b795c”,
“name”: “ObtenerRecordNotion”,
“type”: “n8n-nodes-base.notion”,
“typeVersion”: 2.1,
“position”: [
820,
-580
],
“alwaysOutputData”: true,
“credentials”: {
“notionApi”: {
“id”: “O0ArsVMsnCVYvSvb”,
“name”: “Notion account”
}
}
},
{
“parameters”: {
“resource”: “databasePage”,
“databaseId”: {
“__rl”: true,
“value”: “1550cc65-dc27-4b74-9757-19f07c08fb74”,
“mode”: “list”,
“cachedResultName”: “Pedidos Shopify 2024”,
“cachedResultUrl”: “https://www.notion.so/1550cc65dc274b74975719f07c08fb74
},
“title”: “Order Number”,
“propertiesUi”: {
“propertyValues”: [
{
“key”: “Order ID|number”,
“numberValue”: “={{ $(‘prepare Data1’).item.json.order_id }}”
},
{
“key”: “Order Number|title”,
“title”: “={{ String($(‘prepare Data1’).item.json.order_number) }}”
},
{
“key”: “Created Date|date”,
“date”: “={{ $(‘prepare Data1’).item.json.created_date }}”,
“timezone”: “”
},
{
“key”: “={{ $(‘prepare Data1’).item.json.update_date }}”
},
{
“key”: “Month|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Month }}”
},
{
“key”: “={{ $(‘prepare Data1’).item.json.Items_qty }}”
},
{
“key”: “Financial Status|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.financial_status }}”
},
{
“key”: “={{ Number($(‘prepare Data1’).item.json.Total) }}”
},
{
“key”: “Sub Total|number”,
“numberValue”: “={{ Number($(‘prepare Data1’).item.json.sub_total) }}”
},
{
“key”: “Shipping|number”,
“numberValue”: “={{ Number($(‘prepare Data1’).item.json.Shpping) }}”
},
{
“key”: “Tax|number”,
“numberValue”: “={{ Number($(‘prepare Data1’).item.json.Tax) }}”
},
{
“key”: “={{ Number($(‘prepare Data1’).item.json.Returns) }}”
},
{
“key”: “Disccounts|number”,
“numberValue”: “={{ Number($(‘prepare Data1’).item.json.Disccounts) }}”
},
{
“key”: “Discount Code|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Discount_Code }}”
},
{
“key”: “={{ $(‘prepare Data1’).item.json.Comissions }}”
},
{
“key”: “Payment Method|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Payment_Method }}”
},
{
“key”: “={{ $(‘prepare Data1’).item.json.Customer_ID }}”
},
{
“key”: “Customer Last Name|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Customer_LastName }}”
},
{
“key”: “Customer First Name|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Customer_FirstName }}”
},
{
“key”: “Customer Full Name|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Customer_FullName }}”
},
{
“key”: “Customer Email|email”,
“emailValue”: “={{ $(‘prepare Data1’).item.json.Customer_Email }}”
},
{
“key”: “Customer Phone Number|phone_number”,
“phoneValue”: “={{ $(‘prepare Data1’).item.json.Custome_PhoneNumber }}”
},
{
“key”: “Marketing Email|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Marketing_Email }}”
},
{
“key”: “Marketing SMS|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Marketing_SMS }}”
},
{
“key”: “Costumer Ammount of Orders|number”,
“numberValue”: “={{ $(‘prepare Data1’).item.json.Costumer_Ammount_Orders }}”
},
{
“key”: “Costumer TAGS|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Costumer_TAGS }}”
},
{
“key”: “Order URL|url”,
“urlValue”: “={{ $(‘prepare Data1’).item.json.Order_URL }}”
},
{
“key”: “Source Name|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Source_Name }}”
},
{
“key”: “UTM Tracking|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.UTM_Tracking }}”
},
{
“key”: “UTM |rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.UTM }}”
},
{
“key”: “Shipping Method|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipping_Method }}”
},
{
“key”: “Shipping Company|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipping_Company }}”
},
{
“key”: “Shipping Tracking Number|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Shipping_Tracking_Number }}”
},
{
“key”: “Shipping URL Tracking|url”,
“urlValue”: “={{ $(‘prepare Data1’).item.json.Shipping_URL_Tracking }}”
},
{
“key”: “Shipping Status|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipment_status }}”
},
{
“key”: “Order TAGS|multi_select”,
“multiSelectValue”: "={{ $(‘prepare Data1’).item.json.Order_TAGS }} "
},
{
“key”: “Shipping Address Name|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Shipping_AddressName }}”
},
{
“key”: “Shipping Phone|phone_number”,
“phoneValue”: “={{ $(‘prepare Data1’).item.json.Shipping_Phone }}”
},
{
“key”: “Shipping Address 1|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json[‘Shipping_Address 1’] }}”
},
{
“key”: “Shipping Address 2|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json[‘Shipping_Address 2’] }}”
},
{
“key”: “Shipping Reference|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Shipping_Reference }}”
},
{
“key”: “Shipping City|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipping_City }}”
},
{
“key”: “Shipping State|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipping_State }}”
},
{
“key”: “Shipping Neighbor|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Shipping_Neighbor }}”
},
{
“key”: “Shipping Zip Code|number”,
“numberValue”: “={{ $(‘prepare Data1’).item.json.Shipping_ZipCode }}”
},
{
“key”: “Shipping Country|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Shipping_Country }}”
},
{
“key”: “Billing Name|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Billing_Name }}”
},
{
“key”: “Billing Phone|phone_number”,
“phoneValue”: “={{ $(‘prepare Data1’).item.json.Billing_Phone }}”
},
{
“key”: “Billing Address 1|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json[‘Billing_Address 1’] }}”
},
{
“key”: “Billing Address 2|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json[‘Billing_Address 2’] }}”
},
{
“key”: “Billing City|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Billing_City }}”
},
{
“key”: “Billing State|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Billing_State }}”
},
{
“key”: “Billing Neighbor|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.Billing_Neighbor }}”
},
{
“key”: “Billing Zip Code|number”,
“numberValue”: “={{ $(‘prepare Data1’).item.json.Billing_ZipCode }}”
},
{
“key”: “Billing Zip Code|number”,
“numberValue”: “={{ $(‘prepare Data1’).item.json.Billing_ZipCode }}”
},
{
“key”: “Billing Country|select”,
“selectValue”: “={{ $(‘prepare Data1’).item.json.Billing_Country }}”
},
{
“key”: “SKU|rich_text”,
“textContent”: “={{ $(‘prepare Data1’).item.json.sku_list }}”
}
]
},
“options”: {}
},
“id”: “494688d1-9bab-4be7-870e-4974a296c9e4”,
“name”: “InsertRecordNotion”,
“type”: “n8n-nodes-base.notion”,
“typeVersion”: 2.1,
“position”: [
1220,
-340
],
“credentials”: {
“notionApi”: {
“id”: “O0ArsVMsnCVYvSvb”,
“name”: “Notion account”
}
}
},
{
“parameters”: {
“workflowId”: “Ej3zDdSapZ2bBjt7”,
“mode”: “each”,
“options”: {}
},
“id”: “c1d31b44-cd5d-43ea-83ed-86a07dd26b4d”,
“name”: “Execute Workflow”,
“type”: “n8n-nodes-base.executeWorkflow”,
“typeVersion”: 1,
“position”: [
620,
-540
]
},
{
“parameters”: {
“mode”: “runOnceForEachItem”,
“jsCode”: “let inputData = $input.item.json\n\nfunction getShippingMethodByTags(tags) {\n if (String(tags).includes("ALMACÉN")){\n return "Almacen Babylon"\n }\n else return ""\n}\n\nfunction getShippingMethodBySource(pvalue) {\n if (pvalue==="pos"){\n return "Popup Store"\n }\n else return ""\n}\n\nfunction capitalize(str){\n if (str){\n return str.split(" ").map(strPart => ${strPart[0].toUpperCase()}${strPart.slice(1)}).join(" ")\n } else return ""\n}\n\nfunction sum(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => x[key]).reduce((ps, a) => ps + a, 0)\n } else return 0 \n}\n\nfunction count(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => x[key]).reduce((ps, a) => ps + 1, 0)\n } else return 0 \n}\n\nfunction phoneNormalizer(phone){\n let strPhone = String(phone)\n if (strPhone.startsWith(‘+52’)){\n return strPhone\n } else {\n return +52${phone}\n }\n}\n\nlet sheetData2 = {\n\n "Transactions": inputData.refund_list.length === 0 ? :inputData.refund_list[0].transactions,\n}\n\nreturn sheetData2”
},
“id”: “7a3ce22b-d739-4d34-b18e-0865371759bb”,
“name”: “getTransactions”,
“type”: “n8n-nodes-base.code”,
“typeVersion”: 2,
“position”: [
280,
-540
]
},
{
“parameters”: {
“mode”: “runOnceForEachItem”,
“jsCode”: “let inputData = $input.item.json\n\nfunction sum(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => Number(x[key])).reduce((ps, a) => ps + a, 0)\n } else return 0 \n}\n\nfunction count(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => x[key]).reduce((ps, a) => ps + 1, 0)\n } else return 0 \n}\n\nlet sheetData3 = {\n total_refunds_qty: inputData.Transactions.length === 0 ? 0: sum(inputData.Transactions, "amount"),\n total_refunds_count: inputData.Transactions.length === 0? 0: count(inputData.Transactions, "amount"),\n}\n\nreturn sheetData3”
},
“id”: “e102d7f1-5fe2-4d70-9bee-0d3dc5c6a052”,
“name”: “getReturns”,
“type”: “n8n-nodes-base.code”,
“typeVersion”: 2,
“position”: [
440,
-540
]
},
{
“parameters”: {
“mode”: “runOnceForEachItem”,
“jsCode”: “let inputData = $input.item.json\n\nfunction getSKU(arr,key) {\n if (arr && arr.length > 0){\n return arr.map(x => x[key]).reduce((ps, a) => ps + a + ‘,’, ‘’)\n } else return ‘’ \n}\n\nfunction getShippingMethodByTags(tags) {\n if (String(tags).includes("ALMACÉN")){\n return "Almacen Babylon"\n }\n else return ""\n}\n\nfunction getShippingMethodBySource(pvalue) {\n if (pvalue==="pos"){\n return "Popup Store"\n }\n else return ""\n}\n\nfunction capitalize(str){\n if (str){\n return str.split(" ").map(strPart => ${strPart[0].toUpperCase()}${strPart.slice(1)}).join(" ")\n } else return ""\n}\n\nfunction sum(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => Number(x[key])).reduce((ps, a) => ps + a, 0)\n } else return 0 \n}\n\nfunction count(arr, key){\n if (arr && arr.length > 0){\n return arr.map(x => x[key]).reduce((ps, a) => ps + 1, 0)\n } else return 0 \n}\n\nfunction phoneNormalizer(phone){\n let strPhone = String(phone)\n if (strPhone.startsWith(‘+52’)){\n return strPhone\n } else {\n return +52${phone}\n }\n}\n\nfunction setShipmentMethod(p1,p2,p3) {\n if (p2.length===0){\n if (p3.length===0){\n return p1\n }\n else{\n return p3\n }\n }\n else{\n return p2\n } \n}\n\nlet sheetData = {\n order_id: inputData.id,\n order_number: inputData.order_number,\n created_date: inputData.created_at,\n update_date: inputData.updated_at,\n Month: capitalize(DateTime.fromISO(inputData.created_at).setLocale(‘es’).toFormat(‘MMMM yyyy’)),\n Items_qty: sum(inputData.line_items, "quantity"), \n financial_status: inputData.financial_status,\n Total: inputData.current_total_price,\n sub_total: inputData.current_subtotal_price,\n Shpping: inputData.total_shipping_price_set=== null? 0 : inputData.total_shipping_price_set.shop_money.amount,\n \n Tax: inputData.current_total_tax_set.shop_money.amount,\n Returns: inputData.refunds.transactions?.length || 0,\n Disccounts: inputData.current_total_discounts,\n Comissions: inputData.sourceName==="pos" ? inputData.current_total_price * (.05) : 0,\n Discount_Code: inputData.discount_codes.length === 0 ? ‘’ : inputData.discount_codes[0].code,\n Payment_Method: inputData.payment_gateway_names === null ? ‘’ : inputData.payment_gateway_names[0],\n\n Customer_ID: inputData.customer.id,\n Customer_FirstName: capitalize(inputData.customer?.first_name),\n Customer_LastName: capitalize(inputData.customer?.last_name),\n Customer_FullName: capitalize(${inputData.customer?.first_name} ${inputData.customer?.last_name}),\n\n Customer_Email: inputData.customer.email,\n Custome_PhoneNumber: phoneNormalizer(inputData.customer.phone),\n Marketing_Email: inputData.customer.email_marketing_consent === null ? ‘NA’:inputData.customer.email_marketing_consent.state,\n Marketing_SMS: inputData.customer.sms_marketing_consent=== null ?‘NA’ :inputData.customer.sms_marketing_consent.state,\n \n Costumer_Ammount_Orders: 0,\n Costumer_TAGS: inputData.customer.tags,\n Order_URL: inputData.order_status_url,\n Source_Name: inputData.source_name,\n Source_URL: inputData.source_url,\n UTM_Tracking: inputData.landing_site,\n UTM: inputData.landing_site_ref,\n\n \n Shipping_Company: inputData.fulfillments[0].tracking_company,\n Shipping_Tracking_Number: inputData.fulfillments[0].tracking_number,\n Shipping_URL_Tracking: inputData.fulfillments[0].tracking_url,\n Shipment_status: inputData.fulfillments[0].shipment_status,\n \n Order_TAGS: inputData.tags,\n Shipping_AddressName: inputData.shipping_address === null? ‘NA’: capitalize(inputData.shipping_address.first_name).concat(" ",capitalize(inputData.shipping_address.last_name)),\n \n Shipping_Phone: inputData.shipping_address=== null? ‘’: phoneNormalizer(inputData.shipping_address.phone),\n \n "Shipping_Address 1": capitalize(inputData.shipping_address?.address1),\n "Shipping_Address 2": capitalize(inputData.shipping_address?.address2),\n Shipping_Reference: inputData.shipping_address=== null? ‘’: inputData.shipping_address.company, \n Shipping_City: inputData.shipping_address=== null? ‘’: inputData.shipping_address.city,\n Shipping_State: inputData.shipping_address=== null? ‘’: inputData.shipping_address.province,\n Shipping_Neighbor: inputData.shipping_address=== null? ‘’: capitalize(inputData.shipping_address.address2),\n Shipping_ZipCode: inputData.shipping_address=== null? ‘’: inputData.shipping_address.zip,\n Shipping_Country: inputData.shipping_address=== null? ‘’: inputData.shipping_address.country,\n \n Billing_Name: inputData.billing_address=== null? ‘’: capitalize(inputData.billing_address.first_name).concat(" ",capitalize(inputData.billing_address.last_name)),\n Billing_Phone: inputData.billing_address=== null? ‘’: phoneNormalizer(inputData.billing_address.phone),\n "Billing_Address 1": inputData.billing_address=== null? ‘’: capitalize(inputData.billing_address?.address1),\n "Billing_Address 2": inputData.billing_address=== null? ‘’: capitalize(inputData.billing_address?.address2),\n Billing_City: inputData.billing_address=== null? ‘’: inputData.billing_address.city,\n Billing_State: inputData.billing_address=== null? ‘’: inputData.billing_address.province,\n Billing_Neighbor: inputData.billing_address=== null? ‘’: inputData.billing_address.company,\n Billing_ZipCode: inputData.billing_address=== null? ‘’: inputData.billing_address.zip,\n Billing_Country: inputData.billing_address=== null? ‘’: inputData.billing_address.country,\n \n shipping_method_tags: getShippingMethodByTags(inputData.tags === null ? " ": inputData.tags),\n shipping_method_source: getShippingMethodBySource(inputData.source_name === null ? " ": inputData.source_name),\n refund_list: inputData.refunds,\n Shipping_Method: setShipmentMethod(inputData.shipping_lines.length===0? ‘’: inputData.shipping_lines[0].code,getShippingMethodByTags(inputData.tags === null ? " ": inputData.tags),getShippingMethodBySource(inputData.source_name === null ? " ": inputData.source_name)),\n sku_list: getSKU(inputData.line_items,"sku"), \n}\n\nreturn sheetData”
},

Information on your n8n setup

  • **n8n version: default version cloud
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud
  • **Operating system: Windows 11

Hi @ingeniux
could you please share the workflow by wrapping the JSON code in 3 backtick characters?
Something like this:

The JSON you shared is not working by simply copy/pasting it.

hello!
I posted a new topic and share the workflow again.
notion integration problem

1 Like