Max Requests Per Page?

  • Resolved tadgill

    (@tadgill)


    7 years, 4 months ago

    As a non developer I have jumped through tons of hoops to display data from Google Sheets since 2011 – this plugin fixes every problem ever. Make a pro version and I’ll be the first to pay.

    My question is – I have a sheet that populates a restaurant menu. Every part of the menu goes with a one cell call.

    I’ve had the page load and be missing 75% of the data, then other time it is 100% there again then another it may be missing just one thing.

    Is there something I need to change to prevent this?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter tadgill

    (@tadgill)

    Also looked in the API stats at Google and there are quite a few 429 errors. The way the data was laid out I had to use a shortcode for every single cell that I needed.

    What I am doing as a work around right now is created another sheet where I am bringing the data together so that I can make 8 calls instead of 50. The super WIN is that I was able to style rows even though there was one call and therefore only one class speced in the shortcode with one weird trick! Since the sheet I created to gather the data in chunks was mostly just cell references, I used the CONCATENATE function to add a formula like this:
    =CONCATENATE("<div class='menu-disc-left'>",'Food Right'!A24,"</div>")
    To my amazement the HTML pulled in from the Google sheet was rendered not just printed as plain text.

    PERFECT! This creates some really powerful options!

    Plugin Author Dan D

    (@duplaja)

    Tadgill, I’m glad you were able to get something working for you! I appreciate you sharing what you found.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Max Requests Per Page?’ is closed to new replies.