MySQL Procedure for JSON request generation and transmission

Pågående Publicerat 4 år sedan Betalades vid leverans
Pågående Betalades vid leverans

*** 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

Projekt-id: #20079598

About the project

40 offerter Distansprojekt Aktivt 4 år sedan

40 frilansare har lagt bud på i genomsnitt $424 för det här jobbet

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 Mer

$675 USD inom 5 dagar
(763 omdömen)
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 Mer

$715 USD inom 22 dagar
(138 omdömen)
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 Mer

$300 USD inom 10 dagar
(81 omdömen)
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 Mer

$500 USD inom 10 dagar
(129 omdömen)
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 Mer

$500 USD inom 7 dagar
(92 omdömen)
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 Mer

$250 USD inom 1 dag
(206 omdömen)
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 Mer

$300 USD inom 2 dagar
(54 omdömen)
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 inom 17 dagar
(181 omdömen)
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 Mer

$320 USD inom 2 dagar
(136 omdömen)
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 Mer

$500 USD inom 10 dagar
(42 omdömen)
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 Mer

$500 USD inom 25 dagar
(20 omdömen)
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 Mer

$250 USD inom 2 dagar
(44 omdömen)
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 inom 5 dagar
(89 omdömen)
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 Mer

$500 USD inom 7 dagar
(48 omdömen)
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 inom 3 dagar
(55 omdömen)
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 Mer

$555 USD inom 10 dagar
(18 omdömen)
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 Mer

$350 USD inom 7 dagar
(26 omdömen)
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 inom 2 dagar
(7 omdömen)
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 inom 7 dagar
(61 omdömen)
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 Mer

$350 USD inom 7 dagar
(18 omdömen)
5.3