Закрыт

Pull data from API and import to MySql every hour with some logic requirements

Job Description:

I need to pull data from an API every hour and have it go to a MySQL database. The API connection works fine and is an established system. I have not set anything up yet in MySQL. Here's what I require:

The database needs to be like a Master List of all properties. When it pulls the data every hour it should add any rows that do not yet exist based on the unique key field called ListingID. If the row already exists, there is a field that indicates when the data in that row was last modified so if the data has been updated and the two dates don't match then the row should be updated. If the last update matches the date in the database then no need to save the data for that row. That's pretty much it for the Master List.

I will need secondary tables that pull from the primary list based on a different key field called DestinationId. Kind of like providing filtered rows to multiple other tables. When it copies from the master list to the other tables, the subtables need some extra columns to track when the price has been modified from an old price to a new price and same thing for certain other fields, only a few.

The exact nature of my project is that I'm a realtor and I have access to a data feed of all the real estate listings as a Master List. I work with other agents who need their own subset of specific rows from the master list imported to their own database table. Some properties will be copied to different sub table based on the DestinationId. From there, my integration can detect the change through the restAPI for MySQL and will trigger several automations. I can probably explain and demonstrate what I need better over a Zoom meeting.

Навыки: PHP, MySQL, Архитектура ПО, Программирование баз данных, Web API

О клиенте:
( 10 отзыв(-а, -ов) ) Winnipeg, Canada

ID проекта: #35402898

74 фрилансеров(-а) готовы выполнить эту работу в среднем за $486

OutsourceMan

Hello, This is Raman. We can help you with pull data from api and import to mysql every hour with some logic requirements. Our team is expert at this work. We completed more than 20+ Database, MySQL, SQL, API projec Больше

$393 CAD за 7 дней(-я)
(544 отзывов(-а))
8.8
sureshdevi

Hello, I will create PHP script to pull properties data from API and prepare Master list & sub list to analyze the data, price, few other fields. I will complete this work in 5 - 7 days. Looking forward to your reply Больше

$300 CAD за 7 дней(-я)
(1281 отзывов(-а))
8.2
AwaisChaudhry

Hi Good morning , How are you? I just saw your job posting . I see you have been looking for someone experience with these technologies Web API, Software Architecture, Database Programming, PHP and MySQL. I believe t Больше

$750 CAD за 22 дней(-я)
(109 отзывов(-а))
8.3
NickolaS

Hi there, I'm sure that will be able to help you with your RETS/RESO API task. Even more, I can make a whole system with interface based on roles, etc. So every your agent will have it's own data in the app. As there i Больше

$500 CAD за 2 дней(-я)
(397 отзывов(-а))
7.9
AutomationAdept

Hello there! This is right up my alley. I work with similar data systems constantly, and have set up long-running systems like this for many clients. I'd love to have a deeper discussion about the system you're trying Больше

$600 CAD за 2 дней(-я)
(89 отзывов(-а))
7.2
rsen75

Hi, 15+ years of experience with strong knowledge of API integration previously I did some data sync from api , so i can do this also Kindly check check my profile for my experience thanks Senthil

$600 CAD за 7 дней(-я)
(225 отзывов(-а))
7.4
fairchance

Dear Sir, Hi Thank you for giving us this opportunity to serve you professionally and productively. Here is the link to my profile reviews: https://www.freelancer.com/u/fairchance.html I am Microsoft Certified Techn Больше

$500 CAD за 8 дней(-я)
(99 отзывов(-а))
7.5
nixtech

Hello Sir I can set up cron job to fetch data from API and update property and secodnary table with latest data. I am willing to start right away. Please check my profile for work and experience. Regards Hardeep

$750 CAD за 3 дней(-я)
(376 отзывов(-а))
7.2
ayesha0124

Hi there, How r u? I have had a look at ur project i can handle it well as i have experience in Database Programming, MySQL, Web API, PHP and Software Architecture. I have worked on similar projects before too. Please Больше

$750 CAD за 7 дней(-я)
(23 отзывов(-а))
6.7
michealperfect

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Software Architecture, MySQL, Database Programming Больше

$500 CAD за 7 дней(-я)
(202 отзывов(-а))
7.2
mvlasaufree

Hello How are you? I have checked your project description with care and am very interesting on your project. What apis should be target to pull the data? and am interesting whether you've ready to use the remote serve Больше

$500 CAD за 5 дней(-я)
(12 отзывов(-а))
6.6
kreativesystem91

Hello, a pleasure to greet you, my name is Alex, I would be interested in working on your project, I have immediate availability I remain attentive to your comments Greetings

$300 CAD за 7 дней(-я)
(222 отзывов(-а))
6.4
feelinnovator

Hello, I am a MySql expert, and I will be able to help you with your project. I understand your requirement and I am located in Calgary, Canada so we can work closely to get these things in. Awaiting your response. Tha Больше

$750 CAD за 7 дней(-я)
(101 отзывов(-а))
6.3
chandankandar007

Dont say much more about me api . Seen api work list my projects expart if just send me info of your api . And details let's see work .coz work say better than words Thanks Chandan kandar

$400 CAD за 7 дней(-я)
(44 отзывов(-а))
6.4
Digiexpert90

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP Please come over chat and discuss your requirement Больше

$500 CAD за 7 дней(-я)
(12 отзывов(-а))
5.7
testotorko

Hey. I am an experienced Web Developer and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. Can start right now.

$250 CAD за 11 дней(-я)
(118 отзывов(-а))
5.8
d1master

Dear, client. This is a professional web developer with perfect skills of multiple web programming languages. Please check my portfolio for more information. Feel free to ask me any questions on the project on chat. He Больше

$750 CAD за 5 дней(-я)
(26 отзывов(-а))
5.9
valeriaomeldev

Hi, I have seen your job details carefully and it makes me so excited. Because I am a senior full stack developer and have 7 years of experience in website development. Especially, I have 5 years of experience in Back Больше

$600 CAD за 7 дней(-я)
(3 отзывов(-а))
5.0
AlexBodnaryk

Hey there, I’d like to be considered for your project, " Pull data from API and import to MySql every hour with some logic requirements". I have rich experiences in PHP, Web API, Database Programming, MySQL and Softw Больше

$500 CAD за 7 дней(-я)
(2 отзывов(-а))
4.3
mihailsbond

Hi there, The job requirement is clear to me. I can Pull data from API and import to MySql every hour with some logic requirements. Please send the quick message. I could finish this within 2 days. Looking forward to h Больше

$500 CAD за 7 дней(-я)
(11 отзывов(-а))
4.6