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.
74 freelances font une offre moyenne de 486 $ pour ce travail
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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
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 Plus
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
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 Plus
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 Plus
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 Plus
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
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 Plus
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
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus