Closed

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

Skills: PHP, MySQL, XML, Software Architecture, SQL

See more: 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

About the Employer:
( 0 reviews ) Santa Clara, United States

Project ID: #28282068

33 freelancers are bidding on average $1245 for this job

(233 Reviews)
9.3
(113 Reviews)
9.2
(1193 Reviews)
9.1
(216 Reviews)
9.0
(298 Reviews)
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 More

$1670 USD in 45 days
(96 Reviews)
8.2
(196 Reviews)
8.5
(123 Reviews)
8.6
(148 Reviews)
8.2
(114 Reviews)
8.0
(69 Reviews)
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 More

$1286 USD in 35 days
(81 Reviews)
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 in 7 days
(185 Reviews)
7.2
(169 Reviews)
7.0
(126 Reviews)
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 More

$750 USD in 25 days
(66 Reviews)
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 More

$1100 USD in 7 days
(32 Reviews)
5.8
writingapp

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

$1650 USD in 16 days
(59 Reviews)
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 More

$799 USD in 3 days
(55 Reviews)
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 More

$1500 USD in 20 days
(6 Reviews)
6.0