python or php script to take data from api and put it to database

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

Hello,

i need a python script in order to take data from a api service and put it to mysql.

the api return the attached output.

In the sample output you can see 3 records:

items[0] items[1] items[2].

The api can provide more records.

The script must first check if "StartTime" already exist in the database. If yes then they ignore this record.

If "StartTime=" not exist in the database then they add in a table a record with the following data:

StartTime

EndTime

Events[0]

Events[1]

Filename (they must remove the /mnt/sd from the file name)

CutLength

Duration

Flags[0]

Length

Type

Also the script download in the selected folder the file (i provide the api command so with the value in "Filepath" you can download it)

I provide all api commands, so you not need to learn the api, i just want to push to mysql the api results.

Als othe script need to be ready today so the developer need to work now

Python MySQL PHP

Project ID: #29931724

About the project

14 proposals Remote project Active 2 years ago

Awarded to:

AlisaJeff

Hi, There is not enough information for me to provide a proper budget, but send me a chat to discuss. I can start work immediately. I have just read your project in detail and your project is very wonderful. I have ri More

$25 USD in 1 day
(20 Reviews)
5.5

14 freelancers are bidding on average $30 for this job

satyajeetkeshari

Hello Dear Client, I can write the required PHP script that will get data from api and put it into the MySQL records. I have done this sort of work before also .I can start working right now. Thanks! Satyajeet

$10 USD in 1 day
(124 Reviews)
5.5
abubakar12345678

I will do this task in PHP to get api result to mysql. Give me chance. I will show you good result. Thanks

$30 USD in 1 day
(51 Reviews)
4.9
hiberokpars

Hi I can do php script for you I have great expirience in php API scripts and mysql import. You can find link to 500+ my feedbacks on my profile page.

$80 USD in 1 day
(11 Reviews)
4.4
Zubayerskd

Hello, I am a python developer. I have worked with both mysql and api several times. I can connect your db with python and add data collected from the api. Let's have a quick discussion and start this project. Thanks, More

$25 USD in 1 day
(38 Reviews)
4.2
alokkeshri

Hi, I can get the work done in a day. I got your requirements and I can do the work. You want the api results to be inserted in mysql database. If starttime already exist skip that data. I will need the format in whi More

$50 USD in 7 days
(11 Reviews)
3.9
MahmoudHegazi

Hello Sir, I'm Mahmoud Hegazy Full Stack Web Developer, With PHP and Python Skills, I can do this task for $20 in one day pay and award after I finish thank you.

$20 USD in 1 day
(9 Reviews)
2.8
WordsAlchemy

Hello there, I have read the details, and I am confident that I'm the person you want on this. I have a couple of questions though if you can spare a few minutes. That will help me ensure that the content hits home. More

$20 USD in 3 days
(2 Reviews)
2.6
RAZIULCSE

Hi, I could be the perfect guy for the job. I can easily understand that you want a script that will insert only the unique item's partial data from the API result to the database. We can have conversation about the More

$30 USD in 1 day
(1 Review)
1.0
Priyasinghjbp

Hi , I want to work further on your Python Script Development requirement. I have excellent Developers with 8+ Year experience to take care of your work. Please accept my request to discuss further. Thanks,

$30 USD in 10 days
(0 Reviews)
0.0
bohdansmoliar

Hi, I am a full-savvy programmer at python, so I can complete your project very quickly, ensuring the highest quality. I have ever been done something similar before. Hope we can discuss this in detail via chat. Will More

$30 USD in 1 day
(0 Reviews)
0.0
brunodaemon

Hello Greece I've been working with data extraction for more than 10yrs. Surely can help you get the data you need from the API to your database pretty quickly. I'm looking forward to hear back from you soon. Best re More

$19 USD in 1 day
(0 Reviews)
0.0