Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Name

Field Type

Field Dependency

Description

Label*

Default ValueDynamics 365 Finance and SCM Bulk Import
ExampleFinance and SCM Bulk Import

String

N/A

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.

Integration type

Default ValueDMF package API
Example: Recurring integrations API

Dropdown list

N/A

Choose the type of import API. The available options are:

  • DMF package API: Data Management Framework's package (REST API) enables you to integrate data using data packages.

  • Recurring integrations API: Enables the exchange of data packages or files between finance and operations and any third-party application or service.

Unique file name

Default Value: None
Example: Import_test

String/Expression

Appears when Integration type is -

DMF package API.

Specify a unique file name that is used to track blob IDs.

If you do not provide an input for this field, the Snap generates a unique file name.

Definition group ID

Default Value: None
Example: user_group_import

String/Expression

Appears when Integration type is -

DMF package API.

Specify the name of the import data project.

This field is mandatory when the Integration type is DMF package API.

Execution ID

Default Value: None
Example: Import_Tabseparated-2023-10-13T08:37:42-669A3F02B6CC424BA17A7C070DD99772

String/Expression

Appears when Integration type is -

DMF package API.

Specify the ID to use for the bulk import job.

  • This field is referred to as the Job ID in the Finance and SCM application.

  • If this field is left empty, a new execution ID is created.

Activity ID

Default Value: None
Example:

{69EC303C-2616-464D-92BF-6AC1EFF7A14D}

String/Expression

Appears when Integration type is -

Recurring integrations API.

Specify the activity ID. Learn more about how to obtain the activity ID: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/recurring-integrations#manage-recurring-data-jobs

This field is mandatory when the Integration typeis Recurring integrations API.

Entity

Default Value: None
Example: User groups

String/Expression

Appears when Integration type is -

Recurring integrations API.

Specify the OData entity object from which you must import the data.

Legal entity

Default Value: None
Example: dat

String/Expression/Suggestion

N/A

Specify the legal entity for data import.

Composite entity

Default ValueDeselected

Checkbox

Appears when Integration type is -

DMF package API.

Select this checkbox when you use a composite entity for the import.

Job status check interval (seconds)

Default Value5
Example: 10

Integer/Expression

N/A

Specify the amount of time between job status check requests.

Internally the Snap checks the job status at least 100 times, till it obtains the Succeeded status. Therefore, ensure to adjust the status check interval for long-running jobs.

Timeout (seconds)

Default Value60
Example: 100

Integer/Expression

N/A

Specify the connection and response timeout for the requests made to the server.

Number of retries

Default Value0
Example: 5

Integer/Expression

N/A

Specify the maximum number of retry attempts between failures.

If the value for this field is 0, retries are disabled.

Retry interval (seconds)

Default Value1
Example: 10

Integer/Expression

N/A

Specify the amount of time between retry attempts.

Snap Execution

Default Value
Example: Validate & Execute

Dropdown list

N/A

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 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.

...

Error

Reason

Resolution

Too many Requests - 429

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

All Dynamics F&SCM Snaps 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.

Error 500

The Client Secret has expired.

Generate a new Client Secret.

Error 401

The token is invalid.

Provide a valid token and reauthorize the account.

Examples

Import Data From a .zip File to the Finance and SCM

...

application

This example demonstrates how we can use the Finance and SCM Bulk Import Snap to import data from a zip file to the application.

...