Navigation

    CreatiCode Scratch Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • CreatiCode

    Sheets API Not Working

    Feedback
    2
    2
    96
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Tyller_
      Tyller_ Best Forum Helpers last edited by

      I have changed to hte sheets api for my chat rooms project, and it seems that I am unable to read or write to the sheet, I have verified the user and sheet names and it seems it was working but has stopped working for reading at all, it just immediately skips (though now that I Think about it it may be the cloud blocks because the create random world i have to fix a minor bug, is just immediately skipped) IMG_0092.jpeg

      After further testing i have found that intially they work, but after they reach IMG_0093.jpeg it seems that it reaches this and freeezes, then it goes on and after this block runs then the above bug (null returning) happens, but before it runs it will return the proper output for the referenced cell

      TLDR: It seems that either just reading, attempting to read a lot of data, or reading a lot of data (the actual table currently has 3 columns by 16 rows so I very much hope it isnโ€™t reading too much data) cuauses cloud blocks to lock out

      <div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
      </div>

      info-creaticode 1 Reply Last reply Reply Quote 1
      • info-creaticode
        CreatiCode @Tyller_ last edited by

        @tyller_

        Reading range A1:Z999999 is definitely too large. How about trying to read a few rows at a time?

        1 Reply Last reply Reply Quote 1
        • First post
          Last post