Data table not always refreshing | Appsmith | Page 1

graceful stirrup Oct 3, 2022, 5:39 PM

#

Problem: Table data source is from API request, but not always is refreshing the content when i made a new request to the same endpoint.

Using an asynchronous request is not resolving the issue.

I have a table with products data.
Process:

Click the actions button in a row, this opens a phase change modal.
Select new phase and submit, this opens a confirmation modal.
Confirm change (here the request is made).
Refreshes the table to see the change.

() Products table source data comes from API request.
() The Phase Change is done by request to the API.

halcyon hazelBOT Oct 3, 2022, 5:42 PM

#

Hey! Could you show the code you have in both the modal submit button and t he
tables data field?

graceful stirrup Oct 4, 2022, 12:21 AM

#

#

#

#

halcyon hazelBOT Oct 4, 2022, 12:30 AM

#

I think the issue here is that your table data is set to a function. It would be
better to store the result at the end of that function and then bind the table
to the stored value. Then, whenever you run the function the table will be
automatically refreshed. You can use storeValue for this and use the docs here
as guidance:

https://docs.appsmith.com/reference/appsmith-framework/widget-actions/store-value

Store Value

graceful stirrup Oct 4, 2022, 12:46 PM

#

We are going to have a hundred thousand results, using storeValue() is not scalable.

graceful stirrup Oct 4, 2022, 1:02 PM

#

the API response may take a few seconds. When it responds quickly the table is updated, but when it takes several seconds, it does so asynchronously.

halcyon hazelBOT Oct 4, 2022, 3:18 PM

#

I am sorry you are experiencing these troubles. We have raised the issue
internally and are investigating this. We'll get back to you asap.

worn tiger Oct 5, 2022, 9:42 AM

#

Hey, @graceful stirrup is it possible for you to share the app with us? It's difficult to figure out from the screenshots

graceful stirrup Oct 5, 2022, 2:34 PM

#

Hey @worn tiger I'm not able to share the app due to sensible data but we could schedule a meeting in order to review the code.

strong musk Oct 7, 2022, 4:01 AM

#

Hey @graceful stirrup

Instead of calling the API the application is calling JS function that only returns data after manipulation. Application will instead need to make API call in successChangeStateMachine .

So, instead of this code return JSGetProductData.getProductData()

user will need to write

 user_products.run()```

halcyon hazelBOT Oct 7, 2022, 7:11 PM

#

@graceful stirrup We see at the top of your function you're referencing
selectStages.data, user_products.data, and products.data. However, we
never see you call the run functions associated with these. Can you show us
where and when selectStages.run(), user_products.run(), and products.run()
are called?

graceful stirrup Oct 11, 2022, 7:26 PM

#

I must manipulate the API response before populating the table.

#

The post request to qa_change_stage_machine_phase produces several asynchronous processes, when we receive a quick response the table get refreshed but when it takes several seconds Appsmith doesn´t wait for a response. I solved the problem setting a one minute time out.

halcyon hazelBOT Oct 12, 2022, 3:40 AM

#

So the issue was that the API failed/timed out. Thanks for sharing the solution.

#Data table not always refreshing