Create TDV View using API

Create TDV View using API

book

Article ID: KB0082819

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Versions

Description

There is a programmatic way to create a view -
 
The admin api below can be used to create any resource
 
/services/webservices/system/admin/resource/operations/createResource
 
Then use this one to modify any existing view.
 
/services/webservices/system/admin/resource/operations/updateSqlTable
 
You can call both through sql script
 
e.g.
 
PROCEDURE ss1()
BEGIN
declare x xml;
 
call /services/webservices/system/admin/resource/operations/createResource('<resource:createResource xmlns:common="http://www.compositesw.com/services/system/util/common" xmlns:resource="http://www.compositesw.com/services/system/admin/resource"><resource:path>/shared</resource:path><re...);
 
call /services/webservices/system/admin/resource/operations/updateSqlTable('<resource:updateSqlTable xmlns:common="http://www.compositesw.com/services/system/util/common" xmlns:resource="http://www.compositesw.com/services/system/admin/resource"><resource:path>/shared/foo</resource:path... * from /services/databases/system/all_tables</resource:sqlText></resource:updateSqlTable>',x,x);
 
END
 

Issue/Introduction

Create TDV View using API
Powered by Wolken Software