1. Oracle GoldenGate 23ai Microservices Architecture REST API Documentation
  2. Tasks
  3. Distribution Service

Get a list of data stream resources

get

/services/{version}/stream

Required Role: User

Get a list of data stream resources

Request

Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Body ()
Root Schema : Oracle GoldenGate DataStream Collection
Type: object
Title: Oracle GoldenGate DataStream Collection
Show Source
Nested Schema : items
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 32767
Show Source
Nested Schema : items
Match All
Show Source
Nested Schema : items-allOf[0]
Type: object
Additional Properties Allowed: true
Show Source
Nested Schema : items-allOf[1]
Type: object
Additional Properties Allowed: true
Show Source
Nested Schema : status
Item status
Match Any
Show Source
  • Allowed Values: [ "starting", "running", "stopped", "killed", "abended" ]
  • Default Value: stopped
    Allowed Values: [ "paused", "running", "stopping", "stopped", "killed", "uninitialized" ]
Nested Schema : details
Type: object
Show Source
Nested Schema : encoding
data encoding method
Default Value: json
Match One
Show Source
Nested Schema : rules
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1024
Show Source
Nested Schema : source
Type: object
source endpoint of the data stream.
Show Source
  • Minimum Length: 1
    Maximum Length: 4096
    The path where trail data is stored
  • Minimum Length: 2
    Maximum Length: 512
    Pattern: ^[a-zA-Z0-9_#$/-]*$
    The name of the trail
Nested Schema : encoding-x-oneOf[0]
Type: object
json encoding configuration
Show Source
Nested Schema : json
Type: object
Show Source
Nested Schema : metaFields
Type: object
specifies metadata to include in records
Show Source
Nested Schema : operationStrings
Type: object
operation type string values
Show Source
Nested Schema : staticFields
Type: object
specifies fields with static values in records
Nested Schema : catalog
Default Value: false
Match One
Show Source
Nested Schema : csn
Default Value: false
Match One
Show Source
Nested Schema : currentTs
Default Value: false
Match One
Show Source
Nested Schema : currentTsMicroSecs
Default Value: false
Match One
Show Source
Nested Schema : env
Default Value: oracle.doceng.json.BetterJsonNull@129348e8
Match One
Show Source
Nested Schema : opSeqno
Default Value: false
Match One
Show Source
Nested Schema : opTs
Default Value: true
Match One
Show Source
Nested Schema : opTsMicroSecs
Default Value: false
Match One
Show Source
Nested Schema : opType
Default Value: true
Match One
Show Source
Nested Schema : pos
Default Value: true
Match One
Show Source
Nested Schema : primaryKeys
Default Value: false
Match One
Show Source
Nested Schema : qualifiedTable
Default Value: true
Match One
Show Source
Nested Schema : schema
Default Value: false
Match One
Show Source
Nested Schema : sys
Default Value: oracle.doceng.json.BetterJsonNull@22349ad3
Match One
Show Source
Nested Schema : table
Default Value: false
Match One
Show Source
Nested Schema : tokens
Default Value: oracle.doceng.json.BetterJsonNull@341c0dfc
Match One
Show Source
Nested Schema : transInd
Default Value: false
Match One
Show Source
Nested Schema : xid
Default Value: true
Match One
Show Source
Nested Schema : env-x-oneOf[1]
Type: object
Nested Schema : sys-x-oneOf[1]
Type: object
Nested Schema : tokens-x-oneOf[1]
Type: object
Nested Schema : items
Type: object
data streaming rule
Show Source
Nested Schema : filter
data streams rule filter
Match One
Show Source
Nested Schema : filter-x-oneOf[0]
Type: object
data record object names
Show Source
Nested Schema : filter-x-oneOf[1]
Type: object
data record operation types
Show Source
Nested Schema : filter-x-oneOf[2]
Type: object
data record column values
Show Source
Nested Schema : filter-x-oneOf[3]
Type: object
data record tags
Show Source
Nested Schema : filter-x-oneOf[4]
Type: object
data record partition names
Show Source
Nested Schema : filter-x-oneOf[5]
Type: object
data record user tokens
Show Source
Nested Schema : objectNames
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 65535
set of object names
Show Source
  • items
    Qualified table name where any name component may contain wildcard characters
Nested Schema : items
Qualified table name where any name component may contain wildcard characters
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : operationTypes
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 6
set of operation types
Show Source
  • Allowed Values: [ "DML", "DDL", "INSERT", "UPDATE", "UPSERT", "DELETE" ]
Nested Schema : columnValues
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 65535
set of column values
Show Source
Nested Schema : items
Type: object
Show Source
  • Minimum Length: 1
    Maximum Length: 130
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])$
    name of the column
  • columnValue
    column data, currently only support char and binary integer type
  • Default Value: before
    Allowed Values: [ "before", "after" ]
    before or after column image. INSERT only has after image and DELETE only has before image, applies to cases where both before and after images are available.
  • Default Value: equalTo
    Allowed Values: [ "equalTo", "notEqualTo", "lessThan", "lessThanOrEqualTo", "greaterThan", "greaterThanOrEqualTo" ]
    comparison operator
  • tableName
    name of the table in which the column(s) reside
