php – Converting Google Sheet to Json file, only reading up to 99 data

[ad_1]

When I convert data from Google Sheet to json file, does it only read up to 99 data and not read the rest of the data? Here is the coding part //API key is also added in the coding //

// Google API Key $apiKey = ‘YOUR_API_KEY’; // Add API key to URL $urlWithKey = $url . ‘?key=’ . $apiKey; // Display a message to the user echo “Fetching data……”; // Retrieving URL content as HTML $htmlData = file_get_contents($urlWithKey);

I tried adding echo for $htmlData and the data is only reading up to 99, here is the proof it reads up to 99 data (picture of 99data). For example, if the data in google sheet is only 50, it is reading the 50 data but if the data in google sheet is more than 99, it is only reading up to 99 and no more.

How can I make data entry unlimited? Like when I convert maybe 1000 data I want it to be read and converted to json file.

image by 99data

[ad_2]