Fermé

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

Compétences : PHP, MySQL, XML, Architecture Logicielle, SQL

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Santa Clara, United States

Nº du projet : #28282068

33 freelances font une offre moyenne de 1245 $ pour ce travail

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(96 Commentaires)
8.2
(196 Commentaires)
8.5
(123 Commentaires)
8.6
(148 Commentaires)
8.2
(114 Commentaires)
8.0
(69 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 35 jours
(81 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(185 Commentaires)
7.2
(169 Commentaires)
7.0
(126 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(66 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(32 Commentaires)
5.8
writingapp

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 16 jours
(59 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(55 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(6 Commentaires)
6.0