Devam Ediyor

Retrieve data from Zillow API and write to DB

Project Overview:

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 atabase. 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

Language Requirement: you must be able to communicate by email or Skype chat (text) in English

Details:

1) Zillow API is here: [url removed, login to view]

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 Express 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 [url removed, login to view] (

ID INT NOT NULL IDENTITY (1,1) PRIMARY KEY,

Retuit_StreetAddress VARCHAR(1000),

Retuit_City VARCHAR(100),

Retuit_State VARCHAR(100),

Retuit_ZipCode VARCHAR(100),

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,

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.

Beceriler: .NET, SQL, XML

Daha fazlasını görün: zillow api net, zillow api, data zillow, retrieve zillow data, use zillow api, zillow database schema, zillow app database, zillow'com, www zillow com, www zillow, set data, primary data, identity api, c language overview, api design, pull data zillow api, zillow database api, can pull data zillow, zillow database design, pull data zillow database, zillow address data, check data, write a note on get, address write in english, zillow

İşveren Hakkında:
( 3 değerlendirme ) Fort Mill, United States

Proje NO: #698663

Seçilen:

hoangngocit

Hi, I have more than 4 years of working experience in .NET. Using Zillow service to retrieve data is not difficult for me and I can communicate with you by email or Skype in English. This is my first project in freelan Daha fazlası

4 gün içinde 50$ USD
(3 Değerlendirme)
2.6

12 freelancer bu iş için ortalamada 154$ teklif veriyor

rizwanfpak

Please check your PMB. Thanks

in 8 gün içinde225$ USD
(3 Değerlendirme)
3.4
yngautam

we are .net and sql expert different api using import export data. for more see PMB

in 4 gün içinde199$ USD
(6 Değerlendirme)
3.0
AnySolutioner

Hi, i am ready to start ur project. Please check ur PM. Best regards...

in 2 gün içinde160$ USD
(3 Değerlendirme)
3.0
avisUK

Hi, We can do it and will available through chat / [url removed, login to view] PM for more details

in 5 gün içinde200$ USD
(0 Değerlendirme)
0.0
sahusantosh

please see this url [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] I have a experience empolyee in our team in php,java,,joomla,.net,drupal,a Daha fazlası

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
ansolutions786

Dear Sir We have 5 years experience of programming in ASP.NET , SQL SERVER, VB.NET, C#, Visual Basic and SQL Server I already have work on different API's and also have a good experience of programming with it We al Daha fazlası

in 7 gün içinde150$ USD
(0 Değerlendirme)
0.0
manoj22184

Hi, I am interested to work on this project . Please check your PMB. Thanks, Manoj.

in 10 gün içinde100$ USD
(0 Değerlendirme)
0.0
deepakmalik866

I possess 2 years of experience in Web Development. My strengths are in ASP.Net, C#.net, VB.net, Sql Server 2005, AJAX, Silver Light, WCF, WPF, LINQ, MVC, 3-tier architecture, JQUERY,Java Script, Custom Control, Web u Daha fazlası

in 5 gün içinde200$ USD
(0 Değerlendirme)
0.0
invarbrass

Mr. Norberg: Thank you for posting the project requirements in vivid detail! I am a skilled C#/.net, Delphi developer with extensive experience in MS SQLServer, MySql, Firebird and SQLite databases. I have also experie Daha fazlası

in 10 gün içinde150$ USD
(0 Değerlendirme)
0.0
jsoto

Hi chrisnorberg, Please see PMB for details, Thanks, Jesus Soto

in 4 gün içinde150$ USD
(1 Değerlendirme)
0.0
SuccessBull

Let's work. i'm ready to start. I have dome numerous MS SQL data extraction projects, worked with API and vb.net.

in 10 gün içinde160$ USD
(0 Değerlendirme)
0.0