Azure 逻辑应用的数据操作代码示例
适用范围:Azure 逻辑应用(消耗型 + 标准型)
下面适用于执行数据操作一文中数据操作定义的代码示例。 若要体验自己的逻辑应用基础工作流定义、Azure 订阅和 API 连接,可以使用这些示例。 只需将这些操作定义复制并粘贴逻辑应用工作流定义的代码视图编辑器,然后修改特定工作流的定义即可。
这些操作定义基于 JavaScript 对象表示法 (JSON) 标准,按字母顺序显示。 但是,在逻辑应用设计器中,每个定义会在工作流中按正确的顺序显示,因为每个操作定义的 runAfter
属性指定了运行顺序。
撰写
若要尝试撰写操作示例,可使用以下操作定义:
"actions": {
"Compose": {
"type": "Compose",
"inputs": {
"age": "@variables('ageVar')",
"fullName": "@{variables('lastNameVar')}, @{variables('firstNameVar')}"
},
"runAfter": {
"Initialize_variable_-_ageVar": [
"Succeeded"
]
}
},
"Initialize_variable_-_ageVar": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "ageVar",
"type": "Integer",
"value": 35
}
]
},
"runAfter": {
"Initialize_variable_-_lastNameVar": [
"Succeeded"
]
}
},
"Initialize_variable_-_firstNameVar": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "firstNameVar",
"type": "String",
"value": "Sophia "
}
]
},
"runAfter": {}
},
"Initialize_variable_-_lastNameVar": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "lastNameVar",
"type": "String",
"value": "Owens"
}
]
},
"runAfter": {
"Initialize_variable_-_firstNameVar": [
"Succeeded"
]
}
}
},
创建 CSV 表
若要尝试创建 CSV 表操作示例,可使用以下操作定义:
"actions": {
"Create_CSV_table": {
"type": "Table",
"inputs": {
"format": "CSV",
"from": "@variables('myJSONArray')"
},
"runAfter": {
"Initialize_variable_-_JSON_array": [
"Succeeded"
]
}
},
"Initialize_variable_-_JSON_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myJSONArray",
"type": "Array",
"value": [
{
"Description": "Apples",
"Product_ID": 1
},
{
"Description": "Oranges",
"Product_ID": 2
}
]
}
]
},
"runAfter": {}
}
},
创建 HTML 表
若要尝试创建 HTML 表操作示例,可使用以下操作定义:
"actions": {
"Create_HTML_table": {
"type": "Table",
"inputs": {
"format": "HTML",
"from": "@variables('myJSONArray')"
},
"runAfter": {
"Initialize_variable_-_JSON_array": [
"Succeeded"
]
}
},
"Initialize_variable_-_JSON_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myJSONArray",
"type": "Array",
"value": [
{
"Description": "Apples",
"Product_ID": 1
},
{
"Description": "Oranges",
"Product_ID": 2
}
]
}
]
},
"runAfter": {}
}
},
筛选数组
若要尝试筛选数组操作示例,可使用以下操作定义:
"actions": {
"Filter_array": {
"type": "Query",
"inputs": {
"from": "@variables('myIntegerArray')",
"where": "@greater(item(), 1)"
},
"runAfter": {
"Initialize_variable_-_integer_array": [
"Succeeded"
]
}
},
"Initialize_variable_-_integer_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myIntegerArray",
"type": "Array",
"value": [
1,
2,
3,
4
]
}
]
},
"runAfter": {}
}
},
联接
若要尝试联接操作示例,可使用以下操作定义:
"actions": {
"Initialize_variable_-_integer_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myIntegerArray",
"type": "Array",
"value": [
1,
2,
3,
4
]
}
]
},
"runAfter": {}
},
"Join": {
"type": "Join",
"inputs": {
"from": "@variables('myIntegerArray')",
"joinWith": ":"
},
"runAfter": {
"Initialize_variable_-_integer_array": [
"Succeeded"
]
}
}
},
分析 JSON
若要尝试分析 JSON 操作示例,可使用以下操作定义:
"actions": {
"Initialize_variable_-_JSON_object": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myJSONObject",
"type": "Object",
"value": {
"Member": {
"Email": "Sophia.Owens@fabrikam.com",
"FirstName": "Sophia",
"LastName": "Owens"
}
}
}
]
},
"runAfter": {}
},
"Parse_JSON": {
"type": "ParseJson",
"inputs": {
"content": "@variables('myJSONObject')",
"schema": {
"type": "object",
"properties": {
"Member": {
"type": "object",
"properties": {
"Email": {
"type": "string"
},
"FirstName": {
"type": "string"
},
"LastName": {
"type": "string"
}
}
}
}
}
},
"runAfter": {
"Initialize_variable_-_JSON_object": [
"Succeeded"
]
}
}
},
选择
若要尝试 选择操作示例,以下操作定义从整数数组创建 JSON 对象数组:
"actions": {
"Initialize_variable_-_integer_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myIntegerArray",
"type": "Array",
"value": [
1,
2,
3,
4
]
}
]
},
"runAfter": {}
},
"Select": {
"type": "Select",
"inputs": {
"from": "@variables('myIntegerArray')",
"select": {
"Product_ID": "@item()"
}
},
"runAfter": {
"Initialize_variable_-_integer_array": [
"Succeeded"
]
}
}
},
以下示例演示了从 JSON 对象数组创建字符串数组的操作定义,但对于此任务,在设计器中切换到映射框旁边的文本模式(T 图标)或改用代码视图编辑器:
"actions": {
"Initialize_variable_-_object_array": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "myObjectArray",
"type": "Array",
"value": [
{"Val":"1", "Txt":"One"},
{"Val":"2", "Txt":"Two"},
{"Val":"4", "Txt":"Four"},
{"Val":"10", "Txt":"Ten"}
]
}
]
},
"runAfter": {}
},
"Select": {
"type": "Select",
"inputs": {
"from": "@body('myObjectArray')?['value']",
"select": "@{item()?['Txt']}"
},
"runAfter": {
"Initialize_variable_-_object_array": [
"Succeeded"
]
}
}
},