Skip to end of banner
Go to start of banner

Teamcenter Query

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

In this article

Overview

You can use this Snap to execute the saved queries in Teamcenter. Teamcenter Query is based on the Teamcenter persistence data model.

Snap Type

The Teamcenter Query Snap is a Read-type Snap that executes the saved queries in the Teamcenter.

Prerequisites

  • Valid client ID.

  • A valid account with the required permissions.

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 0

  • N/A

Requires query key, query criteria and the number of items to be retrieved from Teamcenter.

Output

Document

  • Min: 1

  • Max: 1

  • Snowflake Insert

  • Mapper

  • Teamcenter Info

The output of the executed query.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ((blue star)): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ((blue star) ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( (blue star) ): Indicates that you can add fields in the fieldset.

  • Remove icon ( (blue star)): Indicates that you can remove fields from the fieldset.

  • Upload icon ((blue star) ): Indicates that you can upload files.

Field Name

Field Type

Field Dependency

Description

Label*

Default ValueTeamcenter Query
ExampleTC query 1

String

None

The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Query Key*

Default Value: N/A
Example: ade_345

String

None

Specify the key name of the query that you want the Snap to execute from Teamcenter.

Max Items*

Default Value: 0
Example: 10

Integer

None

Specify the maximum number of results that you want in the output of the query.

Query Criteria

Specify the Key name and the Key Value of the query that you want the Snap to execute from Teamcenter. Each atribute must be specified as a new row. Click (blue star) to add a row.

Key*

Default ValueN/A
Exampleitem_id

String

None

Specify the name of the query.

Value*

Default ValueN/A
Exampledel_148

String

None

Specify the value of the query.

Wrap Result*

Checkbox

None

Select this checkbox if you want the Snap to return the single document containing the result instead of multiple documents.

Configure Output

Default Valuedeselected

Checkbox

None

Select this checkbox if you want the Snap to specify the configuration of the Teamcenter properties in the output.

Type

 

Default Value: N/A
Example: Diameter

String/Expression

Configure Output

Specify the name of the Teamcenter type.

Expand attributes path

Default Value: N/A
Example: attributes1 → item_response

String/Expression

Configure Output

Specify the path of the expand attributes in the input document.

Expand Attributes

Specify the attributes you want the Snap to fetch from Teamcenter. Each atribute must be specified as a new row. Click (blue star) to add a row.

Name*

Default Value: None.
ExampleItem_response

String

Configure Output

Specify the name of the attribute.

Snap Execution

Default ValueExecute only
Example: Validate & Execute

Dropdown list

None

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Troubleshooting

Error rendering macro 'excerpt-include' : No link could be created for 'Teamcenter BOM Structure Add'.

Snap Pack History

 Click here to expand...
Error rendering macro 'excerpt-include' : No link could be created for 'Teamcenter Snap Pack'.

Related Content

  • No labels