使用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屋!