Sheets API Not Working
-
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)
After further testing i have found that intially they work, but after they reach
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 cellTLDR: 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> -
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)
After further testing i have found that intially they work, but after they reach
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 cellTLDR: 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
Reading range A1:Z999999 is definitely too large. How about trying to read a few rows at a time?
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login