主页 / user-21494658

microsoftdeveloperdesigner's questions

Martin Hope
microsoftdeveloperdesigner
Asked: 2024-12-05 02:39:22 +0800 CST
  • 6

我在 Apply To each 中执行多个 API 调用，以便从同一外部 API 获取不同日期/时间的数据。然后我执行以下操作：-

  1. 从 API 调用响应中删除 SOAPTAgs
  2. 将结果转换为 XML
  3. 将 XML 转换为 JSON
  4. 解析 JSON
  5. 过滤 JSON
  6. 循环遍历 FilterJSON-IncludeUser 的结果并将项目附加到名为“jointJson”的数组中

在此处输入图片描述

以上是就功能而言的工作，我将从“JointJson”数组内的所有 API 调用中获取所有 JSON。但这需要时间，主要是在“应用于每个 3”上，我正在构建“JointJson”数组 + 工作流消耗了许多操作，超出了我可以拥有的阈值限制，即每 24 小时 48,000 次调用。

所以我的问题是，有没有办法将 FilterJSON-IncludeUser 操作的结果加入到 ApplyToEach 中，而不必循环遍历结果并使用 ApendToArray？

“FilterJSON-IncludeUser”的结果如下：-

{"body":[{"@Id":"19267384","@AgentId":"11**","@CallDuration":"0:00:49","@CallOrigin":"Outbound - Manual","@CallSegment":"Initial","@CallTime":"12/2/2024 5:51:30 AM","@Campaign":"Affiliate","@ContactId":"42***74","@Group":"Openers","@InboundPhone":"","@LeadFullName":"Dj*** T***","@LeadId":"42***","@ProspectPhone":"+1***","@RecordingUrl":"","@Result":"Conversation","@TargetNumber":"+1 5***","@User":"****","@WaitTime":"","@CallId":"2****"},{"@Id":"19267387","@AgentId":"11657","@CallDuration":"0:00:35","@CallOrigin":"Outbound - Manual","@CallSegment":"Initial","@CallTime":"12/2/2024 5:52:54 AM","@Campaign":"Affiliate","@ContactId":"428***","@Group":"Openers","@InboundPhone":"","@LeadFullName":"**","@LeadId":"4286***","@ProspectPhone":"+*****","@RecordingUrl":"","@Result":"Conversation","@TargetNumber":"+1 ***","@User":"****","@WaitTime":"","@CallId":"C***7"}]}

否则它将是空的。

有什么建议吗？

谢谢

power-automate