Call API, Parse JSON and insert into SQL PDO using PHP
Bajet $750-1500 USD
- Freelancer
- Kerja
- PHP
- 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
33 pekerja bebas membida secara purata $1245 untuk pekerjaan ini
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 Lagi
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.
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 Lagi
Hi. I have written many automation API projects. Ready to write your project. Will complete within 16 days
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 Lagi
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 Lagi