Nested Schema : columnValue
column data, currently only support char and binary integer type
Match One
Show Source
Nested Schema : tableName
name of the table in which the column(s) reside
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : tags
set of binary tags
Match One
Show Source
  • tags-x-oneOf[0]
    Minimum Number of Items: 1
    Maximum Number of Items: 32767
  • Allowed Values: [ "all", "none" ]
Nested Schema : tags-x-oneOf[0]
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 32767
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Binary string representing the tag value.
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Hexdecimal string representing the tag value.
Show Source
Nested Schema : items-x-oneOf[2]
Type: object
binary tag bitmask value, bitwise AND operation will be performed against the tag associated with the LCR.
Show Source
  • Minimum Length: 1
    Maximum Length: 2000
    Pattern: ^[01]{1,2000}$
    binary string representing the tag mask value.
Nested Schema : items-x-oneOf[3]
Type: object
Hexdecimal tag bitmask value, bitwise AND operation will be performed against the tag associated with the LCR.
Show Source
  • Minimum Length: 1
    Maximum Length: 2000
    Pattern: ^[A-Fa-f0-9]{1,2000}$
    Hexdecimal string representing the tag mask value.
Nested Schema : partitionNames
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 65535
set of partition names
Show Source
  • items
    Qualified partition name where any name component may contain wildcard characters
Nested Schema : items
Qualified partition name where any name component may contain wildcard characters
Match Any
Show Source
  • Minimum Length: 7
    Maximum Length: 523
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : userTokens
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 65535
set of user tokens
Show Source
Nested Schema : items
Type: object
Show Source
  • Default Value: exactCaseSensistive
    Allowed Values: [ "exactCaseSensitive", "exactCaseInsensitive", "partialCaseSensitive", "partialCaseInsensitive" ]
    how to match the filter value
  • Minimum Length: 1
    Maximum Length: 30
    user token name
  • Minimum Length: 1
    Maximum Length: 32767
    user token value
Example Response (application/json)
{
    "$schema":"api:standardResponse",
    "links":[
        {
            "rel":"canonical",
            "href":"http://localhost:9002/services/v2/stream",
            "mediaType":"application/json"
        },
        {
            "rel":"self",
            "href":"http://localhost:9002/services/v2/stream",
            "mediaType":"application/json"
        },
        {
            "rel":"describedby",
            "href":"http://localhost:9002/services/v2/metadata-catalog/stream",
            "mediaType":"application/schema+json"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:collection",
        "items":[
            {
                "links":[
                    {
                        "rel":"parent",
                        "href":"http://localhost:9002/services/v2/stream",
                        "mediaType":"application/json"
                    },
                    {
                        "rel":"canonical",
                        "href":"http://localhost:9002/services/v2/stream/mystream2",
                        "mediaType":"application/json"
                    }
                ],
                "$schema":"ogg:collectionItem",
                "name":"mystream2"
            },
            {
                "links":[
                    {
                        "rel":"parent",
                        "href":"http://localhost:9002/services/v2/stream",
                        "mediaType":"application/json"
                    },
                    {
                        "rel":"canonical",
                        "href":"http://localhost:9002/services/v2/stream/mystream1",
                        "mediaType":"application/json"
                    }
                ],
                "$schema":"ogg:collectionItem",
                "name":"mystream1"
            }
        ]
    }
}
Back to Top