Pass JSON API data to my database then send out as an email

Færdiggjort Opslået 7 år siden Betalt ved levering
Færdiggjort Betalt ved levering

I have a database that I created in MySQL. It has a CLIENT table which has client info and also includes a client reference row.

The live web chat service I use has an API which can send a string of data to a URL on my site. This data needs to be extracted into the appropriate fields in my database.

It will have another table with the relevant rows for the data which is to be passed from the JSON POST API.

It will then needs to identify the client that information belongs to by matching the client ref with the reference field from the JSON API data and then send an email to that client from my CLIENT table email address automatically with specific information from that string of data.

For example a client may have an ID A0001. When a chat is complete, it will send data to my database. It will save the data with widget ID A0001, then it will save that data, match Widget ID and client ref and send an email to that client.

Security is very important. I need it to be made so that data cannot be passed by any other third party to my url and then enter the database.

There will be two different email types that go out. One that is a transcript of the live chat and one that is a message left by the client. The message type is contained within the data passed to my database.

I have a link to the Event API details.

I will also need you to check the database structure is suitable and amend if required. It should be okay. rows have been indexed to each other already.

My database is hosted on a VPS.

HTML JSON MySQL PHP

Projekt ID: #13849913

Om projektet

26 bud Remote projekt Aktiv 7 år siden

Tildelt til:

Nawaz091993

Bid Summary Greetings! I have understood the requirements of the project and will elaborate my understanding below: Project Requirements As you outlined that api uses a callback url where it posts json data so it Flere

£130 GBP in 3 dage
(150 bedømmelser)
7.0

26 freelancere byder i gennemsnit £210 timen for dette job

Fahomid

Bid Summary Hi, I've been working in similar project for more than 4 years now. Please let me know if you are interested. I can start working right now. Project Requirements I have been working in JSON and XML base Flere

£250 GBP in 7 dage
(89 bedømmelser)
8.4
mituld

Bid Summary Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks Project Requirements you need Flere

£237 GBP in 10 dage
(482 bedømmelser)
8.3
latatestTech

Bid Summary we will encrypt the data to make secure Project Requirements you need to configure the api with secure Relevant Skills and Experience mysql, php with json and api Proposed Milestones £150 GBP - initial Flere

£150 GBP in 4 dage
(232 bedømmelser)
8.4
marchingantssl

Bid Summary Can we have a call for this? Project Requirements Fetching Data from API and save it Relevant Skills and Experience PHP Proposed Milestones £210 GBP - Project Milestone How will you make this secure? We Flere

£210 GBP in 5 dage
(251 bedømmelser)
8.0
prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Flere

£257 GBP in 10 dage
(64 bedømmelser)
7.2
royalwebraisers

Bid Summary JSON data to email Project Requirements JSON data to email Relevant Skills and Experience JSON data to email Proposed Milestones £150 GBP - JSON data to email How will you make this secure? JSON data to Flere

£150 GBP in 3 dage
(172 bedømmelser)
6.8
Sonicoders

Bid Summary I have extensive experience in different API,I can provide you the solution quickly,we can talk more over chat. Project Requirements Actually you want to save data into your database that is retrieved usin Flere

£111 GBP in 3 dage
(171 bedømmelser)
6.6
shijudasan

Bid Summary hi I am a php full stack developer . I think I have understood your requirement clearly. I can finish the mentioned tasks upto sending email in 4 days max. For security, we can use some auth codes . Proj Flere

£222 GBP in 4 dage
(39 bedømmelser)
6.3
luminous15

Hello There, I think I can help you out with this task Let's discuss the solution over pm. Thanks,

£95 GBP in 5 dage
(61 bedømmelser)
6.2
optimusworker

Bid Summary My Name is Rohit and I am an expert UI / UX developer. I work in many platforms i.e PHP, Wordpress, HTML / CSS. And i am a good freelancer for you to start because of my freelancing ratings. Project Requir Flere

£250 GBP in 3 dage
(38 bedømmelser)
5.1
CBabbage

Bid Summary You can see quite a bit of JSON work in my previous projects and I am one of a few on here that has the Level 3 MySQL exam completed. You can be sure of hiring someone with the required knowledge. Project Flere

£350 GBP in 5 dage
(48 bedømmelser)
5.2
lytrungtin

Hello, I have many years experience in website development and good at Php, api, web scraping, wordpress, mvc framework. I have read your requirement and understand clearly, hope to receiving your respond and have an Flere

£233 GBP in 5 dage
(16 bedømmelser)
4.9
MuhammadRohailP

Bid Summary I am an expert web developer and can perfectly carry out this task for you in quickest time. I will transfer data to db and then email it according to requirements. I ensure work will be perfect. Project R Flere

£150 GBP in 3 dage
(15 bedømmelser)
4.8
AlexanderBulei

A proposal has not yet been provided

£111 GBP in 2 dage
(30 bedømmelser)
4.9
smbusinessforce

Bid Summary For this project, for make a system more secured, is necessary use only server-side scripts, for example Python or PHP. Project Requirements You need a system that automatically send to your customers a em Flere

£199 GBP in 4 dage
(6 bedømmelser)
4.0
w3itsys

Bid Summary you need to save your clients chat details in your db and also want send mail. and for above you manage this by json data. Project Requirements it can be done by ajax handling. Relevant Skills and Experie Flere

£55 GBP in 2 dage
(1 bedømmelse)
1.3