Matt Darvell

Matt Darvell

  • 1.6k
  • 17
  • 1.5k

C# SSIS Send JSON Data HTTPClient

Oct 18 2023 11:03 AM

Good morning,

I have a folder full of json format files which need to be sent via C# inside a script task inside SSIS to an API. The SSIS will loop through (foreach is setup) and send each file.

Below is the format of all the files(all same format but different values etc):

"Time":"2018-10-21T00:08:03",
    "Control_Code": "JKX",
    "metrics": [
        {
            "Metric": 3721,
            "Organisation":"AD450",
            "Value": 20,
            "Datetime":"2018-10-21T00:08:00"
        },
        {
            "Metric": 1234,
            "Organisation":"HG650",
            "value": 88,
            "datetime":"2018-10-21T00:08:00"
        }
    ]
}

Can anybody assist or point me in the right direction on how to do this please?

I've been digging around online and found the following example starting point. Not sure if this can be adapted accordingly? Any help is appreciated.


Answers (1)