This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 28.999999999999996%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
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#
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
@thavha, Please clarify what you need to do:
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
Hi @thavha,
You may also check below links.
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.
Hi @thavha,
Do you have further question on this, could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)