azure - 没有密钥的 JSON 数组 - Azure 逻辑应用

Question

我的 JSON 数组如下。

[{"20656":"20656","20648":"20648","20666":"20666","20657":"20657","20658":"20658","20659":"20659","20660":"20660","20665":"20665","20672":"20672","20667":"20667","24517":"24517","20677":"20677","20662":"20662","24605":"24605","20675":"20675","20663":"20663","20649":"20649","20664":"20664","20668":"20668","20669":"20669","20670":"20670","20671":"20671","20673":"20673","20674":"20674","20676":"20676"}]

如何使用每个单独的值并将其用作下一个查询的变量。

谢谢，

标签： azureazure-logic-apps

Answer 1

假设你的变量看起来像这样

添加选择操作

其中From属性设置为

split(replace(replace(replace(variables('MyJsonArray'),'[{',''),'}]',''),'"',''),',')

并映射以将MyID与表达式配对

substring(item(),0,lastIndexOf(item(),':'))

现在您可以使用简单的Foreach简单地遍历所有 ID，并使用表达式引用每个 ID

item()['MyID']