$customHeader
Skip to end of banner
Go to start of banner

Dynamics 365 Finance and SCM Create

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 41 Current »

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

 

  • Min: 0

  • Max: 1

  • Mapper

Requires user data as a JSON document.

Output

Document

 

  • Min: 1

  • Max: 1

  • Mapper

  • Copy

  • Union

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:

  • 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 field set.

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

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

Field Name

Field Type

Description

Label*

 

Default ValueDynamics 365 Finance and SCM Create
ExampleF & 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
Example: People

String/Expression

Specify the OData entity object.

Cross company

Default ValueDeselected

Checkbox

Select this checkbox to create record (apart from default company) for an entity.

Batch size

 

Default Value1
Example: 100

Integer/Expression

Specify the batch size to create a number of users in a batch.

Timeout (seconds)

 

Default Value300
Example: 100

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 Value0
Example5

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 Value1
Example5

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
ExampleAccept

String/Expression

Specify the key for the HTTP header.

Value

 

Default Value: N/A
Example

application/json;odata.metadata=full

String/Expression

Specify the value for the HTTP header.

Snap Execution

 

Default ValueValidate & Execute
Example: Execute only

Dropdown list

Select one of the following three Snap execution modes:

  • 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

Reason

Resolution

Number of requests exceeded the limit of 6000 over the time window of 300 seconds

More than 6000 requests were made in 300 seconds.

You must decrease the batch size and retry.

Too many Requests - 429

Too many requests sent to Dynamics 365 Finance and SCM endpoint.

All Snaps related to the Microsoft Dynamics 365 Finance and SCM Snap include retry-after with <number of seconds> in the response header and automatically retry when they encounter a status 429 error. Wait for the retry to succeed.

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:

  • The value in the HTTP entity field is structured as an expression; but the expression toggle is off.

  • The value in the (single- or multiple-file-upload) File Key fields is inaccurate or does not contain expressions although the Expression toggle is enabled.

  • The value in the (single- or multiple-file-upload) File Name fields contains special characters, such as (&, ^, and %).

Please check the values of Snap properties. Specifically:

  • Check whether your HTTP entity entry requires expressions. Update Snap settings as appropriate.

  • Check the value in the (single- or multiple-file-upload) File Key fields.

  • Check the value in the (single- or multiple-file-upload) Filename to be used fields.

Error 500

{"http_status_code": 500, "response_map": {"error_list": [{"message": "Request to token endpoint Sign in to your account failed for account \"/Tenantidshared/Azure Sharepoint Account\" of type \"SharePoint Online Account\""}]}}

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:

Download this pipeline

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.

Downloads

  File Modified
You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.
No files shared here yet.
  • Drag and drop to upload or browse for files
  • Snap Pack History

     Click here to expand...

    Release

    Snap Pack Version

    Date

    Type

    Updates

    May 2024

    main26341

    Stable

    Updated and certified against the current SnapLogic Platform release.

    February 2024

    436patches26143

    Latest

    Fixed an issue with the Dynamics 365 Finance and SCM Bulk Export Snap that displayed the error message twice when:

    • Operation is Trigger Export

    • Definition group ID is incorrect

    • When error occurs  is Stop Pipeline Execution (Views tab)

    February 2024

    436patches25295

    Latest

    Fixed an issue with the recurring bulk import operation for the Recurring Integrations API integration type in the Dynamics 365 Finance and SCM Bulk Import Snap, which previously displayed an error at the preprocessing step intermittently.

    February 2024

    main25112

    Stable

    Updated and certified against the current SnapLogic Platform release.

    November 2023

    435patches24298

    Latest

    Added the following Snaps in the Microsoft Dynamics 365 Finance and SCM Snap Pack:

    November 2023

    main23721

    Stable

    Updated and certified against the current SnapLogic Platform release.

    August 2023

    434patches23466

    Latest

    Enhanced the Dynamics 365 Finance and SCM Read and Dynamics 365 Finance and SCM Search Snaps with the Error out on no results checkbox, which customizes the error view when no results are returned.

    August 2023

    434patches23129

    Latest

    • The Cross company checkbox is added to the Dynamics 365 Finance and SCM CreateUpdate, and Delete Snaps to ensure that the other company records are getting created, updated, and deleted.

    • Fixed an issue with the Microsoft Dynamics Finance and SCM Snaps that failed when the string values (filter criteria) are passed without quotes.

    • Fixed an issue with the Microsoft Dynamics Finance and SCM Snap that failed to execute after processing less number of records.

    August 2023

    434patches22601

    Latest

    August 2023

    main22460

    Stable

    Updated and certified against the current SnapLogic Platform rThe Cross company checkbox is added to the Dynamics 365 Finance and SCM CreateUpdate, and Delete Snaps to ensure that the other company records are getting created, updated, and deleted.

    May 2023

    main21015

    Stable

    Upgraded with the latest SnapLogic platform release.

    February 2023

    432patches20657

    Latest

    Added the Dynamics 365 Finance and SCM Create, Update, and Delete Snaps to the Microsoft Dynamics 365 Finance and Supply Chain Management Snap Pack.

    February 2023

    432patches20035

    Latest

    Introduced the Microsoft Dynamics 365 Finance and SCM Snap Pack. This Snap Pack contains the following Snaps and accounts:


    Related Content

    • No labels