---
title: "Use Azure to bulk load product data"
slug: "use-azure-to-bulk-load-product-data"
abstract: "Perform a bulk import of Microsoft D365 product entities from Dataverse manually."
---
# 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](https://portal.azure.com/).
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](https://portal.azure.com/#blade/HubsExtension/BrowseResource/resourceType/Microsoft.Web%2Fsites/kind/functionapp).
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*.

    ```json
    {
       "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.

        ```json
        {
          "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.