Page keeps locking up

Account & User Management
1

Current plan level (Free, Team, Business, or Enterprise: Retool pricing): Business
Monthly/Annual (if Team or Business): $50.00
Version of Retool (if self-hosted): N/A

Question / Description: For some reason my pages seem to be locked up this morning. I was trying some fixes I found for returning all the rows in Airtable, and I think something has caused it to lock up my pages. I tried removing the changes I had implemented, but no luck. Can someone look at my Pools Shipping project and see if there is something running in the background that won't stop?

3

Hi @tomm,

Thanks for reaching out! I'm not able to log in to your account, but I'll take a look if you send me a screen recording & app json.

4

Additionally, it would be helpful to see any browser console errors. Is everyone on your team experiencing this issue?

5

Thanks for the reply. I determined the lock up was being caused by a loop I was stuck in. I managed to finally fix that, but I still have the problem that caused me to be stuck in a loop. I am trying to move data over from Airtable using the REST API which will only allow 100 records at a time. I cannot figure out how to get all of the records. If you could offer any assistance with that problem, it would be most appreciated. I have been struggling with it for some time. Thank you.

6

Hey @tomm,

We have this example - Returning all results for a cursor-based paginated API

But it may need to be customized depending on your specific data. Happy to take a look at your code if you'd like

7

Hey Tess,

This is what I was trying to use when I got caught in a loop. With that being the case, I really don't have any code to show you. I'm still pretty new to this.

My name for the REST API Resource is simply Airtable and the name for the query that uses that resource is query36. I don't know if that information helps at all. Any help you can provide would be very appreciated. You can even log into my account and take a look if you like.

8

Hey @tomm,

Unfortunately, we don't log in to customer apps for security reasons. If you share an export and screenshot of your data structure, I'm happy to take a look at your code

image
image1256×838 57.2 KB

9

Is this what you are looking for?
Pools_20Shipping.json (348.7 KB)

10

It looks like the first offset value you're passing in from query37 is 0.

For testing purposes, can you share an example of the data structure if you replace {{offset}} with a hardcoded 0

Once we sort out the Javascript code, you'll want to make these changes:

  1. change query36 to be a manually triggered query instead of automatic


​

2. Change query37 to trigger on page load:

3. Change the data source of table1 to query37

11

Hi Tess,

This is what I got when I changed the offset to a hardcoded 0.

Screenshot 2024-08-22 061700
Screenshot 2024-08-22 061700500×600 21 KB

12

Hm it seems like 0 is the wrong value to start with. If you remove the offset entirely do you get the first page of results? If so, you might want to try this approach