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

Deliverables

Create SQL Tables with corresponding Normalised design for each endpoint

PHP API Call using SDK and Curl for non-supported end calls

Skills: SQL, Microsoft SQL Server

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 yahoo weather api using php, insert html sql server using vbnet, parse xml insert sql, can sure record duplicate sql database using php, 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, how to insert json data into sql server using python

About the Employer:
( 3 reviews ) Cordoba, Argentina

Project ID: #28282077

12 freelancers are bidding on average $475 for this job

nemanjadj20

Hello? I have worked on php, ajax, jquery with API(AWS, shopify, wordpress etc...) Integration, Admin template projects to what you are looking for, and I am confident I can exceed your expectations. I have attached More

$300 USD in 5 days
(11 Reviews)
5.2
(10 Reviews)
3.6
ShafirR

Hi ! When viewing your job details, it really jumped out at me. In my current Professional Microsoft SQL Server DBA role, I have extensive experience with Import Huge JSON Files data into SQL Database using T-SQL and J More

$500 USD in 3 days
(8 Reviews)
3.5
fadeevdoma

Hi, I am Ruslan and PHP API Curl expert, also good skills in DB management. So I can easily call your API using Curl and Get data from it, Using PDO to write data to your Mysql DB. I can do it in 2 days time I think. P More

$500 USD in 7 days
(3 Reviews)
3.3
kanwalrafique

Hi, I'm an experienced PHP developer. I have experience in integrating SOAP and REST APIs in PHP and I also have experience in using PDO for MS SQL. I can integrate the 4 Narnoo API endpoints as functions in PHP. I can More

$300 USD in 7 days
(7 Reviews)
3.0
(1 Review)
1.7
maliknadzim

Hello, there. Thanks for visiting my bid. I am a reliable and talented API expert you are looking for now. WIth more than 6 years of experience in web development using PHP, I have become a senior expert who can handle More

$500 USD in 7 days
(1 Review)
1.4
maxmatveev00

Dear Client, How are you? I am senior web developer as you finding now As you can see my profile, I have good expereince of PHP and api integration So i am sure i can make it as you want Please chat with me and discuss More

$500 USD in 7 days
(0 Reviews)
0.0
webbrains30

Hello, I am actively working with Php and its advanced MVC framework CodeIgniter & Laravel expert with JavaScript — jQuery & AJAX over 5+ years, I read your requirement of api develop with endpoints and design databa More

$550 USD in 10 days
(0 Reviews)
0.0
kuldeepak05

★★★★★★★ API EXPERT ★★★★★★★ Hello, >>your job post caught my attention . My skill set is required for the project I have extensive working experience in PHP. I have already worked with various API's like : Paypal API, More

$500 USD in 7 days
(0 Reviews)
0.0
gyzturriaga

Hi there, how are you? i can do your request, we need to talk a little more about them, but is sure i can do it, without nothing more to say, i hope listen about you soon, thanks a lot for your time, También hablo espa More

$500 USD in 20 days
(0 Reviews)
0.0
ABUNTYGOSWAMI

Hello, Hope you doing good. Let me introduce my self. my name is Bunty Goswami. I am from India. I have a Good experience in android developer Php Api creation and SQL Database management. I read your requirement. I f More

$550 USD in 3 days
(0 Reviews)
0.0