当前位置: 首页 > news >正文

【n8n教程笔记——工作流Workflow】文本课程(第一阶段)——5.4 计算预订订单数量和总金额 (Calculating booked orders)

https://docs.n8n.io/courses/

文章目录

  • 5. Calculating Booked Orders
    • About the Code node
    • Configure the Code node
    • What's next?

5. Calculating Booked Orders

In this step of the workflow you will learn how n8n structures data and how to add custom JavaScript code to perform calculations using the Code node. After this step, your workflow should look like this:

在这里插入图片描述

The next step in Nathan’s workflow is to calculate two values from the booked orders:

  • The total number of booked orders
  • The total value of all booked orders

To calculate data and add more functionality to your workflows you can use the Code node, which lets you write custom JavaScript code.

About the Code node

Code node modes
The Code node has two operational modes, depending on how you want to process items:

  • Run Once for All Items allows you to write code to process all input items at once, as a group.
  • Run Once for Each Item executes your code once for each input item.

Learn more about how to use the Code node.

In n8n, the data that’s passed between nodes is an array of objects with the following JSON structure:

[{"json": { // (1)!"apple": "beets","carrot": {"dill": 1}},"binary": { // (2)!"apple-picture": { // (3)!"data": "....", // (4)!"mimeType": "image/png", // (5)!"fileExtension": "png", // (6)!"fileName": "example.png", // (7)!}}},...
]
  1. (required) n8n stores the actual data within a nested json key. This property is required, but can be set to anything from an empty object (like {}) to arrays and deeply nested data. The code node automatically wraps the data in a json object and parent array ([]) if it’s missing.
  2. (optional) Binary data of item. Most items in n8n don’t contain binary data.
  3. (required) Arbitrary key name for the binary data.
  4. (required) Base64-encoded binary data.
  5. (optional) Should set if possible.
  6. (optional) Should set if possible.
  7. (optional) Should set if possible.

You can learn more about the expected format on the n8n data structure page.

Configure the Code node

Now let’s see how to accomplish Nathan’s task using the Code node.

In your workflow, add a Code node connected to the false branch of the If node.
在这里插入图片描述
在这里插入图片描述

With the Code node window open, configure these parameters:

  • Mode: Select Run Once for All Items.
    在这里插入图片描述

  • Language: Select JavaScript.
    在这里插入图片描述

Using Python in code nodes
While we use JavaScript below, you can also use Python in the Code node. To learn more, refer to the Code node documentation.

  • Copy the Code below and paste it into the Code box to replace the existing code:

    // Get all input data and store it in a variable called "items"
    // $input.all() is a special function that gets all the data passed to this script
    let items = $input.all();// Count how many items we have by checking the length of the items array
    // Arrays in JavaScript have a .length property that tells you how many elements they contain
    let totalBooked = items.length;// Create a variable to hold the total sum of prices, starting at 0
    // This will be our running total as we add up all the prices
    let bookedSum = 0;// Start a loop to go through each item in our list
    // The loop will run once for each item in the array
    for (let i = 0; i < items.length; i++) {// Inside the loop:// 1. i starts at 0 (first item)// 2. We keep looping while i is less than the number of items// 3. After each loop, i increases by 1 (moves to next item)// Add the current item's price to our running total// items[i] gets the item at position i// .json is an object that contains data about this item// .orderPrice is a specific value inside that object representing the pricebookedSum = bookedSum + items[i].json.orderPrice;
    }// After processing all items, return our results
    // We create an array with one object that contains both totals
    // The object has two properties: totalBooked (count of items) and bookedSum (total price)
    return [{ json: { totalBooked, bookedSum } }];
    

    在这里插入图片描述

Notice the format in which we return the results of the calculation:

return [{ json: {totalBooked, bookedSum} }]

Data structure error
If you don’t use the correct data structure, you will get an error message: Error: Always an Array of items has to be returned!

Now select Execute step and you should see the following results:
在这里插入图片描述

Code node output
Code node output

What’s next?

Nathan 🙋: Wow, the Code node is powerful! This means that if I have some basic JavaScript skills I can power up my workflows.

You 👩‍🔧: Yes! You can progress from no-code to low-code!

Nathan 🙋: Now, how do I send the calculations for the booked orders to my team’s Discord channel?

You 👩‍🔧: There’s an n8n node for that. I’ll set it up in the next step.

http://www.lryc.cn/news/601741.html

相关文章:

  • 使用Python,OpenCV,K-Means聚类查找图像中最主要的颜色
  • Unity Catalog与Apache Iceberg如何重塑Data+AI时代的企业数据架构
  • 【LeetCode 热题 100】35. 搜索插入位置——二分查找(左闭右开)
  • 高格办公空间:以 “空间为基,服务为翼”,重塑办公场景生态
  • 【语义分割】记录2:yolo系列
  • libomxil-bellagio移植到OpenHarmony
  • java小白闯关记第一天(两个数相加)
  • Python-初学openCV——图像预处理(三)
  • XSS利用
  • Web-Machine-N7靶机攻略
  • 文件权限标记机制在知识安全共享中的应用实践
  • JavaEE初阶第十二期:解锁多线程,从 “单车道” 到 “高速公路” 的编程升级(十)
  • C++学习(线程相关)
  • 05 - spring security权限控制
  • Java Ai(day04)
  • [Linux入门] Linux 远程访问及控制全解析:从入门到实战
  • 【工具】python汇总发票(含源码)
  • InfluxDB 与 MQTT 协议集成实践(二)
  • Linux网络-------2.应⽤层⾃定义协议与序列化
  • 基于深度学习的图像分割:使用DeepLabv3实现高效分割
  • 【C语言网络编程】HTTP 客户端请求(基于 Socket 的完整实现)
  • 程序代码篇---python向http界面发送数据
  • 【QT入门到晋级】window opencv安装及引入qtcreator(包含两种qt编译器:MSVC和MinGW)
  • 字节前端面试知识点总结
  • 应对反爬机制的具体方法与策略
  • 《 接口日志与异常处理统一设计:AOP与全局异常捕获》
  • Android 调试桥 (adb) 基础知识点
  • 【C 学习】02-究竟什么是C?
  • 【论文阅读】ON THE ROLE OF ATTENTION HEADS IN LARGE LANGUAGE MODEL SAFETY
  • 一文快速了解Docker和命令详解