Use Azure to bulk load product data

The connector allows you to manually bulk import Microsoft D365 product entities from Dataverse. You do this by executing the FullSync function in the Microsoft Azure application using the Azure portal.

To use Azure to bulk load product data:

  1. Go to your Microsoft Azure portal.

  2. Locate your connector's function app by searching for the function app name in the search bar or selecting it from your available function apps.

  3. Click your function app to open the Function App overview.

  4. In the left pane, under the Functions section, click Functions.

  5. Click FullSync to open the function overview.

  6. In the left pane, under the Developer section, click Code + Test.

  7. Click the Test/Run tab.

    Note

    You can also execute the FullSync function using Postman, or another external application, with the Azure function URL and a function key.

  8. Construct the body of the FullSync request. The FullSync function synchronizes entities by type and date. Setting any of these properties to true enables the following entity types and will synchronize in the following order:

    • SyncDimensions synchronizes color, style, and size product dimensions.

    • SyncProducts synchronizes products and product masters.

    • SyncProductVariants synchronizes product variants.

    • SyncTranslations synchronizes translations. The SyncFrom property synchronizes entities modified after the defined date. You can choose to enter a more recent date to limit the amount of data to be synchronized.

    Important

    If this is the first time you are manually loading data, make sure to enable SyncDimensions.

    RequestResponse
    {
       "SyncDimensions": false,
       "SyncProducts": false,
       "SyncProductVariants": false,
       "SyncTranslations": false,
       "SyncFrom":"2000-01-01T00:00:01.000"
    }
  9. In the dialog box, do the following:

    • For HTTP method, select POST.

    • For Key, select default (Function key).

    • For Body, input the settings to execute for FullSync as shown in the following example.

      RequestResponse
      {
        "SyncDimensions": true,
        "SyncProducts": false,
        "SyncProductVariants": false,
        "SyncTranslations": false,
        "SyncFrom":"2021-11-05T00:00:01.000"
      }
  10. Click Run. Once the operation is complete, the dialog box opens the Output tab and displays the system response. You should now be able to view synchronized product data within Content Hub.

Do you have some feedback for us?

If you have suggestions for improving this article,