Synchronous DataTable.Refresh()

Set up (also see attached .dxp):
1. Add On Demand Data Table e.g Film, triggered by Property Control. Set "Load Automatically" to unchecked (to prevent auto loading of large amount of data)
2. Add Data Table from Existing Table in Analysis e.g. Film (UNPIVOTED)
3. Change Property Control to update Film table

We can script the refresh of the tables:
###################
myTable=myDocument.Data.Tables["Film"]
myTable.Refresh()

myTable=myDocument.Data.Tables["Film (UNPIVOTED)"]
myTable.Refresh()
############################

But this will not successfully refresh "Film (UNPIVOTED)" if "Film" takes a long time to load ("Film (UNPIVOTED)" refresh will be called before "Film" refresh is complete).

ENHANCEMENT REQUEST: a synchronous Refresh() method that will wait for the first Refresh() to complete before running

WORKAROUND: We can create a script to refresh Film (UNPIVOTED), but we need to manually create a WaitUntil function to pause execution:
#######################
from Spotfire.Dxp.Application import *
from Spotfire.Dxp.Application.Visuals import *
import time

myDocument=Application.Document

SourceTable=myDocument.Data.Tables["Film"]
SourceTable.Refresh()

def waituntil(condition, timeout, period):
mustend = time.time() + timeout
while time.time() < mustend:
if not SourceTable.Refreshing: return True
time.sleep(period)
return False

waituntil(not SourceTable.Refreshing, 5000, .25)

myTable=myDocument.Data.Tables["Film (UNPIVOTED)"]
myTable.Refresh()
#######################

Note:
- Film (UNPIVOTED) is not an On-Demand table to avoid having to pull the data from the database twice
- Film (UNPIVOTED) does not update automatically and DataTable.Refreshable property never gets set to true.