Hi @Nazarii_Bilous - you can query a specific view if you know the name of it, but there isn’t a way to return the set of available views on a table via the API, I’m afraid.
Hi @Nazarii_Bilous - you can query a specific view if you know the name of it, but there isn’t a way to return the set of available views on a table via the API, I’m afraid.
This is a a script to run within the scripting block. It would be manual, i.e. someone would need to run the script, but you could periodically write the tables and views to a “schema” table, then query this table via the API.