如何使用SSIS使用用户标识/密码连接到REST API [英] How to connect to a REST API with userid/password using SSIS

问题描述

大家好！今天我接到了一项任务，我们将不得不使用REST API并将数据加载到表中以进行进一步的按摩。我试着谷歌，看看如何做到这一点。但没有找到太多材料。

Hello Everyone! Today I was given a task where we will have to consume an REST API and load data into a table for further massaging. I tried to google and see how this can be done. But didn't find much material.

此API将吐出JSON流。并且需要用户ID /密码才能连接。我知道我必须编写一个自定义脚本来实现这一目标。 

This API will be spitting out a JSON stream. And will need a userid/password to connect. I understand I will have to write a custom script to achieve this. 

我将非常感谢任何帮助!!

I will really appreciate any help!!

谢谢，

Abhi

推荐答案

嗨Abhi425，

Hi Abhi425,

最简单的是使用第三方工具，就像CozyRoc所说的那样（我不隶属于他们）。

The easiest is to use 3rd party tools as those say from CozyRoc ( I am not affiliated with them).

否则是的，你需要成为编码。

Otherwise yes, you need to be coding.

SSIS这也不是一个非常典型的任务，因为它通常位于DMZ的防火墙之后。

It is not also a very typical task for SSIS to do so because typically it is behind firewalls in DMZ.

无论如何，对于点，从这里借一个例子：
https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client

Anyways, to the point, just borrow the example from here: https://docs.microsoft.com/en-us/aspnet/web-api/overview/advanced/calling-a-web-api-from-a-net-client

并加入脚本任务。这就是全部。

And put into a Script Task. This is all.

这篇关于如何使用SSIS使用用户标识/密码连接到REST API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！