PLM TC Query

 

In this article

Overview

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

Snap Type

The PLM TC 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

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 take 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 (): Indicates a dynamically populated list based on the configuration.

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

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

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

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

Field Name

Field Type

Field Dependency

Description

Field Name

Field Type

Field Dependency

Description

Label*

 

Default Value: PLM TC Query
Example: TC 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 you want in the query output.

Query Criteria

Specify the name and the value of the query you want the Snap to execute from Teamcenter. Each attribute must be specified as a new row. Click to add a row.

Name*

Default Value: N/A
Example: item_id

String

None

Specify the name of the query.

Value*

Default Value: N/A
Example: del_148

String

None

Specify the value of the query.

Wrap Result*

Checkbox

None

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

Configure Output

Default Value: deselected

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 expanded attributes in the input document.

Expand Attributes

Specify the attributes you want the Snap to fetch from Teamcenter. Each attribute must be specified as a new row. Click to add a row.

Name*

Default Value: None.
Example: Item_response

String

Configure Output

 

Specify the name of the attribute.

Snap Execution

Default Value: Execute 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 complete execution of the Snap (unlimited records) during pipeline runtime.

  • Execute only: Performs complete execution of the Snap during pipeline execution without generating preview data.

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

Troubleshooting

Snap Pack History


Related Content

Â