Create a Script to Download All Listings Data from eBay Motors API in Python 3

We need to get all vehicle listings on eBay Motors via the eBay Motors API. The following fields need to be collected for each posted vehicle:

Year, make, model, trim, mileage, VIN, title type, body type, exterior color, transmission, number of cylinders, fuel type, number of doors, drive type, number of views, number of watchers, ad number, price, location, date posted, date updated, listing title, url, and description (text only).

We already have an API key.

Needs to be written in Python 3. Needs to run inside a Docker container.

We need the script. The script needs to be able to be repeatedly run in a Docker container.

The script needs to be able to run continuously by itself, or to wait an interval (number of minutes) after it finishes before beginning again.

The script needs to be able to search by all of the search filters that the ebay API offers. They need to be optional (such that it will run without any filters).

The script needs to be able to accept all of the following as optional arguments:

- filters from eBay

- debug mode

- verbose mode

- interval (in minutes) to wait before restarting

It needs to feed the data into our existing MySQL 5.7 2nd generation InnoDB database on Google Cloud Platform with the following table structure (which will be done using the Google Cloud SQL Proxy):

Please see the attached file for the database table structure / DDL and some details about the fields.

The API method returns only 10,000 results at a time, in pages of 100 results each. The API limits us to 5000 calls / day.

The script will need to work with these constraints to get all new listings and all updated listings since it was last run every time.

The call to the API should filter the results to:

- location = US, Canada

- ListingType = AuctionWithBIN, Classified, and FixedPrice

The script should store all times in UTC.

Each time the script is run, it needs to get the data from all the listings that have been created or updated since the last time it ran (even if the last time it ran was days or weeks ago).

Each time the script finds a listing that already exists in the database, it needs to update all fields in the row in the database. It should also update the date_updated field each time.

All fields need to have commas removed from them before they enter the database.

Any time a field does not have a value or has 'not specified' as the value, it should be stored as NULL.

The location field should be stored as city state zip

The script needs to output everything to a log file for debugging.

The scrape should break gracefully on Ctrl + C.

Script needs to use "source = 'ebay'" for SQL statements since the table contains records from other sources.

Each time the script finishes running, it should output some status elements (such as how many items were created vs updated).

Please let me know which days you will be working on my project, and how many hours / day.

The code should be self documenting (good method names, variable names, structure, etc.).

All of your code needs to be well commented.

Your code needs to have good error handling.

Your code needs to follow good programming practices and standards.

We will manage all code and issues via GitHub. You will use the Projects feature of GitHub to show work you have not started, work in progress, and work completed.

I expect that you will complete it in the timeframe you quote. Otherwise, we will cancel the contract.

Please feel free to ask any questions you need!

Skills: Python, Web Scraping, Data Scraping, Data Extraction, Web API

See more: ebay completed listings data, create script harvest data, create script net retrieve data, free ebay clone script download, create macro download data yahoo finance, python script download historical data yahoo, script download google finance data python, create youtube script download, ebay motors api create listing, create script extract data, collect ebay completed listings data, ebay motors php script, ebay motors data mining, script download data internet, create script data entry, php data collection script download, perl script download data, website script download data

About the Employer:
( 3 reviews ) Riverton, United States

Project ID: #21155929

28 freelancers are bidding on average $194 for this job


Hi Paul , I am interested in your project related to build a scraper for ebay Motors API. Please send me a message so that we can discuss all the details. Thanks, Ramzi

$500 USD in 12 days
(470 Reviews)

Hi there, This is Lin, i did more than 380+ scraping project, please view my profile page here then you will know. Can we discuss more details about your project? then i ca More

$210 USD in 5 days
(302 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$220 USD in 4 days
(43 Reviews)

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some More

$250 USD in 3 days
(75 Reviews)

Hi, Hope you are doing well! I have checked your requirement. I can do this project as i am professional Python,SCraping Expert. It will be our great pleasure to work on your project. I'll complete the work as per req More

$140 USD in 7 days
(45 Reviews)

Hello. ~~~ i CAN DO IT IN 6 HOURS ~~~ Please contact me. I' d love hear from you. Thanks Best Regards.

$160 USD in 7 days
(58 Reviews)

Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON More

$166 USD in 3 days
(86 Reviews)

⭐⭐⭐Dear sir!⭐⭐⭐ I am very interested in your project and I am exciting. I read your project details carefully and I though that I am the best fit developer for your project. I have rich experience about your project, s More

$200 USD in 7 days
(17 Reviews)

Dear Employer I have extensive expereince in scraping product data from Amazon I can assure you I can fulfill all your requirements as per task description. Should you be interested please let me know and I would be More

$110 USD in 5 days
(63 Reviews)

HI, there! I have read your description carefully. I have high Python skill and can scrape data from the website. I can agree with your suggestion that I have to work via Github. Please contact me and discuss more.

$250 USD in 7 days
(20 Reviews)

Hello, I'm [login to view URL] python BeautifulSoup,Selenium,Scrapy is very simple for me. I can give you good delivery on time with good partnership. Please don't waste your time to auto bidding bot. Please send message and d More

$140 USD in 7 days
(14 Reviews)

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient worker More

$140 USD in 7 days
(31 Reviews)

Hello Sir, I am professional developer with having more than 5 year's experience in this field. I read your project description and I am interested in it I need some more information related to your project Can we disc More

$250 USD in 7 days
(9 Reviews)

Hope you are doing well I have enough experience of web scraping over 4 years with expressjs, python and etc and once you permit me, it's no problem. For what you want to scrape, I will accomplish at most in a few day More

$230 USD in 5 days
(3 Reviews)

Hi sir, i am experienced in scraping, i did many similar jobs which you can see in my reviews, i have developed some codes already so the speed will be high for your job, would you please share the details?

$30 USD in 7 days
(7 Reviews)

Hello. I am a senior Python developer and I have plenty of experience in Python development. I have developed the web scraping app using Python3. And I have developed the python program for the data transfer between tw More

$120 USD in 7 days
(14 Reviews)

Hello, I am a lead developer at custom software development company - Resera. Our experienced designers and developers who have expertise in business process automation can help you with your project. We use agile app More

$200 USD in 7 days
(4 Reviews)

Hello. Do you want scrapping result as csv file? I have tons of experience with web scrapping result by using python. lets discuss in detail over chat. Best regards.

$150 USD in 2 days
(5 Reviews)

Hi,Dear! I just have checked your job description. I am a website expert and have enough knowledge with php,Javascript,css,[login to view URL], Python/Django is my top [login to view URL] u hire me ,u will be get a good freelancer. I More

$100 USD in 7 days
(1 Review)

Hi, I am kahan. I am python developer and have much experienced. Waiting for further discussion. Thank you.

$180 USD in 7 days
(2 Reviews)