Hi @thistleandtweed
To get the data into SAS VA you'll need to load data into a CAS table (in-memory dataset).
You can do this in several different ways by API, though if you are working in Python then you may want to use the SAS SWAT package. The project can be found here: https://github.com/sassoftware/python-swat
To get data refreshed in VA you'll need to create a CAS table and add it to the VA report, from there you can append new rows to the table via your Python API call.
For example, here is something I've done in the past to append rows in real time to create a real-time dashboard in VA
import swat
import pandas as pd
# create connection to SAS Viya using swat
conn= swat.CAS(host, 443, user, pwd)
# load dataframe to CAS as temp table
conn.upload_frame(df_out,casout={'name':'temp','replace':True})
# append to streaming dataset [note - there may be better ways to do this]
conn.dataStep.runCode(code = ''' data casuser.stream_output(append=yes);set casuser.temp;run;''')
There are, of course, many different ways you might do this programmatically and via the various APIs available in SAS Viya. The best option will depend on volume of data, whether you're working on batch/stream, whether there needs to be any user interaction from the front end etc.
Thanks
Harry
