create C# app to download file from REST API, based on config in SQL Server DB
$30-250 USD
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
Projektin tunnus: #21798975
Tietoa projektista
Myönnetty käyttäjälle:
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ää
33 freelanceria on tarjonnut keskimäärin $193 tähän työhön
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
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ää
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
I have done many projects like this earlier, if awarded I can deliver it on time with all requirements implemented
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ää
hi, I have good experience with automating this kind of applications . I am interested in this project , please share more details .
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ää
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.
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ää
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!
Hi, I have good experience in c# language, database integration. please contact me so that we can have a discussion in detail. Regards, Vu
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ää
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ää
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ää
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ää
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ää
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
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ää