Hi,
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,
Xavier
Hello Xavier,
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 customizeCell
.
Please let us know in case of any other question.
Regards,
Dmytro
Thanks for the quick reply!