Jump to

• Request
• Response

Get all integration instances using advanced query

post

/api/boss/data/objects/ora/cxSalesCommon/integration/v1/$en/integrationInstances/integrationInstances/$query

Request

There are no request parameters for this operation.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Match All

Show Source

• allOf __collection_query
• object type

{
    "allOf":[
        {
            "$ref":"#/components/schemas/__collection_query"
        },
        {
            "type":"object",
            "properties":{
                "parameters":{
                    "type":"object",
                    "description":"Values to be applied in a parameterized filter specific to the view."
                }
            }
        }
    ]
}

Nested Schema : __collection_query

Match All

Show Source

• object schema
• object __collection_query-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/__item_query"
        },
        {
            "type":"object",
            "properties":{
                "collection":{
                    "type":"object",
                    "description":"Defines query criteria that can be applied on a resource collection.",
                    "properties":{
                        "filter":{
                            "type":"string",
                            "description":"The resource collection will be queried using the specified filter condition."
                        },
                        "limit":{
                            "type":"integer",
                            "description":"Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items."
                        },
                        "offset":{
                            "type":"integer",
                            "description":"Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned."
                        },
                        "sortBy":{
                            "type":"array",
                            "description":"Orders a resource collection based on the specified fields.",
                            "items":{
                                "oneOf":[
                                    {
                                        "type":"string",
                                        "description":"Name of field based on which sorting will happen. Order is ascending."
                                    },
                                    {
                                        "type":"object",
                                        "description":"Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order."
                                    }
                                ]
                            }
                        },
                        "privilege":{
                            "type":"string",
                            "description":"Represents the privilege or action required to check for while serving a request to access a resource."
                        }
                    },
                    "additionalProperties":false
                }
            }
        }
    ]
}

Nested Schema : schema

Type: object

Show Source

• accessors: object accessors
  Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base.
• fields: array fields
  Restricts the resource fields. Only the specified fields and mandatory system fields are returned.
• subTypes: object subTypes
  Maps discriminator values (as defined in subtypes) to query objects specific to corresponding subtypes. Subtype-specific query objects support a subset(fields,accessors,filter) of the query capabilities when compared to the base.

{
    "type":"object",
    "properties":{
        "fields":{
            "type":"array",
            "description":"Restricts the resource fields. Only the specified fields and mandatory system fields are returned.",
            "items":{
                "type":"string"
            }
        },
        "subTypes":{
            "type":"object",
            "description":"Maps discriminator values (as defined in subtypes) to query objects specific to corresponding subtypes. Subtype-specific query objects support a subset(fields,accessors,filter) of the query capabilities when compared to the base."
        },
        "accessors":{
            "type":"object",
            "description":"Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base."
        }
    }
}

Nested Schema : __collection_query-allOf[1]

Type: object

Show Source

• collection: object collection
  Defines query criteria that can be applied on a resource collection.

{
    "type":"object",
    "properties":{
        "collection":{
            "type":"object",
            "description":"Defines query criteria that can be applied on a resource collection.",
            "properties":{
                "filter":{
                    "type":"string",
                    "description":"The resource collection will be queried using the specified filter condition."
                },
                "limit":{
                    "type":"integer",
                    "description":"Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items."
                },
                "offset":{
                    "type":"integer",
                    "description":"Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned."
                },
                "sortBy":{
                    "type":"array",
                    "description":"Orders a resource collection based on the specified fields.",
                    "items":{
                        "oneOf":[
                            {
                                "type":"string",
                                "description":"Name of field based on which sorting will happen. Order is ascending."
                            },
                            {
                                "type":"object",
                                "description":"Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order."
                            }
                        ]
                    }
                },
                "privilege":{
                    "type":"string",
                    "description":"Represents the privilege or action required to check for while serving a request to access a resource."
                }
            },
            "additionalProperties":false
        }
    }
}

Nested Schema : type

Type: object

Show Source

• parameters: object parameters
  Values to be applied in a parameterized filter specific to the view.

{
    "type":"object",
    "properties":{
        "parameters":{
            "type":"object",
            "description":"Values to be applied in a parameterized filter specific to the view."
        }
    }
}

