create C# app to download file from REST API, based on config in SQL Server DB

Suoritettu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

Need a program written in C# that will automatically download the suppression list files from Optizmo. Here is an example Optizmo link:

[login to view URL]

The program will need to connect to a SQL Server database and query a table called SuppressionConfig (see table definition below) for records where logintype='optizmo' where lastlogin is null or not within the past 24 hours. It should get the exact Optizmo URL from the csvurl field. Upon successful download, update the lastlogin field in the table for the particular SCID record.

A config file should specify the path/folder location to save the downloaded file to. The program should use the value in the downloadurl field in the table for the filename to save within that folder.

Should be able to connect to multiple databases to process records in suppressionconfig. The config file should allow us to specify 1..N SQL Server connection strings for the various databases.

The program could either use Optizmo's REST API (see documentation on that page) or automate the web interface. It would probably be more reliable to use the REST API.

CREATE TABLE [dbo].[suppressionconfig](

[scid] [int] IDENTITY(1,1) NOT NULL,

[csvname] [nvarchar](255) NULL,

[downloadurl] [nvarchar](255) NULL,

[csvseparator] [nvarchar](255) NULL,

[emailfieldname] [nvarchar](255) NULL,

[md5hashed] [bit] NOT NULL,

[retrieved_automatically] [bit] NOT NULL,

[whenadded] [datetime] NOT NULL,

[processstatus] [varchar](4) NOT NULL,

[whenupdated] [datetime] NULL,

[whenlastprocessed] [datetime] NULL,

[logintype] [nvarchar](25) NULL,

[csvurl] [nvarchar](255) NULL,

[username] [nvarchar](128) NULL,

[password] [nvarchar](128) NULL,

[lastlogin] [datetime] NULL,

[loginsuccess] [nvarchar](255) NULL,

CONSTRAINT [PK_suppressionconfig] PRIMARY KEY CLUSTERED

(

[scid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((0)) FOR [md5hashed]

GO

ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((1)) FOR [retrieved_automatically]

GO

ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT (getdate()) FOR [whenadded]

GO

ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ('N/A') FOR [processstatus]

GO

C# -ohjelmointi .NET Microsoft SQL Server Tietojärjestelmäarkkitehtuuri SQL

Projektin tunnus: #21798975

Tietoa projektista

33 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

Myönnetty käyttäjälle:

WeazenSoft

Dear Hiring Manager, I am an expert of Web Development. I would love to have the opportunity to discuss with you about your project. I have 12+ years experience as a developer. After a full understanding of your pro Lisää

$100 USD 10 päivässä
(14 Arvostelua)
5.3

33 freelanceria on tarjonnut keskimäärin $193 tähän työhön

aanvikm

Hello Sir, I am an expert in C# and API development and did several projects using the same. I am very positive that I can do this project. Thanks Aanvik

$250 USD 2 päivässä
(73 arvostelua)
7.2
ppgjsc

Hi This is Cui D from China. I read your description carefully and I'm sure I can build the good work for you. There are many projects I have done before like this project. You can see my profile and check it. I'm a Fu Lisää

$140 USD 7 päivässä
(30 arvostelua)
7.3
ITPyramid85

Hello, I am software developer with enough experiences on C# for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. Lisää

$150 USD 7 päivässä
(27 arvostelua)
6.9
abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$140 USD 7 päivässä
(162 arvostelua)
6.9
twentyten10

I have done many projects like this earlier, if awarded I can deliver it on time with all requirements implemented

$111 USD 3 päivässä
(58 arvostelua)
5.8
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lisää

$100 USD 3 päivässä
(78 arvostelua)
5.6
anuyadav1

hi, I have good experience with automating this kind of applications . I am interested in this project , please share more details .

$150 USD 2 päivässä
(48 arvostelua)
5.8
shakiralimit9

Dear Sir, I am Ali having 5+ years of experience in software development. My developed apps are fast, secure, easy to use and install. I am dedicated freelancer and can be available any time and can deliver your projec Lisää

$140 USD 7 päivässä
(17 arvostelua)
5.3
cma93

Hi, I'm an experienced developer. I'm interested in your task and would like to do it. Contact me anytime to get started............. Thanks.

$250 USD 7 päivässä
(22 arvostelua)
5.3
fivestar10

Hi! Nice to meet you. My name is kuanhui, .Net expert from China. I have read your project detail carefully. I have about 10 years of experience. I can complete your job within a few days. please contact me so that we Lisää

$250 USD 2 päivässä
(17 arvostelua)
5.0
ludiac

Hi there, We've reviewed the details of your project and we can create the app you described in project requirements. We would like to discuss further about it when you're online. Thank you!

$200 USD 3 päivässä
(10 arvostelua)
5.4
trustworthyDev

Hi, I have good experience in c# language, database integration. please contact me so that we can have a discussion in detail. Regards, Vu

$300 USD 7 päivässä
(7 arvostelua)
5.6
Mark98998

Hi, I have gone through your project description and I'm interested to work with you. I'm very passionate about my work and give good quality of work to client. I have more than 5+ years of experience in web developm Lisää

$340 USD 7 päivässä
(9 arvostelua)
4.8
vvishalsahu

Hi, I have done such types of projects earlier too. Please provide me a chance to do this for you. I have more than 9 years of development experience. You can check my reviews for more details. Thanks & Regards, Vish Lisää

$166 USD 3 päivässä
(26 arvostelua)
4.5
vw8313755vw

Hello, I have got your point. I need to call the rest api using api token every time for the data. And rest all details you have given are understandable clearly. I am C# developer having 8 years of experience. We c Lisää

$200 USD 3 päivässä
(3 arvostelua)
4.0
kennethgarza

Hello, This project seems deceptively simple. I have a question in regards to the download link. I clicked on the link above and it didnt take me to a pdf download. Are all the download links going to need to invol Lisää

$140 USD 4 päivässä
(4 arvostelua)
4.1
umairkaramat24

Hello There. How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills .NET, C# Programming, Microsoft SQL Server, Software Architecture, SQL. Please start the Lisää

$155 USD 9 päivässä
(5 arvostelua)
3.3
wolfman199311

Dear Client! Nice to meet you. I am a web&app expert from China. I'm a senior web&app developer with over 5 years of experience and very strong in this field. I can complete your job within a few days. please contact m Lisää

$140 USD 7 päivässä
(2 arvostelua)
2.5
MrxMartino

Hi, the project seems easy, with my >2 years of experience in C# I think I can do it for you. If interested, please contact me in the chat

$130 USD 4 päivässä
(1 arvostelu)
1.8
rohitrpawar

I have total experience of 7.5 years in software development in reputed multi national companies and majority of my experience is on .net technologies. Relevant Skills and Experience 7.5 yrs of relevant experience in Lisää

$122 USD 3 päivässä
(0 arvostelua)
0.0