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

Kemahiran: JSON, MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 96 ulasan ) huntley, Canada

ID Projek: #20079598

58 pekerja bebas membida secara purata $424 untuk pekerjaan ini


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 Lagi

$675 USD dalam 5 hari
(727 Ulasan)

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 Lagi

$715 USD dalam 22 hari
(123 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(53 Ulasan)

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 Lagi

$300 USD dalam 10 hari
(63 Ulasan)

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 Lagi

$500 USD dalam 7 hari
(86 Ulasan)

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 Lagi

$500 USD dalam 10 hari
(124 Ulasan)

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 Lagi

$300 USD dalam 2 hari
(52 Ulasan)

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 Lagi

$250 USD dalam sehari
(191 Ulasan)

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 Lagi

$480 USD dalam 7 hari
(36 Ulasan)

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 Lagi

$250 USD dalam 10 hari
(38 Ulasan)

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 dalam 7 hari
(220 Ulasan)

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 Lagi

$500 USD dalam 7 hari
(69 Ulasan)

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 Lagi

$300 USD dalam sehari
(120 Ulasan)

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 dalam 17 hari
(169 Ulasan)

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 dalam 5 hari
(87 Ulasan)

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 Lagi

$500 USD dalam 25 hari
(19 Ulasan)

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. Lagi

$625 USD dalam 10 hari
(23 Ulasan)

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 Lagi

$500 USD dalam 10 hari
(37 Ulasan)

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 Lagi

$1500 USD dalam 10 hari
(9 Ulasan)

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 Lagi

$320 USD dalam 2 hari
(86 Ulasan)