使用 Azure 逻辑应用访问和管理 IBM DB2 资源Access and manage IBM DB2 resources by using Azure Logic Apps

使用 Azure 逻辑应用IBM DB2 连接器,可以基于 DB2 数据库中存储的资源创建自动化的任务和工作流。With Azure Logic Apps and the IBM DB2 connector, you can create automated tasks and workflows based on the resources stored in your DB2 database. 工作流可以连接到数据库中的资源、读取和列出数据库表、添加行、更改行、删除行,以及执行其他操作。Your workflows can connect to the resources in your database, read and list your database tables, add rows, change rows, delete rows, and more. 可在逻辑应用中包含操作,用于从数据库获取响应,并使输出可供其他操作使用。You can include actions in your logic apps that get responses from your database and make the output available for other actions.

本文介绍如何创建一个可执行各种数据库操作的逻辑应用。This article shows how you can create a logic app that performs various database operations. 如果你不熟悉逻辑应用,请查看什么是 Azure 逻辑应用?If you're new to logic apps, review What is Azure Logic Apps?

支持的平台和版本Supported platforms and versions

DB2 连接器包含一个可以通过 TCP/IP 网络来与远程 DB2 服务器通信的 Microsoft 客户端。The DB2 connector includes a Microsoft client that communicates with remote DB2 servers across a TCP/IP network. 可以使用此连接器访问云数据库,例如,Azure 虚拟化中运行的 IBM DB2 for Windows。You can use this connector for accessing cloud databases such as IBM DB2 for Windows running in Azure virtualization. 此外,可在安装并设置本地数据网关之后访问本地 DB2 数据库。You can also access on-premises DB2 databases after you install and set up the on-premises data gateway.

IBM DB2 连接器支持以下 IBM DB2 平台和版本,以及支持分布式关系数据库体系结构 (DRDA) SQL 访问管理器 (SQLAM) 版本 10 和 11 的 IBM DB2 兼容产品:The IBM DB2 connector supports these IBM DB2 platforms and versions along with IBM DB2 compatible products that support Distributed Relational Database Architecture (DRDA) SQL Access Manager (SQLAM) versions 10 and 11:

平台Platform 版本Version
IBM DB2 for z/OSIBM DB2 for z/OS 12、11.1、10.112, 11.1, 10.1
IBM DB2 for iIBM DB2 for i 7.3、7.2、7.17.3, 7.2, 7.1
IBM DB2 for LUWIBM DB2 for LUW 11、10.511, 10.5

支持的数据库操作Supported database operations

IBM DB2 连接器支持以下数据库操作,这些操作映射到连接器中的相应操作:The IBM DB2 connector supports these database operations, which map to the corresponding actions in the connector:

数据库操作Database operation 连接器操作Connector action
列出数据库表List database tables 获取表Get tables
使用 SELECT 读取一行Read one row using SELECT 获取行Get row
使用 SELECT 读取全部行Read all rows using SELECT 获取行Get rows
使用 INSERT 添加一行Add one row using INSERT 插入行Insert row
使用 UPDATE 编辑一行Edit one row using UPDATE 更新行Update row
使用 DELETE 删除一行Remove one row using DELETE 删除行Delete row

先决条件Prerequisites

  • Azure 订阅。An Azure subscription. 如果没有 Azure 订阅,请注册试用版 Azure 订阅If you don't have an Azure subscription, sign up for a trial Azure subscription.

  • 基于云或本地的 IBM DB2 数据库An IBM DB2 database, either cloud-based or on-premises

  • 有关如何创建逻辑应用的基本知识Basic knowledge about how to create logic apps

  • 要在其中访问 DB2 数据库的逻辑应用。The logic app where you want to access your DB2 database. 此连接器仅提供操作,因此,若要启动逻辑应用,请选择单独的触发器(例如“重复”触发器)。 This connector provides only actions, so to start your logic app, select a separate trigger, for example, the Recurrence trigger. 本文中的示例使用“重复”触发器。The examples in this article use the Recurrence trigger.

