Devam Ediyor

Scripts That Call APIs to Populate a Database

We currently have a database, comprising of 24 tables, that has been populated by 1 script which calls 13 different, paginated APIs. The records within the database are all Football related scores, stats, fixtures, results etc.

The current script is set to populate the database with new records but not to replace existing records when they are updated. For example, they have a list of upcoming Football fixtures but when those fixtures are played, the scores and other stats aren't updated.

Since the original script was created, we have had a separate one created to call one of the APIs which would then update the existing records within the database. We have set this in the Cron of our database host to run every minute.

What we need from this project is:

1. To create 4 new, individual scripts that we can use to update the records in the existing database and to bring in a few more columns worth of stats.

2. Edits to the one that already updates the records, to call in a few more columns worth of stats.

3. Ensure the new and old scripts are working correctly and the database is populating with all available stats.

You should be able to re-use a lot of the scripts we've already had done to help and to speed the build up. All of the APIs are through [login to view URL] and the actual APIs themselves are:

[login to view URL]{??}&api_token=****&include=season,country

[login to view URL]{??}?api_token=****&include=stats,squad,sidelined

[login to view URL]{??}/team/{??}?api_token=****&include=player

[login to view URL]{??}?api_token=****&include=team,league

[login to view URL]?????/?page={??}&api_token=****&include=stats,substitutions,lineup,valuebet,probability

Beceriler: Veritabanı Geliştirme, MySQL, PHP, Veritabanı Programlama

Daha fazlasını gör: populate database csv, php populate database, populate database survey flash, store tweets in mysql database, google apps script rest api, postman + get data from database, loopback seed, database testing using postman, loopback seed data, how to get data from database using postman, postman check database, populate database real estate listings, populate database help, populate database xml, cron job read text file populate database, name address list populate database, find php form script populate database, populate database mysql, alfresco web scripts remote call servlet, call center access database

İşveren Hakkında:
( 5 değerlendirme ) Hull, United Kingdom

Proje NO: #21026070

Seçilen:

soumyanildas

Hello there! I have gone through your project details and have got a basic understanding of your requirements. I have also worked with SportMonks on a recent project (I can show it to you if you are interested via chat Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 110%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(37 Değerlendirme)
5.2

Bu iş için 24 freelancer ortalamada £169 teklif veriyor

phpdeveloper100

Expert in makiing API can do that Please open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-cart - X-Cart - Websi Daha Fazla

£286 GBP in 15 gün içinde
(76 Değerlendirme)
7.3
vcsahu16

Hi, I have gone through the details you have given and I am interested in the project.I am expert in API implementation . I have experience of over 9+ years in PHP + MYSQL related framesworks like Wordpress, Prestash Daha Fazla

£100 GBP in 4 gün içinde
(243 Değerlendirme)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. Here are my working result for php, mysql, api integration, ajax, jquery etc. [login to view URL] Daha Fazla

£150 GBP in 3 gün içinde
(111 Değerlendirme)
6.8
CakephpJobs1

HI I have best solution and exp in this area lets connect and discuss more about your requirement and get started for same thanks

£200 GBP in 7 gün içinde
(47 Değerlendirme)
6.9
karigor

Hi there, Since you already have a working API to fetch and update data, it will be easier to create 4 more scripts to do additional tasks like creating or updating specific database columns. Later you can use those Daha Fazla

£300 GBP in 10 gün içinde
(38 Değerlendirme)
6.6
kyleevert

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/kyleevert?w=f) I have much experience with your job. I t Daha Fazla

£135 GBP in 7 gün içinde
(20 Değerlendirme)
6.0
AndreiPPB

Hello. I read your requirement carefully. I'm very interested your project. I'm talented PHP, Html5, Javascript, CSS 3 developer. If you assign to me this project, you can get a cool result. please contact me. thanks. Daha Fazla

£135 GBP in 7 gün içinde
(19 Değerlendirme)
5.7
artiboria

Dear Sir, I have received your project description and please give me a chance to work on this project. I am highly interested to work on this project as it comes under my skill set. I will be very much comfortable to Daha Fazla

£150 GBP in 7 gün içinde
(66 Değerlendirme)
5.8
symaticssolution

Dear Client, I am ready to complete your existing website.I am applying only because I meet all the requirements that you are looking for.I have worked on several number of API like Facebook, Twitter, Yahoo, Google Ap Daha Fazla

£250 GBP in 7 gün içinde
(70 Değerlendirme)
6.9
ShrineWeb

Hi, I have done this before but I have a few questions, can we chat please? I have 10 years of experience in PHP.

£160 GBP in 7 gün içinde
(50 Değerlendirme)
5.6
freelancerdanie9

Hi I am database programmer I have 8 years experience as a web developer I mastered mysql query I can help you perfectly thanks Best regards.

£100 GBP in 7 gün içinde
(10 Değerlendirme)
5.4
dilshadabdal

Hello, I hope you're doing great !! I would like to express my interest & enthusiasm for the assignment posted by you. I am pretty much clear about the scope of work. I have excellent experience in Website Designing Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(27 Değerlendirme)
5.3
bluebear1888

Dear my employer! I have just read your description carefully. As an experienced developer, I am sure that I can handle your project perfectly. Even If you don't hire me, I can give you my opinion related to this job. Daha Fazla

£135 GBP in 7 gün içinde
(29 Değerlendirme)
5.3
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Daha Fazla

£250 GBP in 3 gün içinde
(10 Değerlendirme)
4.7
star314

Hi, I just reviewed your project description and interested in your project. My skills like is matched your project's requirement skills perfectly, so No problem to implement your project and sure you will get the sat Daha Fazla

£150 GBP in 5 gün içinde
(14 Değerlendirme)
4.7
mehroz1255

Hey i have expertise in API and its integration Message me i have read your description i am confident i can do this Come on Chat

£150 GBP in 5 gün içinde
(20 Değerlendirme)
4.8
nisthark

Hi Sir, My name is Nisthar. I am a software & web developer. I am experienced in this kind of scripting and automation projects. I have used almost all types of databases (mysql, mongodb, postgres, mariadb, rethinkdb, Daha Fazla

£250 GBP in 5 gün içinde
(15 Değerlendirme)
4.7
umg536

Hi there, please leave a message on my chat so we can discuss the budget and deadline of the project. I have read your project description and i'm confident i can do this project for you perfectly. Thanks . .

£250 GBP in 3 gün içinde
(3 Değerlendirme)
4.1
GlobalSolution3

Hello How are you. I have read your description carefully and check it. Very Interesting. I have many experiences in api. So I can finish your project quickly and perfectly. If you hire me, I will do my best. Thanks.

£135 GBP in 7 gün içinde
(8 Değerlendirme)
3.8
eden134

Very interesting project! I have already seen your project and I'm very much concerned to it I can fully satisfy you by deadline and quality. You will get it as just you want or more. I think we can discuss more on th Daha Fazla

£135 GBP in 3 gün içinde
(4 Değerlendirme)
3.8