Salesforce

D365 Finance Operations - XML (Magic xpi 4.14)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

D365 Finance Operations - XML (Magic xpi 4.14)

To configure the connector, double-click or right-click on the step and select Configuration from the context menu to open the D365 Finance Operations Configuration dialog box.

This dialog box contains the following fields:

Property

Description

Connection

Resource Name

The name of the resource that you selected in the connector's Properties pane. The resources are defined in the Settings dialog box's Resources section.

Operation

Entity

Click to open the Select an Entity Set list. Select the entity that the operation will be performed on.

Method

The method that will be performed on the selected entity.

Select one of the following methods from the drop-down list:

  • Get

  • Put

  • Post

  • Delete

  • Patch

Certain entities may not support all the above listed methods and the connector has no way of knowing it in advance.

Therefore you will face runtime errors for combinations that the server/service doesn't support.

Endpoint URL

The D365 Finance Operations resource URL, and the selected entities and parameters. This field is parkable and non-editable.

Parameters

The D365 Finance Operations query parameters.

There are two ways to enter the required query. You can either click to open the Expression Editor and enter your query manually, or you can click to open the D365 Finance Operations Query Wizard. After creating a query using the wizard, you can also manually change the query in this property.

This is available only if you selected Get in the Method parameter (above).

If the Top value is provided here, it will be overwritten by the value in Max Pages (below).

Paginations

Max Records

Define the maximum number of records to be returned as part of the D365 Finance Operations request.

In case the user enters the value as 0, it will be set back to the default value of 5000.

Page Size

Enter the page size here.

Each page contains a specific number of records and the D365 Finance Operations server handles it as a separate request, with its own timeout.

An increase in the Page Size may result in increase in the memory consumption on the Business Central Server or client. For optimum performance, set the value of the Page Size based upon the available memory.

The supported range is from 50 to 10000. Recommended and default value is 500.

Output

Store Result In

Defines where you want to store the resulting XML file. Select one of the following from the drop-down list:

  • Variable: Select a variable to hold the entity data that is returned by D365 Finance Operations.
    Click to open the Variables List. Select a variable where this information is to be stored (the default is C.UserBlob).

  • File: Select a file to hold the entity data that is returned by D365 Finance Operations.
    Click to open the Expression Editor, or click and enter the file path where this information is to be stored.

Operation Success

This field lets you easily determine if the data entity was successfully located in D365 Finance Operations. Select one of the following from the drop-down list:

  • None: Select this option if you do not want to save the connector’s success or failure status.

  • Variable: Click to open the Variables List. Select the variable where you want to store the connector's success or failure status.

Refresh Schema

Click the Refresh Schema button to create a schema for the D365 Finance Operations entity selected. The schema will be generated based upon the D365 Finance Operations metadata.xml generated on the resource.

If the schema already exists, the current schema will be overwritten and synced with the D365 Finance Operations metadata. If the schema does not exist, it will be created as per the metadata.xml of the D365 Finance Operations resource. The configuration information will be saved, and the Data Mapper window will be opened with the selected schema as the Destination. This is applicable for all operations other than the Get Operations.

For any updates in metadata at server side, first execute the Get Metadata operation before clicking the Refresh Schema button.

The Dynamics 365 Finance & Operations server schema contains some fields with values as 0 and 1 in the enumeration restrictions, but the server returns the resultant XML with values as Yes and No instead. Due to this, the resultant XML does not get validated against the schema.

(Since version: 4.13.2)

Reference
Attachment 
Attachment