Dynamics 365 Business Central Update
Overview
You can use the Dynamics 365 Business Central Update Snap to update the user records for an entity.
The Business Central Update Snap does not allow upstream values for any fields (Company, Entity, etc.).
Snap Type
The Dynamics 365 Business Central Update Snap is a Write-type Snap.
Prerequisites
A valid Business Central Access Token Account or OAuth2 Account with the required permissions.
Support for Ultra Pipelines
Works in Ultra Pipelines.Â
Limitations
The Business Central Update 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 Company field in the Business Central Update is optional for a few entities, such as Subscriptions, and it is mandatory for the remaining entities. Therefore, if the field is left blank, the Snap displays the following error:
Workaround: Specify the Company name for mandatory entities.
The Microsoft Dynamics 365 Business Central Update 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 |
---|---|---|---|---|
Input | Document  |
|
| Requires the data that you need to update. |
Output | Document  |
|
| The data is written to the endpoint. |
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:
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 | |
---|---|---|---|
Label* Â Default Value:Â Dynamics 365 Business Central Update | 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 | String/Expression/Suggestion | Specify the company registered with the Business Central application. | |
Entity* Â Default Value:Â N/A. | String/Expression/Suggestion | 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 | String/Expression/Suggestion | Specify or select the primary key from which you want to update the record.
| |
Value  Default Value: N/A | String/Expression | Specify the value of the key for which you want to update the record. | |
Batch type Default Value:Â Stop-On-Error | Dropdown list | Choose the operation you want for batching, which is applicable only when the Batch size is more than 1:
| |
Batch size  Default Value: 100 | Integer/Expression | Specify the batch size to update the records in the specified batch in the application. | |
Timeout (seconds) Â Default Value:Â 60 | Integer/Expression | Specify the timeout to determine whether the connection is alive and also specify the timeout when waiting for a response through the socket. | |
Number of retries  Default Value: 0 | Integer/Expression | Specify the maximum number of attempts to be made to receive a response. | |
Retry interval (seconds) Â Default Value:Â 1 | Integer/Expression | Specify the amount of time in seconds between retry attempts. | |
HTTP header | Use this field set to define the HTTP key-value pairs to pass to the Dynamics 365 Business Central instance. | ||
Key  Default Value: N/A | String/Expression | Specify the key for the HTTP header. | |
Value  Default Value: N/A application/json;odata.metadata=full | String/Expression | Specify the value for the HTTP header. | |
Snap Execution  Default Value: | Dropdown list | Select one of the following three modes in which the Snap executes:
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
Number of requests exceeded the limit of 6000 over the time window of 300 seconds. | Requests exceeded the limit of 6000 over the time window of 300 seconds. | Decrease the batch size and retry. Learn more about the error messages: Service protection API limits. |
Too many Requests - 429. | Too many requests were sent to the Business Central endpoint. | The Snaps related to Microsoft Business Central, include |
Examples
Refer to this example to understand the function of Business Central Update Snap.
Snap Pack History
Related Content
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.