添加 DB2 操作 - 获取表Add DB2 action - Get tables

  1. Azure 门户中,在逻辑应用设计器中打开你的逻辑应用(如果尚未打开)。In the Azure portal, open your logic app in the Logic App Designer, if not already open.

  2. 在触发器下,选择“新建步骤”。 Under the trigger, choose New step.

  3. 在搜索框中,输入“db2”作为筛选器。In the search box, enter "db2" as your filter. 对于本示例,请在操作列表中选择以下操作:“获取表(预览)”For this example, under the actions list, select this action: Get tables (Preview)

    选择操作

    此时,系统会提示你提供 DB2 数据库的连接详细信息。You're now prompted to provide connection details for your DB2 database.

  4. 请遵循为云数据库本地数据库创建连接的步骤。Follow the steps for creating connections for cloud databases or on-premises databases.

连接到云 DB2Connect to cloud DB2

若要设置连接,请按提示提供以下连接详细信息,选择“创建”,然后保存逻辑应用:To set up your connection, provide these connection details when prompted, choose Create, and then save your logic app:

propertiesProperty 必须Required 说明Description
通过本地网关连接Connect via on-premises gateway No 仅适用于本地连接。Applies only for on-premises connections.
连接名称Connection Name Yes 连接的名称,例如“MyLogicApp-DB2-connection”The name for your connection, for example, "MyLogicApp-DB2-connection"
服务器Server Yes DB2 服务器的地址或冒号分隔的别名端口号,例如“myDB2server.chinacloudapp.cn:50000”The address or alias colon port number for your DB2 server, for example, "myDB2server.chinacloudapp.cn:50000"

注意:此值是表示 TCP/IP 地址或别名的字符串,采用 IPv4 或 IPv6 格式,后接冒号和 TCP/IP 端口号。Note: This value is a string that represents a TCP/IP address or alias, either in IPv4 or IPv6 format, followed by a colon and a TCP/IP port number.

DatabaseDatabase Yes 数据库的名称The name for your database

注意:此值是表示 DRDA 关系数据库名称 (RDBNAM) 的字符串。Note: This value is a string that represents a DRDA Relational Database Name (RDBNAM):

- DB2 for z/OS 接受 16 字节字符串,其中的数据库称为“IBM DB2 for z/OS”位置。- DB2 for z/OS accepts a 16-byte string where the database is known as an "IBM DB2 for z/OS" location.
- DB2 for i 接受 18 字节字符串,其中的数据库称为“IBM DB2 for i”关系数据库。- DB2 for i accepts an 18-byte string where the database is known as an "IBM DB2 for i" relational database.
- DB2 for LUW 接受 8 字节字符串。- DB2 for LUW accepts an 8-byte string.

用户名Username Yes 数据库的用户名Your user name for the database

注意:此值是一个字符串,其长度基于特定的数据库:Note: This value is a string whose length is based on the specific database:

- DB2 for z/OS 接受 8 字节字符串。- DB2 for z/OS accepts an 8-byte string.
- DB2 for i 接受 10 字节字符串。- DB2 for i accepts a 10-byte string.
- DB2 for Linux/UNIX 接受 8 字节字符串。- DB2 for Linux or UNIX accepts an 8-byte string.
- DB2 for Windows 接受 30 字节字符串。- DB2 for Windows accepts a 30-byte string.

密码Password Yes 数据库的密码Your password for the database

例如:For example:

基于云的数据库的连接详细信息

连接到本地 DB2Connect to on-premises DB2

在创建连接之前,必须已安装本地数据网关。Before creating your connection, you must already have your on-premises data gateway installed. 否则无法完成连接设置。Otherwise, you can't finish setting up your connection. 如果已安装网关,请继续提供这些连接详细信息,然后选择“创建”。If you have your gateway installation, continue with providing these connection details, and then choose Create.

propertiesProperty 必须Required 说明Description
通过本地网关连接Connect via on-premises gateway Yes 适用于创建本地连接,将显示本地连接属性。Applies when you want an on-premises connection and shows the on-premises connection properties.
连接名称Connection Name Yes 连接的名称,例如“MyLogicApp-DB2-connection”The name for your connection, for example, "MyLogicApp-DB2-connection"
服务器Server Yes DB2 服务器的地址或冒号分隔的别名端口号,例如“myDB2server:50000”The address or alias colon port number for your DB2 server, for example, "myDB2server:50000"

注意:此值是表示 TCP/IP 地址或别名的字符串,采用 IPv4 或 IPv6 格式,后接冒号和 TCP/IP 端口号。Note: This value is a string that represents a TCP/IP address or alias, either in IPv4 or IPv6 format, followed by a colon and a TCP/IP port number.

DatabaseDatabase Yes 数据库的名称The name for your database

