Completed

JSON to mysql

This project was successfully completed by ccousinshome for $34 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
8
Project Description

I need to scrape data from following link and dump it in mysql database. This link has information of up to 50,000 products and it is updated everyday. I would need to empty the database everyday and refresh this query every hour to download the data in mysql.

SAMPLE NEEDED - send me a sample csv file or a mysql table for today's available deals.

[url removed, login to view]

I want following fields in the table:

id

title

short_title

description

fine_print

number_sold

url

untracked_url

price:

value:

discount_amount:

discount_percentage:

commission:

provider_name:

provider_slug:

category_name:

category_slug:

image_url:

online: true,

expires_at:

created_at:

updated_at:

merchant:

id: 257115,

name:

address:

locality:

region:

postal_code:

country:

country_code:

latitude:

longitude:

phone_number:

url:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online