Nested Schema : accessors

Type: object

Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base.

Nested Schema : fields

Type: array

Restricts the resource fields. Only the specified fields and mandatory system fields are returned.

Show Source

• Array of: string

{
    "type":"array",
    "description":"Restricts the resource fields. Only the specified fields and mandatory system fields are returned.",
    "items":{
        "type":"string"
    }
}

Nested Schema : subTypes

Type: object

Maps discriminator values (as defined in subtypes) to query objects specific to corresponding subtypes. Subtype-specific query objects support a subset(fields,accessors,filter) of the query capabilities when compared to the base.

Nested Schema : collection

Type: object

Defines query criteria that can be applied on a resource collection.

Show Source

• filter: string
  The resource collection will be queried using the specified filter condition.
• limit: integer
  Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items.
• offset: integer
  Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned.
• privilege: string
  Represents the privilege or action required to check for while serving a request to access a resource.
• sortBy: array sortBy
  Orders a resource collection based on the specified fields.

{
    "type":"object",
    "description":"Defines query criteria that can be applied on a resource collection.",
    "properties":{
        "filter":{
            "type":"string",
            "description":"The resource collection will be queried using the specified filter condition."
        },
        "limit":{
            "type":"integer",
            "description":"Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items."
        },
        "offset":{
            "type":"integer",
            "description":"Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned."
        },
        "sortBy":{
            "type":"array",
            "description":"Orders a resource collection based on the specified fields.",
            "items":{
                "oneOf":[
                    {
                        "type":"string",
                        "description":"Name of field based on which sorting will happen. Order is ascending."
                    },
                    {
                        "type":"object",
                        "description":"Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order."
                    }
                ]
            }
        },
        "privilege":{
            "type":"string",
            "description":"Represents the privilege or action required to check for while serving a request to access a resource."
        }
    },
    "additionalProperties":false
}

Nested Schema : sortBy

Type: array

Orders a resource collection based on the specified fields.

Show Source

• Array of: items

{
    "type":"array",
    "description":"Orders a resource collection based on the specified fields.",
    "items":{
        "oneOf":[
            {
                "type":"string",
                "description":"Name of field based on which sorting will happen. Order is ascending."
            },
            {
                "type":"object",
                "description":"Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order."
            }
        ]
    }
}

Nested Schema : items

Match One Schema

Show Source

• string
  Name of field based on which sorting will happen. Order is ascending.
• object items-oneOf[1]
  Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order.

{
    "oneOf":[
        {
            "type":"string",
            "description":"Name of field based on which sorting will happen. Order is ascending."
        },
        {
            "type":"object",
            "description":"Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order."
        }
    ]
}

Nested Schema : items-oneOf[1]

Type: object

Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order.

Nested Schema : parameters

Type: object

Values to be applied in a parameterized filter specific to the view.

Back to Top

Response

Default Response

An array of items response

Body ()

Root Schema : integrationInstances_view-default

Match All

Show Source

• object __collection_context
• object integrationInstances_view-default-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/__collection_context"
        },
        {
            "type":"object",
            "properties":{
                "items":{
                    "type":"array",
                    "items":{
                        "$ref":"#/components/schemas/integrationInstances_view-default_item-response"
                    }
                }
            }
        }
    ]
}

Nested Schema : __collection_context

Type: object

Show Source

• hasMore: boolean

{
    "type":"object",
    "properties":{
        "hasMore":{
            "type":"boolean"
        }
    }
}

Nested Schema : integrationInstances_view-default-allOf[1]

Type: object

Show Source

• items: array items

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/integrationInstances_view-default_item-response"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: integrationInstances_view-default_item-response

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/integrationInstances_view-default_item-response"
    }
}

Nested Schema : integrationInstances_view-default_item-response

Match All

Show Source

• allOf integrationInstances_item-response
• object integrationInstances_view-default_item-response-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/integrationInstances_item-response"
        },
        {
            "type":"object",
            "properties":{
                "integrationInstanceId":{
                },
                "name":{
                },
                "routineExecutionId":{
                },
                "status":{
                },
                "integrationPayload":{
                },
                "createdBy":{
                },
                "timeCreated":{
                },
                "updatedBy":{
                },
                "timeUpdated":{
                },
                "integrationMap":{
                    "type":"object",
                    "properties":{
                        "integrationMapNumber":{
                        },
                        "name":{
                        },
                        "sourceObject":{
                        }
                    }
                }
            }
        }
    ]
}