注意:此值是表示 DRDA 关系数据库名称 (RDBNAM) 的字符串。Note: This value is a string that represents a DRDA Relational Database Name (RDBNAM):

- DB2 for z/OS 接受 16 字节字符串,其中的数据库称为“IBM DB2 for z/OS”位置。- DB2 for z/OS accepts a 16-byte string where the database is known as an "IBM DB2 for z/OS" location.
- DB2 for i 接受 18 字节字符串,其中的数据库称为“IBM DB2 for i”关系数据库。- DB2 for i accepts an 18-byte string where the database is known as an "IBM DB2 for i" relational database.
- DB2 for LUW 接受 8 字节字符串。- DB2 for LUW accepts an 8-byte string.

身份验证Authentication Yes 连接的身份验证类型,例如“Basic”The authentication type for your connection, for example, "Basic"

注意:从列表中选择此值,包括“Basic”或“Windows (Kerberos)”。Note: Select this value from the list, which includes Basic or Windows (Kerberos).

用户名Username Yes 数据库的用户名Your user name for the database

注意:此值是一个字符串,其长度基于特定的数据库:Note: This value is a string whose length is based on the specific database:

- DB2 for z/OS 接受 8 字节字符串。- DB2 for z/OS accepts an 8-byte string.
- DB2 for i 接受 10 字节字符串。- DB2 for i accepts a 10-byte string.
- DB2 for Linux/UNIX 接受 8 字节字符串。- DB2 for Linux or UNIX accepts an 8-byte string.
- DB2 for Windows 接受 30 字节字符串。- DB2 for Windows accepts a 30-byte string.

密码Password Yes 数据库的密码Your password for the database
网关Gateway Yes 安装的本地数据网关的名称The name for your installed on-premises data gateway

注意:从列表中选择此值,包括 Azure 订阅和资源组中所有已安装的数据网关。Note: Select this value from the list, which includes all the installed data gateways within your Azure subscription and resource group.

例如:For example:

本地数据库的连接详细信息

查看输出表View output tables

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

    查看运行历史记录

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“获取表”操作。Expand the Get tables action.

    展开操作

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出包括一个表列表。The outputs include a list of tables.

    查看输出表

获取行Get row

若要提取 DB2 数据库表中的一条记录,请在逻辑应用中使用“获取一行”操作。To fetch one record in a DB2 database table, use the Get row action in your logic app. 此操作运行 DB2 SELECT WHERE 语句,例如 SELECT FROM AREA WHERE AREAID = '99999'This action runs a DB2 SELECT WHERE statement, for example, SELECT FROM AREA WHERE AREAID = '99999'.

  1. 如果以前从未在逻辑应用中用过 DB2 操作,请查看添加 DB2 操作 - 获取表部分中的步骤,但应该添加“获取一行”操作,然后返回此处以继续。If you've never used DB2 actions before in your logic app, review the steps in the Add DB2 action - Get tables section, but add the Get row action instead, and then return here to continue.

    添加“获取一行”操作后,示例逻辑应用如下所示:After you add the Get row action, here is how your example logic app appears:

    “获取一行”操作

  2. 指定所有必需属性 (*) 的值。Specify values for all the required properties (*). 选择一个表后,该操作会显示特定于该表中的记录的相关属性。After you select a table, the action shows the relevant properties that are specific to records in that table.

    propertiesProperty 必须Required 说明Description
    表名称Table name Yes 包含所需记录的表,在本示例中为“AREA”The table that has the record you want, such as "AREA" in this example
    地区 IDArea ID Yes 所需记录的 ID,在本示例中为“99999”The ID for the record you want, such as "99999" in this example

    显示“获取行(预览)”操作的屏幕截图,其中包含打开的“表名”列表和选定的“AREA”值。

  3. 完成后,请在设计器工具栏上选择“保存” 。When you're done, on the designer toolbar, choose Save.

查看输出行View output row

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“获取一行”操作。Expand the Get row action.

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出包括指定的行。The outputs include your specified row.

    查看输出行

获取行Get rows

