Pass JSON API data to my database then send out as an email
£20-250 GBP
Pagado a la entrega
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.
Nº del proyecto: #13849913
Sobre el proyecto
Adjudicado a:
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 Más
26 freelancers están ofertando un promedio de £210 por este trabajo
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 Más
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 Más
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 Más
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 Más
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 Más
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 Más
Hello There, I think I can help you out with this task Let's discuss the solution over pm. Thanks,
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 Más
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 Más
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 Más
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 Más
