This is the code in php which might be helpful to you, to fetch the records in pagination using the limit and retrieving the Next URL and Previous URL to display the records page wise.
<html>
<head>
<title>Displaying All the Products Records Created / Updated from 25 June 2020 using Shopify API with Pagination</title>
</head>
<body>
<h3 align="center">Displaying All the Products Records Created / Updated from 25 June 2020 using Shopify API with Pagination</h3>
</body>
</html>
<?php
// url format for private app : https://{apikey}:{password}@{hostname}/admin/api/{version}/{resource}.json
$api_key = "4a4b367388d6a342feedef5b8a2d2862";
$password = "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";
//$shop = "radhe-online-store";
$shop = "radheshyampkori";
//$api_endpoint = "/admin/api/2020-04/products.json?status=any";
//$api_endpoint = "/admin/api/2020-04/products.json?presentment_currencies=USD";
//$api_endpoint = "/admin/api/2020-04/products/count.json";
$api_endpoint = "/admin/api/2020-04/products.json?status=any&limit=2&created_at_min=2020-06-25T00:00:01&updated_at_min=2020-06-25T00:00:01";
//$url = "https://" . $api_key .":".$password ."@". $shop . ".myshopify.com" . $api_endpoint;
$i = 1; // initializing count to display the page nos
echo "Records of Page Nos: ".$i; echo "</br>";
echo "================="; echo "</br>"; echo "</br>";echo "</br>";
// Passing the parameters to function to get the Response Headers and 2 Records of Customers per page
$product_data = get_response_data($api_key, $password, $shop, $api_endpoint);
//echo "Customer Data of the store url: "; echo "<pre>";print_r($product_data); echo "</pre>";
$url_next = $product_data[0]; // Obtaining and storing the URL to display the Next page Records
$next_rel_link = $product_data[1]; // Obtaining and Storing rel="next" used to check whether more Next pages exists to display records
$url_previous = $product_data[2]; // Obtaining and storing the URL to display the Previous page Records
/** Obtaining and Storing rel="previous" used to check whether more Previous pages exists to display records **/
$previous_rel_link = $product_data[3];
$i = 2; // initializing count to display the page nos
while($next_rel_link != '')
{
$explode_pagination_url = explode("?",$url_next);
$api_endpoint_limit_portion = $explode_pagination_url[1];
$api_endpoint = "/admin/api/2020-04/customers.json?".$api_endpoint_limit_portion;
echo "Records of Page Nos: ".$i; echo "</br>";
echo "================="; echo "</br>"; echo "</br>";echo "</br>";
/** Passing the URL, Paramenters along with endpoint for the Next Page URL to display next set of records **/
$product_data = get_response_data($api_key, $password, $shop, $api_endpoint);
$url_next = $product_data[0]; // Obtaining and storing the URL to display the Next page Records
$url = $url_next;
$next_rel_link = $product_data[1]; // Obtaining and Storing rel="next" used to check whether more Next pages exists to display records
$url_previous = $product_data[2]; // Obtaining and storing the URL to display the Previous page Records
/** Obtaining and Storing rel="previous" used to check whether more Previous pages exists to display records **/
$previous_rel_link = $product_data[3];
$i = $i + 1; // Incrementing the Page count
}
function get_response_data($api_key, $password, $shop, $api_endpoint)
{
$url = "https://" . $api_key .":".$password ."@". $shop . ".myshopify.com" . $api_endpoint;
echo "Latest URL"; echo "</br>";
echo $url; echo "</br>";
if (!function_exists('curl_init'))
{
die('CURL is not installed or it is not loaded!');
}
$shopcurl = curl_init();
curl_setopt($shopcurl, CURLOPT_URL, $url);
curl_setopt($shopcurl, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
curl_setopt($shopcurl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($shopcurl, CURLOPT_VERBOSE, 0);
curl_setopt($shopcurl, CURLOPT_HEADER, 1);
curl_setopt($shopcurl, CURLOPT_CUSTOMREQUEST, "GET");
curl_setopt($shopcurl, CURLOPT_SSL_VERIFYPEER, false);
$response = curl_exec ($shopcurl);
curl_close ($shopcurl);
echo "<pre>";print_r($response); echo "</pre>";
$responseHeaders = get_headers($url,1);
// echo "<pre>";print_r($responseHeaders); echo "</pre>";
$next_link = "";
$previous_link = "";
$url_for_next_records_with_pagination = "";
$url_for_previous_records_with_pagination = "";
if(array_key_exists('Link',$responseHeaders))
{
// echo "Link exists";echo "</br>";
$link = $responseHeaders['Link']; // retriving the Value of the Link including the Next and Previous URLs
$link0 = $responseHeaders['Link'][0];
$link1 = $responseHeaders['Link'][1];
$checking_rel_previous_exists_with_location = strpos($link,'rel="previous"',0); // checking whether rel="previous" exists
$checking_rel_next_exists_with_location = strpos($link,'rel="next"',0); // checking whether rel="next" exists
if(!empty($checking_rel_previous_exists_with_location))
{
$pos_first_char_for_next_in_link = strpos($link, '<', 1); // finding position of < before the URL from the Link
/** finding position of > after the URL from the Link **/
$pos_last_char_for_next_in_link = strpos($link, '>', $pos_first_char_for_next_in_link);
$retrieved_next_url = substr($link, $pos_first_char_for_next_in_link + 1, -13); // Retrieving the Next URL
$explode_value_of_pagination_url = explode(";",$link);
$first_portion_of_Link = $explode_value_of_pagination_url[0];
$previous_portion_of_Link = $explode_value_of_pagination_url[1];
$end_portion_of_Link = $explode_value_of_pagination_url[2]; // Storing the rel="next" in a variable
}
else
{
//echo "rel Previous does not exists";
$pos_first_char_in_link = strpos($link, '<', 0); // finding position of < before the URL from the Link
/** finding position of > after the URL from the Link **/
$pos_last_char_in_link = strpos($link, '>', 0);
$retrieved_next_url = substr($link, $pos_first_char_in_link + 1, $pos_last_char_in_link - 1); // Retrieving Next URL
$explode_value_of_pagination_url = explode(";",$link);
$first_portion_of_Link = $explode_value_of_pagination_url[0];
$end_portion_of_Link = $explode_value_of_pagination_url[1]; // Storing the rel="next" in a variable
}
}
$url_for_next_records_with_pagination = $retrieved_next_url; // Storing the URL to be used to display Next page records
$next_link = $end_portion_of_Link; // Storing the rel="next" in a variable to check further Next page records exists
return array($url_for_next_records_with_pagination, $next_link, $url_for_previous_records_with_pagination, $previous_link);
}
?>
