Find Jobs
Hire Freelancers

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

$250-750 CAD

종료됨
게시됨 1년 이상 전

$250-750 CAD

제출할때 지불됩니다
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.
프로젝트 ID: 35402898

프로젝트 정보

72 제안서
원격근무 프로젝트
활동 중 1년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
72 이 프로젝트에 프리랜서들의 평균 입찰은 $489 CAD입니다.
사용자 아바타
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 projects in recent past. We would love to have the opportunity to discuss your project with you. Thank you for your time and consideration. RamanL
$393 CAD 7일에
4.9 (552 건의 리뷰)
8.8
8.8
사용자 아바타
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 to start this work immediately. I am available online for 8 - 10 hours per day as a full-time freelancer.
$300 CAD 7일에
5.0 (1287 건의 리뷰)
8.2
8.2
사용자 아바타
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 this is some thing I can help you with because I have 9 years of experience working with these tech stacks and 8 years of experience working on freelancer.com which you can confirm from my profile: https://www.freelancer.com/u/AwaisChaudhry I have few questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements. 2. Do you currently have anything done like Wireframes, UI/UX? Or this job has to be done from scratch? 3. What is the timeline to get this job done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Lets start the chat and discuss your job in detail and we will continue from there. Regards, Awais
$750 CAD 22일에
4.9 (111 건의 리뷰)
8.3
8.3
사용자 아바타
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 is no much details provided, the bid is placeholder for now. In my understanding, that should be enough to cover the needs of your task. Just contact me by chat so we will discuss everything. Thanks
$500 CAD 2일에
5.0 (397 건의 리뷰)
7.9
7.9
사용자 아바타
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일에
5.0 (386 건의 리뷰)
7.3
7.3
사용자 아바타
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 Technology Specialist (MCTS) in SQL Server. I am also Top Zoho CRM expert and API Integration Specialist. I have read all your job posts and am fully well versed in your requirements. I can integrate your app with MySQL through API for pushing required data within one hour as per your functional requirements efficiently and professionally. Let us discuss the scope, timeline, and cost of the project. Sir, if I have a chance, I will prove to you that I am the freelancer you are looking for. Kind Regards Fairchance Microsoft Certified Technology Specialist (MCTS) Zoho Certified CRM Consultant / Zoho Certified Creator Developer – Associate/
$500 CAD 8일에
4.9 (103 건의 리뷰)
7.5
7.5
사용자 아바타
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 to build here. Very interested in potentially putting it together for you. Let's discuss further. Thank you for your time!
$600 CAD 2일에
5.0 (90 건의 리뷰)
7.2
7.2
사용자 아바타
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일에
4.9 (225 건의 리뷰)
7.4
7.4
사용자 아바타
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 initiate the chat and discuss in detail. Waiting for ur kind response. Regards
$750 CAD 7일에
5.0 (23 건의 리뷰)
6.7
6.7
사용자 아바타
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, Web API Lets connect in chat so that We discuss further. Regards
$500 CAD 7일에
4.7 (203 건의 리뷰)
7.2
7.2
사용자 아바타
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 server or not. I have rich experience to integrate the 3rd party API service such as Algolia, Avalara, Bitrex, 123Loadboard which are based on Rest API, SOAP, WS etc. And skilled fully about the sanctum, jwt etc auth bearer token usage & interpret part. Hope to discuss about the project details on chat. Thanks.
$500 CAD 5일에
5.0 (15 건의 리뷰)
6.7
6.7
사용자 아바타
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일에
5.0 (238 건의 리뷰)
6.6
6.6
사용자 아바타
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. Thank you
$750 CAD 7일에
4.9 (101 건의 리뷰)
6.3
6.3
사용자 아바타
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일에
4.6 (46 건의 리뷰)
6.4
6.4
사용자 아바타
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 in a detailed way. Regards
$500 CAD 7일에
5.0 (12 건의 리뷰)
5.7
5.7
사용자 아바타
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일에
4.9 (119 건의 리뷰)
5.8
5.8
사용자 아바타
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. Hearing from you soon. David.
$750 CAD 5일에
4.9 (26 건의 리뷰)
6.0
6.0
사용자 아바타
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 Software Architecture. For 5 years I’ve worked in web development. I have a deep passion for research and guarantee that all of my result is 100% quality. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration.
$500 CAD 7일에
5.0 (5 건의 리뷰)
5.1
5.1
사용자 아바타
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-end development using PHP and MySQL. So it is a piece of cake for me. If you contact me, I can help you to finish your project well. I will wait for your response. Best regards.
$600 CAD 7일에
5.0 (3 건의 리뷰)
5.0
5.0
사용자 아바타
Hi , I can help you ! I am an expert web coder with skills including MERN STACK , php framework. I am free now so I can start working right now. I'll update you shortly... Please contact me to discuss more regarding this project. Feel free to contact me to discuss your project
$500 CAD 7일에
5.0 (3 건의 리뷰)
4.5
4.5

고객에 대한 정보

국기 (CANADA)
Winnipeg, Canada
5.0
10
결제 수단 확인
12월 11, 2011부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.