Getting FreshDesk data

Question

My assignment is to create and maintain a SQL Server data warehouse using FreshDesk server data.
I have an URL link similar to
https://xxx.freshdesk.com/reports/schedule/download_file.json?uuid=5asdsd24324vdfd2232f
When you open this, you get some Response text where you can find another URL link that we can use to download a CSV file.
I have to import data to SQL server data warehouse from this CSV file.
What is the best method to do this?

Answer 1

The best is to create a ETL process using a SSIS package = SQL Server Integration Services:
https://learn.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-package?view=sql-server-ver15

Answer 2

Hi @Hema Ramachandran ,

You may use TSQL query and SSIS to import the csv file data to SQL Server.

BULK INSERT testtable  
FROM 'D:\yourfilename.csv'  
WITH  
(  
    FIRSTROW = 2, -- as 1st one is header  
    FIELDTERMINATOR = ',',  --CSV field delimiter  
    ROWTERMINATOR = '\n',   --Use to shift the control to next row  
    TABLOCK  
)  

See here 3-easy-ways-to-import-csv-file-to-sql-server.

Here is also the SSIS tutorial to load csv file to SQL Server.

sql-server-import-csv-file-into-database-table-using-ssis

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 3

I solved this issue using power shell comands.
case closed.