Looking on pulling information from an API and placing it into SQL which we can then report on.
Report will be designed by me but information needs to be in the tables and in the correct format.
API Information is here: [url removed, login to view]
Your main task is to develop a script/program to collect event and alert data from Sophos Central API into MS SQL tables that can be used for reporting.
You can base your script/program on this simple python script - [url removed, login to view] - which offers command line, file or syslog output in CEF, JSON or key-value pair formats
You will be given API Documentation (Provided) and access to the SQL DB.
API is per customer, once we have it working for 1 customer we need it replicated for all customers.
LOOKING FOR AN ONGOING RELATIONSHIP WITH MORE API -> SQL PROJECTS COMING.
Hello Sir, I am an API expert and interested in this project. Please open chat to discuss more. Thx Aanvik Relevant Skills and Experience API, SQL Server Proposed Milestones $155 AUD - Milestone
19 freelancers are bidding on average $170 for this job
I can write simple Python script that will make API calls and output into MSSQL database. I'll complete it in less than two days and all I need to start is API credentials and your database schema. Thanks. Roman