Invoking Test Data Management REST APIs Using cURL

Invoking Test Data Management REST APIs Using cURL

View a List of Schemas in the Connection

View a List of Schemas in the Connection

You can run a REST API to view a list of schemas in the connection from which you can import the source metadata.
You can run the
/tdm/v1/connections/{connectionId}/schemas
API to view a list of schemas.
  1. Enter the following cURL API request:
    curl -X GET "http://<host>:<port>/api/public/tdm/v1/connections/U:1kjBTQOEemYiOETycM8Kg/schemas" -H "accept: application/json" -H "authorization: Basic TmF0aXZlL0FkbWluaXN0cmF0b3I6QWRtaW5pc3RyYXRvcg=="
  2. Press Enter.
  3. Review the response to view a list of schemas.
    The following code is the response that the sample request returns:
    [ "ANONYMOUS","DB01","DB02","DBSNMP", "DIP","DIS101","DOMAIN102", "DOMAIN102HF1","DOMAIN102R1","DOMAIN961HF3", "ECOM","EXFSYS","FLOWS_FILES","GCS_02509644", "HR","IX","JUNIT","JUNITS101", "KUMARPRO","KUMARTWO","MART102", "MART102_NEW","MART102HF1","MART500", "MART_TEST_01","MARTJUNITS101","MDDATA", "MDSYS","MGMT_VIEW","MMS101","MRS101","MRS102", "MRS102HF1","MRS102R1","MRS961","MRS961HF3", "MRS961HF4","OE","OLAPSYS","ORACLE_OCM","ORDDATA", "ORDPLUGINS","ORDSYS","OUTLN","OWBSYS","OWBSYS_AUDIT", "PC101","PC961HF3","PC961HF4","PCADMIN","PCDIS","PCMRS", "PCREPO","PCRS101","PCRS102","PCRS102HF1","PCRS102R1", "PCRS961","PCRS961EBF","PCRS961HF3","PCRS961HF3TEST", "PCRS961HF4","PM","PROF971PVT","PROFILE102R1","PROFILING102", "REPOTDW102","RESMED971HF1","SCOTT","SH","SI_INFORMTN_SCHEMA", "SPATIAL_CSW_ADMIN_USR","SPATIAL_WFS_ADMIN_USR","STORAGE102", "STORAGE102R1","SYS","SYSMAN","SYSTEM","TDM101","TDM101_UPGRADE", "TDM102","TDM102_JUNITS","TDM102_R1","TDM102HF1", "TDM102R1","TDM102R1EBF","TDM961","TDM961PVT2", "TDM961PVT3","TDM970","TDM971","TDM971HF1", "TDM971MART02","TDM971PVT","TDM971PVT1", "TDM_REPO","TDM_REPO_02","TDW","TDW101", "TDW102HF1","TDW102HF1_02","TDW971MART", "TDW971PVT","TDW971REPO","TDW_02","TDW_MART", "TDW_REPO","TDW_REPO_02","TDW_REPO_2", "TDW_REPO_TEST_01","TDWMART","TDWMART101","TDWREPO", "TDWREPO102","TDWREPO102_TEMP","TDWREPO500", "TDWRESET101","TDWTARGET102","TDWTEST02", "user","VERIZON02283505","WMSYS","XDB","XS$NULL" ]
You identify the schema DB01 that you want to use from the list of schemas.

0 COMMENTS

We’d like to hear from you!