I’m trying to use a customizeCell function to replace the cell value with the result of an HTTP call to a REST API. In order to do that, I need to make the customizeCell function asynchronous and use the await keyword to wait for the HTTP result.
Even though the execution is happening in the right order, the cell text is not modified.
I attach 4 screenshots:
Is this functionality supported?
Thanks and regards,
Thank you for writing to us.
The asynchronous approach is not available for
customizeCell. Please note, that
customizeCell is called on each redraw, scroll and other operations that change the pivot view. Thus, that method should be synchronous so not to reduce the performance.
For your case, we recommend preparing all the necessary data before running
Please let us know in case of any other question.
Thanks for the quick reply!