根据内容使用动态循环获取REST-可能吗? [英] Fetching REST with dynamic Loop according to content - Possible?

问题描述

我目前正在评估数据集成工具，以连接不同的系统以在中央数据库中收集和存储数据.

在以下情况下.可以使用Azure Logic应用来实现吗?

每天使用动态变量"start_date"调用一次REST-Api.提供当前日期. Api将以JSON格式返回多达500个数据集.结果必须被解析，并且"ID"必须被解析.必须存储最后一个数据集.然后是Api 必须再次调用，并使用上一次调用中的最后一个ID作为附加参数.

必须重复此循环，直到服务没有返回新行.必须解析所有接收到的JSON数据集(具有父级和N个子级的嵌套数据集)，并直接导出到PowerBi或1..N表，例如到Google BigQuery.

如果答案是是":我在哪里可以找到有关如何实现这种动态集成的一些文档/教程?

非常感谢！

亨里克

解决方案

从高层次看，使用Logic App似乎是可以完成的任务.请查看以下文档，我认为这些文档涵盖了此方案所需的连接器和操作.

https://docs.microsoft.com/en -us/azure/logic-apps/logic-apps-examples-and-scenarios

https://docs.microsoft.com /en-us/azure/logic-apps/logic-apps-data-operations-code-samples

https://docs.microsoft.com/en-us/azure/connectors/apis -list

您还可以为自定义逻辑考虑Azure函数.

Hi There,

i'm currently evaluating data integration tools in order to connect different systems to collect and store data in a central database.

On scenario is the following. Could this be realized with Azure Logic Apps?

Call a REST-Api once a day with a dynamic variable "start_date" providing the current date. The Api will return up to 500 datasets in JSON-Format. The result must be parsed and the "ID" of the last dataset has to be stored. Then the Api has to be called again with the last ID from the previous call as an additional parameter. 

This loop has to be repeated until no new rows are returned by the service. All the received JSON Datasets have to be parsed (nested dataset with parent and N Childs) and exported either directly to PowerBi or to 1..N Tables e.g. to Google BigQuery.

If the answer would be "yes": Where can i find some documentation/tutorials about how to implement such dynamic integrations?

Thanks a lot in advance!

Henrik

解决方案

Looking it from the high level this seems to be an achievable task using Logic App. Check the below documentations which I believe covers the required connectors and actions for this scenario.

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-examples-and-scenarios

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-data-operations-code-samples

https://docs.microsoft.com/en-us/azure/connectors/apis-list

You can also think for Azure Functions for your custom logic.

这篇关于根据内容使用动态循环获取REST-可能吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！