MySQL Procedure for JSON request generation and transmission


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

Skills: JSON, MySQL, PHP

See more: mysql procedure compare sync fields, iphone location http json request, itinerary mysql procedure, mysql trigger http request, jquery mysql example json, html css php mysql javascript json ajax access, mysql procedure parent child, mysql procedure loop table, classic asp calling mysql procedure, mysql procedure duplicate, iphone create json request, mysql frontend html report generation, mysql query json, php mysql query json, single sign mysql procedure, mysql import json, mysql insert json string, mysql procedure fix, feed mysql data json

About the Employer:
( 96 reviews ) huntley, Canada

Project ID: #20079598

58 freelancers are bidding on average $424 for this job


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
(727 Reviews)

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
(123 Reviews)

Hello, My name is Huapeng Li I am very interested in your project As you see my profile I am talented PHP, MySQL developer I think we can use Ajax for communication between frontend and backend I would love to hav More

$555 USD in 10 days
(53 Reviews)

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
(63 Reviews)

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
(86 Reviews)

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
(124 Reviews)

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
(52 Reviews)

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
(191 Reviews)

Hi, My name is Jin. Let's talk about your project. 1. You want to create a JSON dataset (invoice details) from your MySQL source. It will allow your web service API to process it and return the results which is then More

$480 USD in 7 days
(36 Reviews)

Hi. How are you? I have 8 years of experience in Wordpress,Shopify, Laravel, Magneto,etc. I have developed no of projects in Wordpress for different businesses After reading your job detail this looks like a perfec More

$250 USD in 10 days
(38 Reviews)

Hello, I have experience with MySQL and PHP. I can generate a JSON invoice which later submits and embeds into your Maria DB. Could we discuss further in chat? Thanks in advance.

$600 USD in 7 days
(220 Reviews)

Hello , Hope you are fine there. We have checked your Directory/Listing website project and the reason we came across here to give the best output to your project with supreme quality. We have developed a different kin More

$500 USD in 7 days
(69 Reviews)

Greetings sir, I have read your project details and i will develop a procedure for your mysql db. And yes first will complete the 1st step only. Then when you confirm the json and the web service we will continue wi More

$300 USD in 1 day
(120 Reviews)

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
(169 Reviews)

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
(87 Reviews)

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
(19 Reviews)

I am in Chicago, USA. I have worked with JSON, API, Web Services extensively and I would love to work on your project. I have more than 25 years of experience in web/software development and system administration. More

$625 USD in 10 days
(23 Reviews)

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
(37 Reviews)

Hello Client,[login to view URL] (check it) We are having 22 years of exp. of working as an IT experts & we are having one of the best team in India to design & develop software applications, web & mobile app , ERP / S More

$1500 USD in 10 days
(9 Reviews)

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
(86 Reviews)