Suljettu

Call API, Parse JSON and insert into SQL PDO using PHP

I require SQL table created, API Call and PHP to parse the following JSON call from an API.

Details on the API can be found & [login to view URL]

Incomplete SDK found here [login to view URL], which is missing 4 important endpoints.

Get Product Availability and Pricing Details

Get Multiple Product Availability and Pricing Details

Get bookings list

Get bookings details

Requirements

•PHP – Preferably without frameworks and not OOP, but procedural. However happy to use the SDK and add the other endpoint as a sperate PHP files to solve that issue

• Want each endpoint being a function (Procedural) call with parameters to be passed to each function/Corresponding endpoint

• Database is MSSQL, so using PDO

• For each call/endpoint the following is required

o Database Table design, normalized to account for the nest Json Data

o Database Name to starts with tblNarnoo_{method)_{Add_Child_Nested]. Ie tblNarnoo_Bookable_Prouct (Parent) and tblNarnoo_Bookable_Prouct_Description (Child – Nested Json) and tblNarnoo_Bookable_Prouct_Booking_Code

o Parse the json in PHP

o Inserting Json response into the corresponding table

o Prevent Duplicate insert on endpoint unless specified below

o For Media add a download function to save files on the server

Taidot: PHP, MySQL, XML, Tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: read xml file using net insert sql server, import sql dump using php, insert xml database sql server using vbnet, insert sql server using vbnet, insert data sql server using visual basic net, parse xml insert sql, can sure record duplicate sql database using php, using php receive posted data, sql pdf using php, sql quiz using php, upload image sql database using php, python json insert sql, json insert sql, parse json in sql server 2008 r2, parse json in sql server 2014, how to insert json data into sql server using c#, angularjs insert update delete using php mysql, using jquery ajax and php to fetch data from a mysql database -table, how to insert json data into sql server using python

Tietoa työnantajasta:
( 0 arvostelua ) Santa Clara, United States

Projektin tunnus: #28282068

33 freelanceria on tarjonnut keskimäärin $1245 tähän työhön

(233 arvostelua)
9.3
(113 arvostelua)
9.2
(1193 arvostelua)
9.1
(216 arvostelua)
9.0
(298 arvostelua)
8.6
fleetways

Thank you for looking at our bid. If I understand correctly, the requirement is to complete the narnoo-php-sdk with missing API calls. However, not sure why a database is required as the narnoo seems to be already o Lisää

$1670 USD 45 päivässä
(96 arvostelua)
8.2
(196 arvostelua)
8.5
(123 arvostelua)
8.6
(148 arvostelua)
8.2
(114 arvostelua)
8.0
(69 arvostelua)
8.0
phpdeveloper100

Expert in making API calls , Done multiple APIs and can do that as well , Please note we have done many APIs including Google , Payments , Affiliates and other and can do that as well , Know core PHP and PDO in detaile Lisää

$1286 USD 35 päivässä
(81 arvostelua)
7.4
DebasisB

Hello there, I am interested in the project. I have expertise in API integration and I am sure Ic an provide you the exact solution you re looking for. Thank You.

$1000 USD 7 päivässä
(185 arvostelua)
7.2
(169 arvostelua)
7.0
(126 arvostelua)
6.0
krishnauniyal29

Hello Hope you are doing well I am ready to parse Json response and save into Database tables as you mentioned in the project detail, I am experienced in Parsing Json and convert into php script and save into Datab Lisää

$750 USD 25 päivässä
(66 arvostelua)
6.1
webdroid

Hello James T. We went through your project description and it seems like our team is a great fit for this job. Please have a look at our portfolio to get the idea of our skills. You can check our portfolio on Lisää

$1100 USD 7 päivässä
(32 arvostelua)
5.8
writingapp

Hi. I have written many automation API projects. Ready to write your project. Will complete within 16 days

$1650 USD 16 päivässä
(59 arvostelua)
5.5
kripanidhi

I will do all your following requirements - •PHP – Preferably without frameworks and not OOP, but procedural. However happy to use the SDK and add the other endpoint as a sperate PHP files to solve that issue • Want Lisää

$799 USD 3 päivässä
(55 arvostelua)
5.8
contactsapphire

Call API, Parse JSON and insert into SQL PDO using PHP Get 8+ year experienced PHP developer who is proficient in WordPress, MySQL, Bootstrap, JavaScript, HTML, jQuery, Graphic design, Angular, etc. Hi, Greetings of S Lisää

$1500 USD 20 päivässä
(6 arvostelua)
6.0