Extract data from Rest API using SSIS Script task

Question

I am new on SSIS, and I don't have a good knowledge of C# Code.
Can you please help me on how to write the code in getting the data by calling a Rest API, I have the API and I am able to do all the transformation after getting the data. I am only stuck with extracting data due to my limited knowledge on C#

Answer 1

Hi @thavha,

Such question was already answered on this forum.

Check it out here: https://learn.microsoft.com/en-us/answers/questions/182096/calling-a-restful-api-in-ssis-and-returning-output

Answer 2

Hi @thavha,

You may also check below links.

https://learn.microsoft.com/en-us/answers/questions/726424/write-c-code-to-get-the-data-from-rest-api-using-s

https://stackoverflow.com/questions/65067235/ssis-package-to-call-rest-api-and-store-in-sql-tables

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.