Nested Schema : integrationInstances_item-response

Match All

Show Source

• object Integration Instance
  Title: Integration Instance

  Integration instances represent the details of specific records integrated between Sales and other Oracle applications, such as routine identifier, status, integration payload, and integration map identifier.
• object __busObj_context
• object integrationInstances_item-response-allOf[2]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstance_item"
        },
        {
            "$ref":"#/components/schemas/__busObj_context"
        },
        {
            "type":"object",
            "properties":{
                "integrationDetails":{
                    "$ref":"#/components/schemas/integrationInstances-integrationDetails"
                }
            }
        }
    ]
}

Nested Schema : Integration Instance

Type: object

Title: Integration Instance

Integration instances represent the details of specific records integrated between Sales and other Oracle applications, such as routine identifier, status, integration payload, and integration map identifier.

Show Source

• activeFlag: boolean
  Title: Active Flag

  Default Value: true

  Indicates whether the integration instance is active.
• createdBy: string
  Title: Created By

  Read Only: true

  The user who created the integration instance record.
• description: string
  Title: Integration Description

  The description of the integration instance.
• integrationInstanceId: string (big-integer)
  Title: Integration Instance Identifier

  The unique identifier of the integration instance.
• integrationInstanceNumber: string
  Title: Integration Instance Number

  The public unique identifier of the integration instance.
• integrationMap: integrationMap
• integrationPayload: string (long-text)
  Title: Integration Payload

  The payload for the integration.
• name: string
  Title: Integration Name

  The name of the integration instance.
• routineExecutionId: string (big-integer)
  Title: Routine Execution Identifier

  The execution identifier of the routine that created the integration instance.
• status: status
• timeCreated: string (date-time)
  Title: Time Created

  Read Only: true

  The date and time when the integration instance was created.
• timeUpdated: string (date-time)
  Title: Time Updated

  Read Only: true

  The date and time when the integration instance record was updated.
• updatedBy: string
  Title: Updated By

  Read Only: true

  The user who updated the integration instance record.

{
    "type":"object",
    "properties":{
        "integrationInstanceId":{
            "type":"string",
            "format":"big-integer",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Integration Instance Identifier",
            "description":"The unique identifier of the integration instance."
        },
        "name":{
            "type":"string",
            "x-searchable":true,
            "title":"Integration Name",
            "description":"The name of the integration instance."
        },
        "description":{
            "type":"string",
            "nullable":true,
            "title":"Integration Description",
            "description":"The description of the integration instance."
        },
        "integrationInstanceNumber":{
            "type":"string",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Integration Instance Number",
            "description":"The public unique identifier of the integration instance."
        },
        "routineExecutionId":{
            "type":"string",
            "format":"big-integer",
            "x-searchable":true,
            "title":"Routine Execution Identifier",
            "description":"The execution identifier of the routine that created the integration instance."
        },
        "activeFlag":{
            "type":"boolean",
            "default":true,
            "nullable":true,
            "title":"Active Flag",
            "description":"Indicates whether the integration instance is active."
        },
        "status":{
            "allOf":[
                {
                    "type":"string",
                    "default":"DRAFT",
                    "nullable":true,
                    "x-searchable":true,
                    "title":"Status",
                    "description":"The status of the integration instance."
                },
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStatus_enum"
                }
            ]
        },
        "integrationPayload":{
            "type":"string",
            "format":"long-text",
            "nullable":true,
            "title":"Integration Payload",
            "description":"The payload for the integration."
        },
        "createdBy":{
            "type":"string",
            "readOnly":true,
            "title":"Created By",
            "description":"The user who created the integration instance record."
        },
        "timeCreated":{
            "type":"string",
            "format":"date-time",
            "readOnly":true,
            "title":"Time Created",
            "description":"The date and time when the integration instance was created."
        },
        "updatedBy":{
            "type":"string",
            "readOnly":true,
            "title":"Updated By",
            "description":"The user who updated the integration instance record."
        },
        "timeUpdated":{
            "type":"string",
            "format":"date-time",
            "x-sortable":true,
            "readOnly":true,
            "title":"Time Updated",
            "description":"The date and time when the integration instance record was updated."
        },
        "integrationMap":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationMapping_item"
                },
                {
                    "$ref":"#/components/schemas/__busObj_context"
                }
            ]
        }
    },
    "x-primaryKey":[
        "integrationInstanceId"
    ],
    "x-alternateKeys":{
        "altKey":[
            "integrationInstanceNumber"
        ]
    },
    "title":"Integration Instance",
    "x-hints":{
        "titlePlural":"Integration Instances"
    },
    "description":"Integration instances represent the details of specific records integrated between Sales and other Oracle applications, such as routine identifier, status, integration payload, and integration map identifier."
}

