在SSIS中使用C#读取JSON API

using System;
using System.Data;
using System.Net.Http;
using Newtonsoft.Json;

public class ScriptMain : UserComponent
{
    public override void CreateNewOutputRows()
    {
        HttpClient client = new HttpClient();
        string apiUrl = "https://api.example.com/data"; // 替换为实际的API地址

        HttpResponseMessage response = client.GetAsync(apiUrl).Result;
        if (response.IsSuccessStatusCode)
        {
            string json = response.Content.ReadAsStringAsync().Result;
            dynamic data = JsonConvert.DeserializeObject(json);

            foreach (var item in data)
            {
                Output0Buffer.AddRow();
                Output0Buffer.Column1 = item.property1;
                Output0Buffer.Column2 = item.property2;
                // 添加其他需要的列
            }
        }
    }
}