In this article
Overview
You can use Dynamics 365 Finance and SCM Create Snap to create new users in the Dynamics 365 Finance and SCM application for a specific entity.
Snap Type
The Dynamics 365 Finance and SCM Create Snap is a Write-type Snap that creates a user in the application.
Prerequisites
A valid Finance and SCM Access Token Account and OAuth2 Account with the required permissions.
You must define and know the mandatory attributes for different entities in the Dynamics 365 Finance and Operations application to create records.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
The Snap does not always fail when you pass data for existing primary keys.
The Snap does not support certain Unicode, Special, and UTF-8 byte characters due to the API limitation.
Based on your environment configurations, when the Batch size increases, the Snap might fail because of an API limitation and displays the following error message:
Number of requests exceeded the limit of 6000 over the time window of 300 seconds
Refer to Service protection API limits - Finance & Operations for more information.
Workaround: You must decrease the batch size and retry.The Snap fails and updates the error view with the error message from API when you pass invalid values for a mandatory field.
Known Issues
The Microsoft Dynamics 365 Finance and SCM Create Snap displays the following errors when we run 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 also decrease the batch size, along with the default retry properties.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document
|
|
| Requires user data as a JSON document. |
Output | Document
|
|
| Writes the new user information for an entity. |
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 Finance and SCM Create | 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.
| |
Entity*
Default Value: N/A | String/Expression | Specify the OData entity object. | |
Batch size
Default Value: 1 | Integer/Expression | Specify the batch size to create a number of users in a batch. | |
Timeout (seconds)
Default Value: 300 | Integer | Specify the timeout to determine whether the connection is alive and also the timeout when waiting for response through a socket. | |
Number of retries
Default Value: 0 | Integer/Expression | Specify the maximum number of retries to be made to receive a response. The number of retries are disabled if the value is 0. | |
Retry interval (seconds)
Default Value: 1 | Integer/Expression | Specify in seconds, the time period between retry attempts. | |
HTTP header | Use this field set to define the HTTP key-value pairs to pass to the Dynamics 365 Finance and SCM 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: Validate & Execute | Dropdown list | Select one of the following three Snap execution modes:
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
| More than 6000 requests were made in 300 seconds. | You must decrease the batch size and retry. |
| Too many requests sent to Dynamics 365 Finance and SCM endpoint. | All Snaps related to the Microsoft Dynamics 365 Finance and SCM Snap include |
REST API service endpoint returned error result: status code = 400 | Reason phrase = BAD REQUEST, refer to the error_entity field in the error view document for more details. You typically receive this message when:
| Please check the values of Snap properties. Specifically:
|
Error 500
| Client secret is expired. | Generate new Client secret. |
Error 401 | Token is invalid | Provide a valid token and reauthorize the account. |
Examples
Updating a New Attribute in the Existing Records
This example pipeline demonstrates how to add a record in the Finance and Operations endpoint:
Step 1: Configure the attributes you want to pass in the JSON Generator Snap under Edit JSON.
Step 2: Configure the Mapper Snap with the attributes you want to pass to create records.
Step 3: Select the entity in the Entity field for which you passed the values.
Step 4: Validate the Snap. On validation, the Dynamics 365 Finance and SCM Create Snap creates the record at the endpoint.