MySQL Procedure for JSON request generation and transmission

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

*** PLEASE NO AUTO-BIDS. PLEASE CONFIRM THAT YOU HAVE READ THE DETAILS AND FULLY UNDERSTAND THE REQUIREMENTS ***

We need a MySQL procedure that will:

1. Generate a single JSON from a query (The JSON will include details for the creation of an invoice including some header and detail values for the order and lines)

2. Submit the JSON request to a web service

3. Receive back the result from the submission and write that result to a MySQL table

We will need the first step done before the other two can be completed, since the JSON schema will be needed to complete the web service. Once step one is completed, we will finalize the web service and then continue with items 2 and 3.

We also need a way to run this procedure on a schedule on a Windows server (running XAMPP).

We are using the following versions:

MySQL (MariaDB): 10.4

PHP: 7.1.12

JSON MySQL PHP

Project ID: #20079598

About the project

40 proposals Remote project Active 4 years ago

40 freelancers are bidding on average $424 for this job

Yknox

Dear,I am Jin_S ... I'm interested in the project you recently posted. I'm a certificated freelancer with over 1000 good reviews from clients. I have experienced knowledge in every part of web development. I never disa More

$675 USD in 5 days
(763 Reviews)
9.2
ominfowave

Dear Client, We have read and fully understand your requirement. We always look to work on your goals seriously and gives you unbelievable results. Our freelancer portfolio speaks all about this. Let's discuss this p More

$715 USD in 22 days
(138 Reviews)
7.8
idragon712

Hello Dear. Here is a full stack web developer with 6 years of experiences. I have carefully read the description of the project and I think your project is really fit with my skillsets. I am a senior web developer More

$300 USD in 10 days
(81 Reviews)
7.6
KashirinA

How are you? I have read your description carefully. Very Interesting. Your project is proper to me. I have many experiences in php and mysql. So I can finish your project perfectly. If you hire me, I will do my More

$500 USD in 10 days
(129 Reviews)
7.4
widadsaghir1993

Dear client MariaDB, Xampp, PHP, JSON, Database are all what I have rich experienced in before Reading your job with care, I can complete your job step by step. Let's get started from the first step. I will go on worki More

$500 USD in 7 days
(92 Reviews)
7.4
brianconey

Hello How are you I checked your description and i can handle php json and and sql ie i will convert sql array into json and i will complete json logic as your reqruiement i have full time and I can start to work im More

$250 USD in 1 day
(206 Reviews)
7.1
anatolygenay123

Hi. How are you today? If the Japanese are able for your project, your project is a very good challenge for me. I am a senior Web developer. You can confirm my past project on my profile. And i will work for your j More

$300 USD in 2 days
(54 Reviews)
6.9
techwelfare

This is not a autobid...... Just give us the chance to prove ourselves....... We have some questions to clarify,please reply us so we could discuss the project in details. Thanks & Regards Moumita

$692 USD in 17 days
(181 Reviews)
7.2
PhpWebD

Hello, I've read the project details and I'm able to generate the JSON from the MYSQL query in the required format, then send it to webserver and then store the response to mysql. I'll also assist you with adding a c More

$320 USD in 2 days
(136 Reviews)
6.7
ZhangXH

Hi. I have read your requirement carefully and very interested it. I'm glad to have a chance for bidding to your project. I am a expert server programmer. I have rich experiences in PHP and node js with MySQL, Mari More

$500 USD in 10 days
(42 Reviews)
6.2
JinTaiZhe

Hello. I read your job post carefully and ready for all your requirements. In response to your search for help, I believe my experience in this field and my variety of skills qualify me for consideration. If you woul More

$500 USD in 25 days
(20 Reviews)
6.1
kanwalrafique

Hi, I can implement all the three steps you've listed. For completing the first step I'd like to know what data is required by the web service in the JSON and how do I properly structure that data. Kindly share the det More

$250 USD in 2 days
(44 Reviews)
6.1
kypergio

Hi I have worked with JSON format from PHP script, and windows' task scheduler and Cron Jobs on Linux. I know perfectly what you need. I have worked with MySQL as well for sure. Regards

$300 USD in 5 days
(89 Reviews)
6.2
ludwig333

Hello ! I am a full stack developer for over 5 years on the freelancer.com. I have read your description in more detail and have much interest in your project. I have many experiences what I have ever done before sim More

$500 USD in 7 days
(48 Reviews)
6.1
rodweb

Hi, I just read your offer and I think to be able to coding that requirement.I have good experience . Thanks

$250 USD in 3 days
(55 Reviews)
5.8
TakaAlex

hello I have read your specification in detail and I am very interested. I have full skill for your project and you can check my profile https://www.freelancer.com/u/TakaAlex I will make sure u get a perfect resul More

$555 USD in 10 days
(18 Reviews)
5.6
lordzephirot

Hi, I have read your job description carefully and i am very interested in this job. So do you want to do like thess? - Generating a Json from sql result - Request Json - Receive the result and store on database I c More

$350 USD in 7 days
(26 Reviews)
5.5
stevearm

Hello. PHP, MySQL, JSON... my cup of tea. 390$ in 2 days I can have all 3 steps ready. Clean, job, bug-free. Thanks and looking forward.

$390 USD in 2 days
(7 Reviews)
5.6
xinglong717

I'm fullstack web developer. I have many experiences in php, mysql, json. I can complete your project successfully. Thanks

$500 USD in 7 days
(61 Reviews)
5.6
jgamio

Hi The requirement is missing something. Do you want do these with a php script ? or create a windows service to the read the database 1- Using php is cheap. we just create a php script just need just we need defi More

$350 USD in 7 days
(18 Reviews)
5.3