若要提取 DB2 数据库表中的所有记录,请在逻辑应用中使用“获取多行”操作。To fetch all records in a DB2 database table, use the Get rows action in your logic app. 此操作运行 DB2 SELECT 语句,例如 SELECT * FROM AREAThis action runs a DB2 SELECT statement, for example, SELECT * FROM AREA.

  1. 如果以前从未在逻辑应用中用过 DB2 操作,请查看添加 DB2 操作 - 获取表部分中的步骤,但应该添加“获取多行”操作,然后返回此处以继续。If you've never used DB2 actions before in your logic app, review the steps in the Add DB2 action - Get tables section, but add the Get rows action instead, and then return here to continue.

    添加“获取多行”操作后,示例逻辑应用如下所示:After you add the Get rows action, here is how your example logic app appears:

    “获取多行”操作

  2. 打开“表名称”列表,然后选择所需的表,在本示例中为“AREA”:Open the Table name list, and then select the table you want, which is "AREA" in this example:

    显示“获取行(预览)”操作的屏幕截图,其中已在“表名”列表中选择了“AREA”值。

  3. 若要指定筛选器或查询结果,请选择“显示高级选项”。To specify a filter or query for results, choose Show advanced options.

  4. 完成后,请在设计器工具栏上选择“保存” 。When you're done, on the designer toolbar, choose Save.

查看输出行View output rows

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“获取多行”操作。Expand the Get rows action.

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出包括指定表中的所有记录。The outputs include all the records in your specified table.

    查看输出行

插入行Insert row

若要将一条记录添加到 DB2 数据库表,请在逻辑应用中使用“插入行”操作。To add a single record to a DB2 database table, use the Insert row action in your logic app. 此操作运行 DB2 INSERT 语句,例如 INSERT INTO AREA (AREAID, AREADESC, REGIONID) VALUES ('99999', 'Area 99999', 102)This action runs a DB2 INSERT statement, for example, INSERT INTO AREA (AREAID, AREADESC, REGIONID) VALUES ('99999', 'Area 99999', 102).

  1. 如果以前从未在逻辑应用中用过 DB2 操作,请查看添加 DB2 操作 - 获取表部分中的步骤,但应该添加“插入行”操作,然后返回此处以继续。If you've never used DB2 actions before in your logic app, review the steps in the Add DB2 action - Get tables section, but add the Insert row action instead, and then return here to continue.

    添加“插入行”操作后,示例逻辑应用如下所示:After you add the Insert row action, here is how your example logic app appears:

    “插入行”操作

  2. 指定所有必需属性 (*) 的值。Specify values for all the required properties (*). 选择一个表后,该操作会显示特定于该表中的记录的相关属性。After you select a table, the action shows the relevant properties that are specific to records in that table.

    本示例的属性如下:For this example, here are the properties:

    propertiesProperty 必须Required 说明Description
    表名称Table name Yes 要将记录添加到的表,例如“AREA”The table where to add the record, such as "AREA"
    地区 IDArea ID Yes 要添加的地区的 ID,例如“99999”The ID for the area to add, such as "99999"
    地区说明Area description Yes 要添加的地区的说明,例如“地区 99999”The description for the area to add, such as "Area 99999"
    区域 IDRegion ID Yes 要添加的区域的 ID,例如“102”The ID for the region to add, such as "102"

    例如:For example:

    显示逻辑应用设计器的屏幕截图,其中包含“插入行(预览)”操作和示例属性值。

  3. 完成后,请在设计器工具栏上选择“保存” 。When you're done, on the designer toolbar, choose Save.

查看“插入行”的输出View insert row outputs

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“插入行”操作。Expand the Insert row action.

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出包括已添加到指定表中的记录。The outputs include the record you added to your specified table.

    查看输出和插入的行

更新行Update row

若要更新 DB2 数据库表中的一条记录,请在逻辑应用中使用“更新行”操作。To update a single record in a DB2 database table, use the Update row action in your logic app. 此操作运行 DB2 UPDATE 语句,例如 UPDATE AREA SET AREAID = '99999', AREADESC = 'Updated 99999', REGIONID = 102)This action runs a DB2 UPDATE statement, for example, UPDATE AREA SET AREAID = '99999', AREADESC = 'Updated 99999', REGIONID = 102).

  1. 如果以前从未在逻辑应用中用过 DB2 操作,请查看添加 DB2 操作 - 获取表部分中的步骤,但应该添加“更新行”操作,然后返回此处以继续。If you've never used DB2 actions before in your logic app, review the steps in the Add DB2 action - Get tables section, but add the Update row action instead, and then return here to continue.

    添加“更新行”操作后,示例逻辑应用如下所示:After you add the Update row action, here is how your example logic app appears:

    “更新行”操作

  2. 指定所有必需属性 (*) 的值。Specify values for all the required properties (*). 选择一个表后,该操作会显示特定于该表中的记录的相关属性。After you select a table, the action shows the relevant properties that are specific to records in that table.

    本示例的属性如下:For this example, here are the properties:

    propertiesProperty 必须Required 说明Description
    表名称Table name Yes 要在其中更新记录的表,例如“AREA”The table where to update the record, such as "AREA"
    行 IDRow ID Yes 要更新的记录的 ID,例如“99999”The ID for the record to update, such as "99999"
    地区 IDArea ID Yes 新地区 ID,例如“99999”The new area ID, such as "99999"
    地区说明Area description Yes 新地区说明,例如“已更新 99999”The new area description, such as "Updated 99999"
    区域 IDRegion ID Yes 新区域 ID,例如“102”The new region ID, such as "102"

    例如:For example:

    显示逻辑应用设计器的屏幕截图,其中已在“更新行(预览)”操作中选择了一个表。

  3. 完成后,请在设计器工具栏上选择“保存” 。When you're done, on the designer toolbar, choose Save.

