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(99.2, 3%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
I am currently trying to use a script to download the results of an API call using RestSharp.
The result of the call is a html page saying that Javascript and cookies are not enabled even though IE settings have all enabled.
I have tried moving the code to a console app c# running on same machine and all works well.
What might be causing the issue here?
Thank you
Is this SSIS package running as a job under service account?
A service account don't have a profile and so no Internet Explorer setting.
Hi Olaf.
At this point I don't think that's the case since we are running the package in debug mode directly from VS.
![](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(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi @Luis Simoes ,
Could you please share the example code in the Script Task?
RestSharp is a comprehensive, open-source HTTP client library that works with all kinds of DotNet technologies. It can be used to build robust applications by making it easy to interface with public APIs and quickly access data without the complexity of dealing with raw HTTP requests. RestSharp combines myriad advantages and time-saving features with a simple, clean interface, making it one of the hottest REST tools being used today.
Please refer to the following links:
1.What is RestSharp? An Introduction to RestSharp’s Features and Functionality
2.How To Consume Web API Through SSIS Package
Best regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Mona,
Where can I share the code with you? I will be able to share without any credentials.
Sending the example I used on the console app, its pretty much the same used but instead of writing the output to console I am trying to write to a file.
Thank you
Hi @Luis Simoes ,
Please use Try catch / Error Handling in the Script Task to get more error messages.
Hope the following link will be helpful:
Script Task Debugging in SQL Server Integration Services (SSIS)
Best regards,
Mona
Hi Mona,
The script do not fail. What fails is the output of the RestSharp request that should be delivering a CSV file and instead is returning an HTML file mentioning issues with cookies etc...
Hi @Luis Simoes ,
Hope the following link will be helpful:
How to set cookie in browser using restharp?
Best regards,
Mona