Nested Schema : __busObj_context

Type: object

Show Source

• $context: object $context
• $id: string

{
    "type":"object",
    "properties":{
        "$id":{
            "type":"string"
        },
        "$context":{
            "type":"object",
            "properties":{
                "etag":{
                    "type":"string"
                },
                "links":{
                    "type":"object",
                    "properties":{
                        "$self":{
                            "type":"object",
                            "properties":{
                                "href":{
                                    "type":"string"
                                }
                            }
                        }
                    },
                    "readOnly":true
                }
            }
        }
    }
}

Nested Schema : integrationInstances_item-response-allOf[2]

Type: object

Show Source

• integrationDetails: integrationInstances-integrationDetails

{
    "type":"object",
    "properties":{
        "integrationDetails":{
            "$ref":"#/components/schemas/integrationInstances-integrationDetails"
        }
    }
}

Nested Schema : integrationInstances_view-default_item-response-allOf[1]

Type: object

Show Source

• createdBy:
• integrationInstanceId:
• integrationMap: object integrationMap
• integrationPayload:
• name:
• routineExecutionId:
• status:
• timeCreated:
• timeUpdated:
• updatedBy:

{
    "type":"object",
    "properties":{
        "integrationInstanceId":{
        },
        "name":{
        },
        "routineExecutionId":{
        },
        "status":{
        },
        "integrationPayload":{
        },
        "createdBy":{
        },
        "timeCreated":{
        },
        "updatedBy":{
        },
        "timeUpdated":{
        },
        "integrationMap":{
            "type":"object",
            "properties":{
                "integrationMapNumber":{
                },
                "name":{
                },
                "sourceObject":{
                }
            }
        }
    }
}

Nested Schema : integrationMap

Match All

Show Source

• object Integration Map
  Title: Integration Map

  Integration maps describe the attribute mappings between objects in Sales and objects in other Oracle applications. The integration process uses these mappings to determine the attributes that need to be synchronized from Sales to the other applications.
• object __busObj_context

{
    "allOf":[
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationMapping_item"
        },
        {
            "$ref":"#/components/schemas/__busObj_context"
        }
    ]
}

Nested Schema : status

Match All

The status of the integration instance.

Show Source

• string
  Title: Status

  Default Value: DRAFT

  The status of the integration instance.
• string
  Allowed Values: [ "DRAFT", "IN_PROGRESS", "COMPLETE", "ERROR", "RETRY" ]

{
    "allOf":[
        {
            "type":"string",
            "default":"DRAFT",
            "nullable":true,
            "x-searchable":true,
            "title":"Status",
            "description":"The status of the integration instance."
        },
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStatus_enum"
        }
    ]
}

Nested Schema : Integration Map

Type: object

Title: Integration Map

Integration maps describe the attribute mappings between objects in Sales and objects in other Oracle applications. The integration process uses these mappings to determine the attributes that need to be synchronized from Sales to the other applications.

Show Source

• activeFlag: boolean
  Title: Active Flag

  Indicates that the integration map is active.
• createdBy: string
  Title: Created By

  Read Only: true

  The user who created the integration map record.
• description: string
  Title: Map Description

  The description of the integration map.
