使用SQl连接器Azure Logic应用程序更新和行ID [英] Update and row id with SQl connector Azure Logic apps

问题描述

所以我在这里有一个小问题.

So i have a little problem here.

Azure中的Update sql连接器，如何通过动态指定row_id来动态更新行.

The Update sql connector in azure, how do i dynamically update a row by dynamically specifying the row_id.

ROW_ID:

我尝试过:

@string(actions('Converter')['outputs'] ['body'] ['Id'])

@string(actions('Converter')['outputs']['body']['Id'])

在里面，从上一个动作开始，但是没有用，我得到一个错误.

inside there, from a previous action but it didnt work i get an error.

有什么好的方法吗?

推荐答案

经过一段时间的努力，我才设法使它正常工作.

I just managed to get that to work after some struggling.

问题似乎是由于某些UI错误，您无法在行ID列中选择动态内容.通过进入代码视图，我将使用与ID相同的表达式.

The problem seems to be that you can't select dynamic content into the row id column because of some UI bug. By going into code view I would use the same expression as for the Id.

有关如何更改路径的信息，请参见下面的示例.

See example below on how I changed the path.

                   "Update_row": {
                    "inputs": {
                        "body": {
                            "Id": "@{item()?['Id']}",
                        },
                        "path": "/datasets/default/tables/Inquiries/items/@{encodeUriComponent(item()?['Id'])}"
                    }
                }

这篇关于使用SQl连接器Azure Logic应用程序更新和行ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！