Retrieve data from Zillow API and write to DB

Create an .NET windows app that will pull addresses from our SQL Server database and then use the Zillow API to retrieve data about the address, and then write the data back to our DB. App should include a scheduling feature: once per day the app should check the DB for new records and then get data from Zillow for the new records. All SQL retrieval and saves should use stored procedures. Language Requirement: you must be able to communicate by email or Skype chat (text) in English Details: 1) Zillow API is here: [login to view URL] AND [login to view URL] 2) After the app is built you must install the app on our sever and test it. You can connect to our server remotely to do this 3) Must be able to handle ~10,000+ records. We plan to process 1,000 per day (Zillow's current maximum). 4) Environment is Windows 7 operating system and a SQL Server DB 5) If Zillow returns an error for an address, then we must record the error code in the DB 6) Here is the prelimnary design for our table in the DB. Note: you can modify the schema if necessary. Retuit_* fields contain the addresses for which we must retrieve data from Zillow. Zillow_* is where we will write the data returned from Zillow API. create table dbo.tZillow_Properties ( ID INT NOT NULL IDENTITY (1,1) PRIMARY KEY, StreetAddress VARCHAR(1000), City VARCHAR(100), ST VARCHAR(100), ZipCode VARCHAR(100), NumCompsToObtain INT, ReturnRentEstimate, TINYINT, -- 1=YES, 0=NO RecordStatus VARCHAR(100), --values: Completed, Error, NULL Zillow_StreetAddress VARCHAR(1000), Zillow_City VARCHAR(100), Zillow_State VARCHAR(100), Zillow_ZipCode VARCHAR(100), Zillow_Latitude FLOAT, Zillow_Longitude FLOAT, Zillow_Zestimate FLOAT, Zillow_LastUpdated DATETIME, Zillow_ValuationRange_High FLOAT, Zillow_ValuationRange_Low FLOAT, Zillow_UseCode INT, Zillow_UseCode_Description VARCHAR(1000), Zillow_TaxAssessment_Year INT, Zillow_TaxAssessment FLOAT, Zillow_YearBuilt INT, Zillow_LastSoldDate DATETIME, Zillow_LastSoldPrice FLOAT, … ALL ZILLOW FIELDS Zillow_ErrorCode INT, Zillow_ErrorCode_Description VARCHAR(1000) ) 7) Set RecordStatus = 'completed' if the address is returned from Zillow without an error. Set = 'Error' if Zillow returned an error. NULL value means the address has not been processed yet. tZillow_Properties – table to pull addresses, and where to save individual returned fields in same record. Create and use a stored procedure to pull addresses. Name the stored procedure as [USP_Research_Addresses]. Fields to pull with required params • Param_Address • Param_City • Param_ST • Param_Zip • Param_NumCompsToObtain – in between 1-25; if 0 (zero) then don’t get any comps for this property • Param_ReturnRentEstimate EXAMPLE RETURN DATA for search Param_Address Param_City Param_ST Param_Zip Param_NumCompsToObtain Param_ReturnRentEstimate 123 Main Street Denver CO 75231 0 Yes 636 North Hanover Pittsburgh PA 14567 25 No 1 Eagles Way Philadelphia PA 12587 25 Yes Return ALL FIELDS from GetDeepSearch-Results ([login to view URL]) • AutoCounter – primary key (int) • ZPIP (from Zillow return) Parameters required by Zillow: Count – from Param_NumCompsToObtain above RentZestimate – from Param_ReturnRentEstimate above Preface all created fieldnames with “Zillow_”, e.g., [Zillow_Link_HomeDetailsPage] and replace any field name spaces with underscore “_” SAVE using stored procedure! [USP_Research_SavePropertyInfo]   tZillow_Comps – individual records for each returned comp if field [Query_NumCompsToObtain] > 0 • AutoCounter – Primary key (int) • CompareTo_ZPIP • ZPIP RETURN ALL FIELDS returned from GetDeepCompsAPI ([login to view URL]) Preface all created fieldnames with “Zillow_”, e.g., [Zillow_Link_HomeDetailsPage] and replace any field name spaces with underscore “_” SAVE using stored procedure! [USP_Research_SavePropertyComps]