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
)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]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((0)) FOR [md5hashed]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((1)) FOR [retrieved_automatically]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT (getdate()) FOR [whenadded]
ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ('N/A') FOR [processstatus]
42 freelancere byder i gennemsnit $187 på dette job
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
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!
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.!
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.