Where can I find a CAS data table URI in VIYA?

Ullsokk — Fri, 28 Aug 2020 12:08:50 GMT

I have seen screenshots of details showing a CAS table URI, but I can't find out where in VIYA I can find those details. Have also tried getting the URI thourgh code, which works for tables on our 9.4 environment, but not on the CAS libs.

Need the URI for testing out the API functions

Re: Where can I find a CAS data table URI in VIYA?

joeFurbee — Fri, 28 Aug 2020 13:20:20 GMT

Hi @Ullsokk,

I'll provide some general information about table APIs, but the more information you can provide on your task/use case, the more details I can provide.

First there is the Data Tables API as defined on developer.sas.com. Using curl, the most basic GET endpoint for this API takes the form:

curl -X GET https://www.example.com/dataTables/dataSources/{dataSourceId}/tables/{tableId} \
  -H 'Authorization: Bearer <access-token-goes-here>' \ 
  -H 'Accept: application/vnd.sas.data.table+json'

Here is an example url:

https://mysasserver.sas.com/dataTables/dataSources/cas~fs~cas-shared-default~fs~public/tables/CAMPAIGN_POST_TEST

There are many other endpoints within this API for tables. Additional examples are on GitHub.

You also may consider the tables CAS action set. This API provides a host of other table endpoints.

An example of loading a table to memory API call is:

https://mysasserver.sas.com/cas-shared-default-http/cas/sessions/{{sessionid}}/actions/table.loadTable

with body contents:

{"caslib":"CASUSER(sasdemo)","importOptions":{"fileType":"AUTO"},"path":"DATA_ON_THE_FLY.sashdat",

"casout":{"caslib":"PUBLIC","name":"flight_data","promote":true}}

I hope these at least get you started on using the APIs.

Thanks,

Joe

Re: Where can I find a CAS data table URI in VIYA?

Ullsokk — Fri, 28 Aug 2020 13:50:25 GMT

I have the API up and running, but was struggling to find the table URIs. Turns out they can be found in the Explore Lineage pane i Viya, by searching for the table name and looking at details.

topic Re: Where can I find a CAS data table URI in VIYA? in Developers

Where can I find a CAS data table URI in VIYA?

Re: Where can I find a CAS data table URI in VIYA?

Re: Where can I find a CAS data table URI in VIYA?