Run code after data on demand table is updated

[Nikita Belooussov]

Hi,

I have several data on demand tables. I want to try to have a code that will run after the data inside the tables changes. I have tried using the automatic load for the r functions, but that does not seem to be working. I have also tried to run the code after the markings are set in the original table, but that also does not seem to work. Is there anyway of doing this The scripts I am trying to run are python, but if there is a way to do this in r, it will work too.I am running spotfire v7.11.

Thanks

[Fabian Duerr]

I don't know if this will work but can you try to create a new doc property that takes for example a timestamp. Then update this timestamp whenever your data tables are refreshed. And then you could probably use a script with your doc property to start your code:

 

[Nikita Belooussov]

@fabd I am assuming you mean doing something like this:

 

https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-45663

 

I should have mentioned that I tried doing something like this but for some reason it does not work either.

[Fabian Duerr]

Yes, this is the approach I would go.

 

How do you obtain/refresh your data tables With a data function If yes, then just create an additional output in your data function that updates this doc property. 

 

Can you give more details on how you tried this approach

[Nikita Belooussov]

So calling them a data on demand table might be slightly wrong, since they are the user input tables used to upload a new table, but I am assuming that they work the same way that data on demand do. I am updating them using a python script to change which values are marked, which updates the next table.I have tried having the python script updating a document property triggering the next script, which marks the rows and updates another document property for another one of these codes. I have also tried to update the tables in the one script with delays for the tables to load. Lastly I tried having the r script change the document property on the change of the tables to trigger the scripts. None of these worked. 

[Fabian Duerr]

Sorry, I can't help further here. My experience with scripts is limited.