• integrationMapId: string (big-integer)
  Title: Integration Map Identifier

  The unique identifier of the integration map.
• integrationMapNumber: string
  Title: Integration Map Number

  The public unique identifier of the integration map.
• integrationSpec: string (long-text)
  Title: Map Transform Specification

  The transform specifications for the integration map.
• lockedFlag: boolean
  Title: Locked Flag

  Indicates that the integration map is locked and can't be edited or cloned by a user.
• name: string
  Title: Map Name

  The name of the integration map.
• seededFlag: boolean
  Title: Seeded Flag

  Indicates whether the integration map was seeded by Oracle.
• sourceApplication: string
  Title: Source Application

  Read Only: true

  The source application for the integration.
• sourceObject: string
  Title: Source Object

  The source object of the integration.
• timeCreated: string (date-time)
  Title: Time Created

  Read Only: true

  The date and time when the integration map was created.
• timeUpdated: string (date-time)
  Title: Time Updated

  Read Only: true

  The date and time when the integration map was last updated.
• updatedBy: string
  Title: Updated By

  Read Only: true

  The user who last updated the integration map record.

{
    "type":"object",
    "properties":{
        "integrationMapId":{
            "type":"string",
            "format":"big-integer",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Integration Map Identifier",
            "description":"The unique identifier of the integration map."
        },
        "name":{
            "type":"string",
            "title":"Map Name",
            "description":"The name of the integration map."
        },
        "description":{
            "type":"string",
            "nullable":true,
            "title":"Map Description",
            "description":"The description of the integration map."
        },
        "integrationMapNumber":{
            "type":"string",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Integration Map Number",
            "description":"The public unique identifier of the integration map."
        },
        "sourceApplication":{
            "type":"string",
            "nullable":true,
            "readOnly":true,
            "title":"Source Application",
            "description":"The source application for the integration."
        },
        "sourceObject":{
            "type":"string",
            "x-searchable":true,
            "title":"Source Object",
            "description":"The source object of the integration."
        },
        "seededFlag":{
            "type":"boolean",
            "x-searchable":true,
            "title":"Seeded Flag",
            "description":"Indicates whether the integration map was seeded by Oracle."
        },
        "timeCreated":{
            "type":"string",
            "format":"date-time",
            "readOnly":true,
            "title":"Time Created",
            "description":"The date and time when the integration map was created."
        },
        "createdBy":{
            "type":"string",
            "readOnly":true,
            "title":"Created By",
            "description":"The user who created the integration map record."
        },
        "timeUpdated":{
            "type":"string",
            "format":"date-time",
            "x-sortable":true,
            "readOnly":true,
            "title":"Time Updated",
            "description":"The date and time when the integration map was last updated."
        },
        "updatedBy":{
            "type":"string",
            "readOnly":true,
            "title":"Updated By",
            "description":"The user who last updated the integration map record."
        },
        "integrationSpec":{
            "type":"string",
            "format":"long-text",
            "nullable":true,
            "title":"Map Transform Specification",
            "description":"The transform specifications for the integration map."
        },
        "activeFlag":{
            "type":"boolean",
            "title":"Active Flag",
            "description":"Indicates that the integration map is active."
        },
        "lockedFlag":{
            "type":"boolean",
            "title":"Locked Flag",
            "description":"Indicates that the integration map is locked and can't be edited or cloned by a user."
        }
    },
    "x-primaryKey":[
        "integrationMapId"
    ],
    "x-alternateKeys":{
        "altKey":[
            "integrationMapNumber"
        ]
    },
    "title":"Integration Map",
    "x-hints":{
        "titlePlural":"Integration Maps"
    },
    "description":"Integration maps describe the attribute mappings between objects in Sales and objects in other Oracle applications. The integration process uses these mappings to determine the attributes that need to be synchronized from Sales to the other applications."
}

Nested Schema : $context

Type: object

Show Source

• etag: string
• links: object links
  Read Only: true

{
    "type":"object",
    "properties":{
        "etag":{
            "type":"string"
        },
        "links":{
            "type":"object",
            "properties":{
                "$self":{
                    "type":"object",
                    "properties":{
                        "href":{
                            "type":"string"
                        }
                    }
                }
            },
            "readOnly":true
        }
    }
}