查看“更新行”的输出View update row outputs

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“更新行”操作。Expand the Update row action.

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出包括已在指定表中更新的记录。The outputs include the record you updated in your specified table.

    查看输出和更新的行

删除行Delete row

若要删除 DB2 数据库表中的一条记录,请在逻辑应用中使用“删除行”操作。To delete a single record from a DB2 database table, use the Delete row action in your logic app. 此操作运行 DB2 DELETE 语句,例如 DELETE FROM AREA WHERE AREAID = '99999'This action runs a DB2 DELETE statement, for example, DELETE FROM AREA WHERE AREAID = '99999'.

  1. 如果以前从未在逻辑应用中用过 DB2 操作,请查看添加 DB2 操作 - 获取表部分中的步骤,但应该添加“删除行”操作,然后返回此处以继续。If you've never used DB2 actions before in your logic app, review the steps in the Add DB2 action - Get tables section, but add the Delete row action instead, and then return here to continue.

    添加“删除行”操作后,示例逻辑应用如下所示:After you add the Delete row action, here is how your example logic app appears:

    “删除行”操作

  2. 指定所有必需属性 (*) 的值。Specify values for all the required properties (*). 选择一个表后,该操作会显示特定于该表中的记录的相关属性。After you select a table, the action shows the relevant properties that are specific to records in that table.

    本示例的属性如下:For this example, here are the properties:

    propertiesProperty 必须Required 说明Description
    表名称Table name Yes 要在其中删除记录的表,例如“AREA”The table where to delete the record, such as "AREA"
    行 IDRow ID Yes 要删除的记录的 ID,例如“99999”The ID for the record to delete, such as "99999"

    例如:For example:

    显示逻辑应用设计器的屏幕截图,其中包含“删除行(预览)”操作,可在其中选择要删除的表。

  3. 完成后,请在设计器工具栏上选择“保存” 。When you're done, on the designer toolbar, choose Save.

查看“删除行”的输出View delete row outputs

若要手动运行逻辑应用,请在设计器工具栏上选择“运行”。To run your logic app manually, on the designer toolbar, choose Run. 完成运行逻辑应用后,可以查看运行后的输出。After your logic app finishes running, you can view the output from the run.

  1. 在逻辑应用菜单中,选择“概述”。On your logic app menu, select Overview.

  2. 在“运行历史记录”部分中的“摘要”下,选择最近的运行,即列表中的第一项。Under Summary, in the Runs history section, select the most recent run, which is the first item in the list.

  3. 在“逻辑应用运行”下,现在可以查看逻辑应用中每个步骤的状态、输入和输出。Under Logic app run, you can now review the status, inputs, and outputs for each step in your logic app. 展开“删除行”操作。Expand the Delete row action.

  4. 若要查看输入,请选择“显示原始输入”。To view the inputs, choose Show raw inputs.

  5. 若要查看输出,请选择“显示原始输出”。To view the outputs, choose Show raw outputs.

    输出不再包括已从指定表中删除的记录。The outputs no longer include the record you deleted from your specified table.

    查看不包括已删除行的输出

连接器参考Connector reference

有关此连接器的更多技术详细信息,例如触发器、操作和限制(如此连接器的 Swagger 文件所述),请参阅连接器的参考页For more technical details about this connector, such as triggers, actions, and limits as described by the connector's Swagger file, see the connector's reference page.

后续步骤Next steps