Use a Temp Table with REST API Connection

[Craig Reed]

When using a REST API connector as the data source in Tibco Data Virtualization, is there a way to temporarily store the results from the REST API in a temp table

 

More Information:

I have a connection to a REST API created in Tibco Data Virtualization. The data is returned as JSON. I'm using a Stored Procedure in DV to pull the data from the API in pages and transform it from JSON to a rowset. Data is returned from the Stored Procedure using a PIPE variable. A series of other views build on the results of the stored procedure and each other to create columns that identify the hierarchy between records and to aggregate specific values at parent levels of the hierarchy. It would be a lot cleaner/easier, if the original stored procedure could do all of this work in one place using a temp table that could then be used as the source for returning a rowset through the PIPE variable. I haven't seen a way to create something like a temp table when connecting to a REST API.

[Motsu Aboshi]

Can you elaborate on how your use case differs, from one that would be solved using caching REST -> transform -> Cache -> Views

 

The product does have temporary table functionality, but I've never seen it used in the manner described.