Pratik Soni Pratik Soni - 7 months ago 12
SQL Question

particular single product's price, title and other detail fetch using flipkart api

I am using clusterdev.flipkart-api and from this api i got flipkart directory name and link then click on it i am getting directory's available products.
But i need to fetch particular product's price, title, inStock details from this api. i had try to make some changes but i don't have more knowledge in json so i am not able to get details.
After getting particular product's price, title, inStock details then i need to update it into the my database.

Flipkart Api FAQ Link: http://www.flipkart.com/affiliate/apifaq

Please suggest me what changes i need to make to get product's price, title, instock and other details.

Actual Code: https://github.com/xaneem/flipkart-api-php
Included File: https://github.com/xaneem/flipkart-api-php/blob/master/clusterdev.flipkart-api.php

Code here

<?php

//Include the class.
include "clusterdev.flipkart-api.php";

//Replace <affiliate-id> and <access-token> with the correct values
$flipkart = new \clusterdev\Flipkart("pratikson3", "853d3bc027514b3aa33f1caa4f30f1cf", "json");


//To view category pages, API URL is passed as query string.
$url = isset($_GET['url'])?$_GET['url']:false;
if($url){
//URL is base64 encoded to prevent errors in some server setups.
$url = base64_decode($url);

//This parameter lets users allow out-of-stock items to be displayed.
$hidden = isset($_GET['hidden'])?false:true;

//Call the API using the URL.
$details = $flipkart->call_url($url);

if(!$details){
echo 'Error: Could not retrieve products list.';
exit();
}

//The response is expected to be JSON. Decode it into associative arrays.
$details = json_decode($details, TRUE);

//The response is expected to contain these values.
$nextUrl = $details['nextUrl'];
$validTill = $details['validTill'];
$products = $details['productInfoList'];

//Products table
echo "<table border=2 cellpadding=10 cellspacing=1 style='text-align:center'>";
$count = 0;
$end = 1;

//Make sure there are products in the list.
if(count($products) > 0){
foreach ($products as $product) {

//Hide out-of-stock items unless requested.
$inStock = $product['productBaseInfo']['productAttributes']['inStock'];
if(!$inStock && $hidden)
continue;

//Keep count.
$count++;

//The API returns these values nested inside the array.
//Only image, price, url and title are used in this demo
$productId = $product['productBaseInfo']['productIdentifier']['productId'];
$title = $product['productBaseInfo']['productAttributes']['title'];
$productDescription = $product['productBaseInfo']['productAttributes']['productDescription'];

//We take the 200x200 image, there are other sizes too.
$productImage = array_key_exists('200x200', $product['productBaseInfo']['productAttributes']['imageUrls'])?$product['productBaseInfo']['productAttributes']['imageUrls']['200x200']:'';
$sellingPrice = $product['productBaseInfo']['productAttributes']['sellingPrice']['amount'];
$productUrl = $product['productBaseInfo']['productAttributes']['productUrl'];
$productBrand = $product['productBaseInfo']['productAttributes']['productBrand'];
$color = $product['productBaseInfo']['productAttributes']['color'];
$productUrl = $product['productBaseInfo']['productAttributes']['productUrl'];

//Setting up the table rows/columns for a 3x3 view.
$end = 0;
if($count%3==1)
echo '<tr><td>';
else if($count%3==2)
echo '</td><td>';
else{
echo '</td><td>';
$end =1;
}

echo '<a target="_blank" href="'.$productUrl.'"><img src="'.$productImage.'"/><br>'.$title."</a><br>Rs. ".$sellingPrice;

if($end)
echo '</td></tr>';

}
}

//A message if no products are printed.
if($count==0){
echo '<tr><td>The retrieved products are not in stock. Try the Next button or another category.</td><tr>';
}

//A hack to make sure the tags are closed.
if($end!=1)
echo '</td></tr>';

echo '</table>';

//Next URL link at the bottom.
echo '<h2><a href="?url='.base64_encode($nextUrl).'">NEXT >></a></h2>';

//That's all we need for the category view.
exit();
}



//Category Selection Page
//If the control reaches here, the API directory view is shown.

//Query the API
$home = $flipkart->api_home();

//Make sure there is a response.
if($home==false){
echo 'Error: Could not retrieve API homepage';
exit();
}

//Convert into associative arrays.
$home = json_decode($home, TRUE);

$list = $home['apiGroups']['affiliate']['apiListings'];

//Create the tabulated view for different categories.
echo '<table border=2 style="text-align:center;">';
$count = 0;
$end = 1;
foreach ($list as $key => $data) {
$count++;
$end = 0;

//To build a 3x3 table.
if($count%3==1)
echo '<tr><td>';
else if($count%3==2)
echo '</td><td>';
else{
echo '</td><td>';
$end =1;
}

echo "<strong>".$key."</strong>";
echo "<br>";
//URL is base64 encoded when sent in query string.
echo '<a href="?url='.base64_encode($data['availableVariants']['v0.1.0']['get']).'">View Products &raquo;</a>';
}

if($end!=1)
echo '</td></tr>';
echo '</table>';

//This was just a rough example created in limited time.
//Good luck with the API.

Answer
<?php

    //Include the class.

    include "clusterdev.flipkart-api.php";

    //Replace <affiliate-id> and <access-token> with the correct values

    $flipkart = new \clusterdev\Flipkart("pratikson3", "853d3bc027514b3aa33f1caa4f30f1cf", "json");

    $pid = "Flipkart Product ID";

    $url = 'https://affiliate-api.flipkart.net/affiliate/product/json?id=' .$pid;

    //Call the API using the URL.

    $details = $flipkart->call_url($url);

    if(!$details){

        echo 'Error: Could not retrieve products list.';

        exit();
    }

    //The response is expected to be JSON. Decode it into associative arrays.

    $details = json_decode($details, TRUE);

    $price = $details['productBaseInfo']['productAttributes']['sellingPrice']['amount'];

    $inStock = (int) $details['productBaseInfo']['productAttributes']['inStock'];

    $title = $details['productBaseInfo']['productAttributes']['title'];

    $description = $details['productBaseInfo']['productAttributes']['productDescription'];
Comments