Closed

Pull data via API and insert in MySQL

URGENT TODAY. needed to have this yesterday as a freelancer failed. SO IN NEXT HOURS.

I have API looking like this ...http://x.x.x.x/api/v1/telegramChannels/TGID/telegram_messages?api_key=xxxxxxxxxx&created_at_from=timestamp&sort_by=tg_created_at&sort_dir=desc&message_type=Message

Output look like in the attached file.

In short I want pull data threw the API and put into MySQL for x number of channels/groups.

This script will do api call every x ex 30s from cron or triggered via mysql.

* I also want make sure no row is to long .... so have a parameter say max 10K

Where the number of channels/groups coming from table below.

* I want a cleaning tool that run every 24/hour that remove older message.

Want a table that looks like this.

Second a table that look like this.

German, IBM Deutsche, IBM Germany / IBM德国, 10033344444,"/[login to view URL]"

channel/group original language. original English, Chinese, TG ID, flag

(path to flag icon).

This table will be used to list the groups to be pulled and inserted.

Skills: PHP, Software Architecture, HTML5, API, MySQL

See more: script pull data internet explorer, pull data sites display, real time forex data api, data api pull videos youtube playlist, free php code pull data mysql, auto data txt insert php mysql, fast pull data mysql php, php mysql import max data, pull data mysql iphone app, import data api mysql, php call api insert mysql, pull data zillow api, using api pull data, using api pull data soap, googel maps api pull data sql table, pull csv data api, pull data amazon api, create mysql data api amazon web

About the Employer:
( 0 reviews ) veberod, Sweden

Project ID: #21435563

18 freelancers are bidding on average $75 for this job

gangabass

I can provide you a PHP script that will work exactly like you want (saving API output into MySQL). I can complete it in 3-4 hours for just $80.

$80 USD in 1 day
(462 Reviews)
7.5
glennwilkins

sir message me i can finish this fast ... sir message me i can finish this fast ... sir message me i can finish this fast ...

$50 USD in 1 day
(191 Reviews)
6.3
NadirBouchama

Hello there! how are you doing? Can you please provide more details about the project? if the project is fairly paid I can build you a small part of it as form of a demo, afterwards you'll decide if you should hire me More

$50 USD in 2 days
(67 Reviews)
6.4
jafarali14

Hi Sir/Madam, Thank you for going through my proposal for your Job titled I have gone through your job posting. I am an Expert PHP Developer with extensive experience of developing web and mobile applications. i am ful More

$35 USD in 7 days
(151 Reviews)
6.5
romansokolv708

Dear Client! I have worked professionally last 9+ years as freelancer. I have strong skills in javascript, PHP, React.js, Angular, Vue, Laravel, Node.js, Python, MySQL, MongoDB. I just read your project detail carefull More

$50 USD in 1 day
(43 Reviews)
6.2
sherazm

I can do this task. i have worked on many projects like this. ping me for more details and also check out my reviews. thanks

$166 USD in 1 day
(64 Reviews)
6.3
pakistansolution

Hello, I read your description and I'll do your work faster and professionally with in your time frame. Have a look at the websites that I built recently. [login to view URL] [login to view URL] http More

$400 USD in 5 days
(81 Reviews)
6.3
psubramonian

My Skillsets: ======== > Frameworks: Laravel, Code-igniter, ionic > Web Applications using PHP + MySQLi + API+jQuery > Restful Web services: REST, SOAP > Payment Gateway: Ccavenue, EBS, Paypal, NetBanking > Design Pat More

$50 USD in 1 day
(100 Reviews)
6.3
javedaasim

Hi There, I'm Jason, an Website developer by profession and have been proved myself as a Competitive and Promising Freelancer in a short span of time (check my company website). I'm merging my technical and managerial More

$30 USD in 7 days
(49 Reviews)
6.4
vuetech8

Hi I can finish it by one day and that i hope will be done by some hour but i am taking 1 day for it. You said that cron job will run every 30s is it possiable because if there will be more data then it will be take More

$100 USD in 1 day
(66 Reviews)
6.2
tutulsoft

--- API PUSH/PULL EXPERT ---- interested to your work ------------------ can connect now for your URGENT .................................

$50 USD in 7 days
(21 Reviews)
5.3
amitbanerjee2812

Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Here is few recent work for website development : crm.n More

$30 USD in 7 days
(30 Reviews)
5.5
ouarkaayoub

HI, I would like to have work on this interested project, some attached files are missed, Please send me a message so that we can discuss more details, Thanks and enjoy;

$50 USD in 7 days
(42 Reviews)
4.7
viapromote

HI I AM A HIGH SKILLED WEB(FULL STACK) DEVELOPER AND SEO EXPERT. I CAN IMMEDIATELY START TO WORK ON YOUR PROJECT. I HAVE ALSO WORKED ON MANY APIS, ESPECIALLY EMAIL MARKETING LIKE ZOHO, MAILCHIMP, SALESFORCE ETC. THI More

$30 USD in 1 day
(11 Reviews)
4.2
shobha1987

Hi, I can get this done in 2-3 hours. I have already worked on extracting telegram messages via APIs and also via chrome extension so I can make it work as per your requirements. Let me know if you have any questions. More

$40 USD in 1 day
(19 Reviews)
3.9
prashant2621

Hello Sir/Mam, APComp is one of the best providers of software development and other professional IT services. We have over 5 years in the software development field and a long list of satisfied customers. We know tha More

$50 USD in 7 days
(23 Reviews)
3.9
nkrfreelancer

Hi My name is Nareshjangir. We are group of High IQ individuals who loves to solve problems while working full time as part of our organizations. I have strong knowledge and understanding of database management rel More

$50 USD in 3 days
(0 Reviews)
0.0
denisbelyaev1977

I have a lot of experience in solving problems similar to this. I always do my job fast and qualitatively.

$30 USD in 2 days
(0 Reviews)
0.0