是否可以使用Azure数据工厂从VSTS REST API进行get调用? [英] Is it possible to make a get call from a VSTS REST API using Azure data factory ?

问题描述

我正在尝试使用个人访问令牌(PAT)从VSTS REST API中获取数据.通常，使用C#或Powershell解决方案很容易，但是考虑到我们使用本机应用程序访问云端点，肯定会浪费很多时间.

I am trying to get data out from VSTS REST API's using Personal Access Token (PAT). Generally this is easy using a C# or a powershell solution, but it definitely consumes a lot of time considering that we hit a cloud endpoint using a native application.

我的问题是关于ADF的！！我们能否使用ADF来访问VSTS REST API(具有集成的身份验证方法)，解析json响应&

My question is with respect to ADF!! Can we hit VSTS REST API (which has an integrated authentication method) using ADF , parse the json response & dump the return into a SQL datawarehouse ? 

推荐答案

NitinSapru，

NitinSapru,

从表面上看，您应该能够使用

From the looks of things, you should be able to access the REST API using the Web Activity.

由于您有需要解析的Json，因此可能需要其他路由.我可以建议使用逻辑应用程序或Azure函数来调用REST终结点并解析Json.如果您将其拉回ADF，则取决于您需要执行的操作.

Since you have Json that needs to be parsed other routes may be needed. A few I can suggest is using a Logic App or Azure Function to call the REST endpoint and parse the Json. If you pull that back in to ADF is up to what you need to do.

为澄清起见，如果您使用的是Logic App或Azure函数，则仍需要Web活动来调用启动这些操作所需的Webhook. Logic Apps具有Json解析器和Azure数据仓库连接器.该过程可能返回完成/失败/或 数据，具体取决于您返回ADF的情况.

To clarify, if you used the Logic App or Azure Function, the Web Activity would still be needed to call the webhook needed to start these operations. Logic Apps has a Json parser and an Azure Data Warehouse connector. The process could return completion/failure/or data depending on your scenario back to ADF.

谢谢！

这篇关于是否可以使用Azure数据工厂从VSTS REST API进行get调用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！