Dynamics 365 Business Central Delete

Overview

You can use the Dynamics 365 Business Central Delete Snap to delete the user data from a specific entity.

The Business Central Delete Snap does not support upstream values for fields such as Company, Entity, etc.

Dynamics 365 Business Central Delete_Overview.png

Snap Type

The Microsoft Business Central Delete Snap is a Write-type Snap.

Prerequisites

A valid Business Central Access Token Account or an OAuth2 Account with the required permissions.

Support for Ultra Pipelines

Works in Ultra Pipelines

Limitations

  • The Business Central Delete Snap supports a maximum Batch size of 100.

  • The Business Central Create, Update, and Delete Snaps do not support the respective operations for a few entities, such as Account, and display an exception when creating, updating, or deleting operations. Learn more about the API limitations: API documentation for Business Central.

Known Issues

  • The Microsoft Dynamics 365 Business Central Delete Snap displays the following errors when you run the batch process with the error view enabled.

    • 500 ( Internal Server Error)

    • Socket timeout error

    • Read timed out error

    Workaround: Increase the Timeout value to 500 or more and decrease the batch size while keeping the default retry properties.

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: 1

  • Mapper

Requires the data that you want to delete.

Output

Document

 

  • Min: 1

  • Max: 1

  • Mapper

  • Union

  • Copy

The status message of the deleted data.

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 (): Indicates a list that is dynamically populated 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 field set.

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

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

Field Name

Field Type

Description

Field Name

Field Type

Description

Label*

 

Default ValueDynamics 365 Business Central Delete
ExampleBusiness Central Delete

String

Specify a unique 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.

 

Company

Default Value: N/A
ExampleMy Company

String/Expression/Suggestion

Specify the company registered with the Business Central application.

Entity*

 

Default Value: N/A
Example: employees

String/Expression

Specify the OData entity object.

Primary key*

Use this field set to specify the primary key that uniqely identifies the rows.

Key

 

Default Value: N/A
ExampleId

String/Expression

Specify or select the primary key from which you want to delete the record.

  • More than one primary key can exist for an Entity.

  • Ensure that you provide key-value pairs for the primary keys, which are associated with a specific entity. If you do not, the Snap fails. For example, if you have four Primary keys in an entity, then you must pass the value for every field that you want to delete. If you use only one of the primary keys, the Snap fails.

Value

 

Default Value: N/A
Example2998d72e-fac9-ed11-94cc-000d3a220b2f

String/Expression

Specify the value of the key for which you want to delete the record.

Batch type

Default ValueStop-On-Error
Example: Transactional