Closed

ETL of Zoopla data into an existing SQL Server DB

I need the property (i.e. real estate) listing data that is available via Zoopla (they provide a general API) for specific geographical areas to be loaded into an existing SQL Server Database. The property listing update process will need to run automatically (e.g. twice a day) and will upload all new property listings for the area and any listings that have been amended since the last successful data upload. An initial upload process will also be required of all existing listings (approx. 4000).

Zoopla provide an API (which I would expect you to use), however I would also like the “Last Sale” data that is available on the website (e.g. towards the right of this web page: [login to view URL] it says “Last sale £34,000 on 6th Feb 1998”). I am unsure if this bit of data is available through the API or not.

Error logging will be required, so if the upload process fails then it is easy to determine the reason why. If one property listing has an error in the data, this should not stop the other property listings from being uploaded.

I am a Business Analyst, former database developer, so hopefully will be able to provide a good specification and do any required work on the database side if needed.

Beceriler: API, Data Scraping, PHP, Powershell, Yazılım Mimarisi

Daha fazlasını gör: load excel data sheet sql server, load data excel sql server using asp, insert xml data type sql server using vba, ssis parallel data load, fastest way to load data into sql server, trace flag 610 sql server 2014, the data loading performance guide sql server 2016, fastest way to insert millions of records in sql server, sql server bulk insert performance, the data loading performance guide sql server 2012, sql server parallel bulk insert, php, use data excel sql server, save rows data table sql server 2005, stored procedure copy data table sql server 2000, insert xml data type sql server net, data mining sql server research, text data type sql server hibernate spring, data transfer sql server mysql, xml data transfer sql server

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #15206478

Bu iş için 23 freelancer ortalamada £182 teklif veriyor

srinichal

I am an expert in delivering custom scripts and tools Relevant Skills and Experience proven track record on this site Proposed Milestones £166 GBP - milestone

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(151 Değerlendirme)
7.5
letshappy

hello, i read your project carefully and i easily can do this task done ready to start work now thanks Relevant Skills and Experience have a look to my reviews thanks Proposed Milestones £266 GBP - 266

in %bids___i_period_sub_35% gün içinde266%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(140 Değerlendirme)
7.0
miracitech37

hello we have expertise in a website . we have developed we have 100 of website ping me on chat I will be explained more about my experience I do not have much space to write Relevant Skills and Experience I have Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
6.1
weonlydo

Hi antipodean friend, ** No, the last sale is not included in API. Could be part of "Zoopla Estimates" or "Property Historic Listings", but those require justification by request. Scraping listing by listing will be Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(67 Değerlendirme)
6.2
abdulghaffar11

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You! Relevant Skills and Experience API, Data Scraping, PHP, Powershel Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(87 Değerlendirme)
6.2
webprog4hire

hi i am expert in sql n servers and kindly check my feedback n lets discuss here Relevant Skills and Experience ready to start now Proposed Milestones £388 GBP - work

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(81 Değerlendirme)
5.7
wpmonsters

Hello, we are WordPress Monsters and we're ready to help you! We're trully comfortable working with WP as we have remarkable experience in this sphere. Over the last 2 years we have helped businesspeople to breath new Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(20 Değerlendirme)
5.3
nvbishr

Please send me details ,.................,........... Stay tuned, I'm still working on this proposal.

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)
5.4
Webbleu

As per your requirement of website developer for you are at the right place where you will get all your needs to be done with satisfaction and a quality work will be given to you. Relevant Skills and Experience I hav Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)
4.6
in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.5
BeautiCG

hello,dear. It's my pleasure meeting you. I have read your requirements and I fully went through it. I am confident and I am sure that I can do your project. Please contact me for further discussing. Thanks for your in Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(19 Değerlendirme)
0.0
malyadesign

I have extensive experience in PHP,Wordpress. Based on your requirements I would be happy to assist you and assure you for quality work within reasonable amount of time Relevant Skills and Experience PHP, ECOMMERCE, H Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
0.0
showmiksadnan

Hello Sir, I am Showmik. I am highly interested at your proposed work. I think, I am the best person for this job. I wont let you down if you give me the chance. Relevant Skills and Experience API, Data Scraping, PHP, Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde208%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
amjroseg

Hi, I am Rose.I am having more than 10 years of experience in this field. I can complete this work in 2 days. I am looking for long term good business relationship here. Let me know. Thanks Stay tuned, I'm still wo Daha Fazla

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
josefN

Hello, I can write you PHP or python script for Zoopla api. Here you can check possible output data for listings [login to view URL] (down below) Josef Odpovídající dovedn Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
0.0
DavidLindon

The last sale date and price may not be available via the api but I can scrape this from the page itself. Relevant Skills and Experience Development experience

in %bids___i_period_sub_35% gün içinde170%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
0.0
adilhussain0411

Hello, I am expert in web scrapping. I and I am certified web scrapper expert. I have completed 100+ projects web scraping -- for web scraping projects. Relevant Skills and Experience I have 7 years+ experience in da Daha Fazla

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
0.0
shahzaib121

Hi Dear We have a team expert in Extraction , Transformation & Loading. We have done many projects for many clients. We have develop many ETLs that execution job automatically. Relevant Skills and Experience We are ce Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
0.0
manjeet2017

Hi, I went through your requirement and feel comfortable to do this job. I have good experience in website design & development. Please initiate chat to discuss further. Relevant Skills and Experience PHP, Word press, Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)
0.0