Nested Schema : links

Type: object

Read Only: true

Show Source

• $self: object $self

{
    "type":"object",
    "properties":{
        "$self":{
            "type":"object",
            "properties":{
                "href":{
                    "type":"string"
                }
            }
        }
    },
    "readOnly":true
}

Nested Schema : $self

Type: object

Show Source

• href: string

{
    "type":"object",
    "properties":{
        "href":{
            "type":"string"
        }
    }
}

Nested Schema : integrationInstances-integrationDetails

Match All

Show Source

• object __collection_context
• object integrationInstances-integrationDetails-allOf[1]

{
    "allOf":[
        {
            "$ref":"#/components/schemas/__collection_context"
        },
        {
            "type":"object",
            "properties":{
                "items":{
                    "type":"array",
                    "items":{
                        "$ref":"#/components/schemas/integrationInstances-integrationDetails_item-response"
                    }
                }
            }
        }
    ]
}

Nested Schema : integrationInstances-integrationDetails-allOf[1]

Type: object

Show Source

• items: array items

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/integrationInstances-integrationDetails_item-response"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: integrationInstances-integrationDetails_item-response

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/integrationInstances-integrationDetails_item-response"
    }
}

Nested Schema : integrationInstances-integrationDetails_item-response

Match All

Show Source

• object Instance Detail
  Title: Instance Detail

  An integration instance details stores the various stages of an integration instance and their statuses.
• object __busObj_context

{
    "allOf":[
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstanceDetail_item"
        },
        {
            "$ref":"#/components/schemas/__busObj_context"
        }
    ]
}

Nested Schema : Instance Detail

Type: object

Title: Instance Detail

An integration instance details stores the various stages of an integration instance and their statuses.

Show Source

• childIntegrationDetails: childIntegrationDetails
• createdBy: string
  Title: Created By

  Read Only: true

  The user who created the integration instance detail record.
• inboundPayload: string (long-text)
  Title: Inbound Payload

  The inbound payload for the integration instance detail.
• instanceDetailId: string (big-integer)
  Title: Request Detail Identifier

  The unique identifier of the detail record within an integration instance.
• integration: integration
• integrationInstanceId: string (big-integer)
  Title: Integration Instance Identifier

  The unique identifier of the integration instance.
• integrationLevel: integer (int32)
  Title: Integration Level

  The level of the integration instance detail. This applies to integrations with substeps.
• outboundPayload: string (long-text)
  Title: Outbound Payload

  The outbound payload for the integration instance detail.
• stage: stage
• status: status
• step: string
  Title: Substep

  The name of the substep.
• timeCreated: string (date-time)
  Title: Time Created

  Read Only: true

  The date and time of the creation of the integration instance detail record.
• timeUpdated: string (date-time)
  Title: Time Updated

  Read Only: true

  The date and time when the integration instance detail record was updated.
• updatedBy: string
  Title: Updated By

  Read Only: true

  The user who last updated the integration instance detail record.

