Færdiggjort

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

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

Evner: C# Programmering, .NET, Microsoft SQL Server, Software Arkitektur, SQL

Se mere: create iphone app binary file, api send sms sql server, using sms api send sms sql server 2008, create iphone app excel file details included, android app download file web server, create iphone app excel file, query based time sql server, download file rest api sharepoint online, send email based data sql server table, design a logo for a web/app it needs to come in version with name and with logo only so i can use it in our web page logo for th, wordpress to android app using wp rest api tutorial, wp rest api - oauth 1.0a server, c# webclient download file https, c# post json to rest api, call rest api from pl/sql, ecommerce app with magento rest api, c# ftp download file to directory, app store connect rest api, c# httpclient download file progress, download php rest api

Om arbejdsgiveren:
( 34 bedømmelser ) Brooklyn, United States

Projekt ID: #21798975

Tildelt til:

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 Flere

$100 USD in 10 dage
(12 bedømmelser)
5.1

42 freelancere byder i gennemsnit $187 på dette job

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 Flere

$140 USD in 7 dage
(28 bedømmelser)
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. Flere

$150 USD in 7 dage
(27 bedømmelser)
6.9
ineedWorkJob

Greetings sir, I have read your project details and i will develop the software that will connect with Optizmo via api and download the file based on config on sql server. Sir, i can deliver this project sooner t Flere

$200 USD in 2 dage
(200 bedømmelser)
7.1
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 in 2 dage
(61 bedømmelser)
7.0
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 in 7 dage
(134 bedømmelser)
6.7
adeelpirzada

Hi, Allow Me to Introduce Myself I am a Full Stack Lead Developer with a Decade of Experience with strong Expertise in Nodejs , ReactJs and Angular using Mysql or MongoDB. I have comprehensively developed soci Flere

$175 USD in 7 dage
(45 bedømmelser)
6.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 in 2 dage
(47 bedømmelser)
5.7
tyang0928

Hi.there. I have fully checked your project ''. I am sure that I can do your project perfectly. I am a Lead/Web/Mobile developer with 11 years of experience. I read fully your requirement and I am sure I can finish yo Flere

$140 USD in 7 dage
(7 bedømmelser)
5.3
twentyten10

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

$111 USD in 3 dage
(44 bedømmelser)
5.5
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 in 3 dage
(10 bedømmelser)
5.4
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 Flere

$340 USD in 7 dage
(9 bedømmelser)
4.8
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 in 7 dage
(21 bedømmelser)
4.8
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 Flere

$250 USD in 2 dage
(17 bedømmelser)
5.0
ganeshrasekar

I can do it i am expert in Api

$140 USD in 7 dage
(26 bedømmelser)
5.0
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 in 7 dage
(7 bedømmelser)
5.5
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 Flere

$140 USD in 7 dage
(11 bedømmelser)
4.6
vSanta727

Hello. I'm a C#, .NET expert and have many experiences in MS SQL and several types of APIs. I'm absolutely sure I can do this work perfectly. Please feel free to contact me. Thank you.!

$140 USD in 7 dage
(11 bedømmelser)
4.5
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 Flere

$166 USD in 3 dage
(17 bedømmelser)
4.0
FtcITGuys

Hi, I am an experienced .NET developer with great skills you mentioned in your description. As MCP and MCTS, I know all the area of .NET technology. Thanks.

$200 USD på 1 dag
(8 bedømmelser)
4.2
Scorpius1116

Unity Game/ VR & AR development Expert here I have 7 years of Unity game development experience and i have deep knowledge about Unity development. Probuild, 3d max, C#, animation, photoshop are all familiar for me and Flere

$140 USD in 7 dage
(4 bedømmelser)
4.0