{
    "type":"object",
    "properties":{
        "instanceDetailId":{
            "type":"string",
            "format":"big-integer",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Request Detail Identifier",
            "description":"The unique identifier of the detail record within an integration instance."
        },
        "integrationInstanceId":{
            "type":"string",
            "format":"big-integer",
            "x-searchable":true,
            "x-sortable":true,
            "title":"Integration Instance Identifier",
            "description":"The unique identifier of the integration instance."
        },
        "stage":{
            "allOf":[
                {
                    "type":"string",
                    "nullable":true,
                    "x-searchable":true,
                    "x-sortable":true,
                    "title":"Stage",
                    "description":"The stage of the integration instance detail."
                },
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStages_enum"
                }
            ]
        },
        "status":{
            "allOf":[
                {
                    "type":"string",
                    "nullable":true,
                    "title":"Status",
                    "description":"The status of the integration instance detail."
                },
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStatus_enum"
                }
            ]
        },
        "step":{
            "type":"string",
            "nullable":true,
            "title":"Substep",
            "description":"The name of the substep."
        },
        "integrationLevel":{
            "type":"integer",
            "format":"int32",
            "nullable":true,
            "title":"Integration Level",
            "description":"The level of the integration instance detail. This applies to integrations with substeps."
        },
        "inboundPayload":{
            "type":"string",
            "format":"long-text",
            "nullable":true,
            "title":"Inbound Payload",
            "description":"The inbound payload for the integration instance detail."
        },
        "outboundPayload":{
            "type":"string",
            "format":"long-text",
            "nullable":true,
            "title":"Outbound Payload",
            "description":"The outbound payload for the integration instance detail."
        },
        "createdBy":{
            "type":"string",
            "readOnly":true,
            "title":"Created By",
            "description":"The user who created the integration instance detail record."
        },
        "timeCreated":{
            "type":"string",
            "format":"date-time",
            "x-sortable":true,
            "readOnly":true,
            "title":"Time Created",
            "description":"The date and time of the creation of the integration instance detail record."
        },
        "updatedBy":{
            "type":"string",
            "readOnly":true,
            "title":"Updated By",
            "description":"The user who last updated the integration instance detail record."
        },
        "timeUpdated":{
            "type":"string",
            "format":"date-time",
            "readOnly":true,
            "title":"Time Updated",
            "description":"The date and time when the integration instance detail record was updated."
        },
        "integration":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstance_item"
                },
                {
                    "$ref":"#/components/schemas/__busObj_context"
                }
            ]
        },
        "childIntegrationDetails":{
            "allOf":[
                {
                    "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstanceDetail_item"
                },
                {
                    "$ref":"#/components/schemas/__busObj_context"
                }
            ]
        }
    },
    "x-primaryKey":[
        "instanceDetailId"
    ],
    "title":"Instance Detail",
    "x-hints":{
        "titlePlural":"Instance Details"
    },
    "description":"An integration instance details stores the various stages of an integration instance and their statuses."
}

Nested Schema : childIntegrationDetails

Match All

Show Source

• object Instance Detail
  Title: Instance Detail

  An integration instance details stores the various stages of an integration instance and their statuses.
• object __busObj_context

{
    "allOf":[
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstanceDetail_item"
        },
        {
            "$ref":"#/components/schemas/__busObj_context"
        }
    ]
}

Nested Schema : integration

Match All

Show Source

• object Integration Instance
  Title: Integration Instance

  Integration instances represent the details of specific records integrated between Sales and other Oracle applications, such as routine identifier, status, integration payload, and integration map identifier.
• object __busObj_context

{
    "allOf":[
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.IntegrationInstance_item"
        },
        {
            "$ref":"#/components/schemas/__busObj_context"
        }
    ]
}

Nested Schema : stage

Match All

The stage of the integration instance detail.

Show Source

• string
  Title: Stage

  The stage of the integration instance detail.
• string
  Allowed Values: [ "ENRICH", "TRANSFORM", "ACTIVATE", "BEFORE_HANDLER", "AFTER_HANDLER" ]

{
    "allOf":[
        {
            "type":"string",
            "nullable":true,
            "x-searchable":true,
            "x-sortable":true,
            "title":"Stage",
            "description":"The stage of the integration instance detail."
        },
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStages_enum"
        }
    ]
}

Nested Schema : status

Match All

The status of the integration instance detail.

Show Source

• string
  Title: Status

  The status of the integration instance detail.
• string
  Allowed Values: [ "DRAFT", "IN_PROGRESS", "COMPLETE", "ERROR", "RETRY" ]

{
    "allOf":[
        {
            "type":"string",
            "nullable":true,
            "title":"Status",
            "description":"The status of the integration instance detail."
        },
        {
            "$ref":"#/components/schemas/oraCxSalesCommonIntegration.integrationStatus_enum"
        }
    ]
}

Nested Schema : integrationMap

Type: object

Show Source

• integrationMapNumber:
• name:
• sourceObject:

{
    "type":"object",
    "properties":{
        "integrationMapNumber":{
        },
        "name":{
        },
        "sourceObject":{
        }
    }
}

Back to Top