Skip to main content

Result of the nuvo importer

General​

DescriptionThe onResults provides the imported data as an array object containing a JSON object for each submitted row. The keys of each JSON object correspond to those defined in the target data model, and the values are taken from the review step. The data types of these values can be strings, integers, floats, or booleans, as specified in the columnType of each target data model column.
With this callback function, you can process, transform and send the returned data to your preferred API endpoint. You can find a code example showing the best practice for handling asynchronous server calls inside the onResults function here.
Run EventThe execution of this function occurs after the user clicks the "Complete import" button inside the review step
Parameterresults: This provides you with a JSON array, each object representing a submitted row, keyed and valued according to your schema and validations
errors: This provides a JSON array, each object representing a row containing at least one error message when the user submits the data
complete: Calling this function triggers the success/error modal that is displayed to the user at the end of the import
logs: After the mapping step is completed as well as after the import process concludes, you have access to logs containing details about mappings and columns used during the import.
  • columns - an object with addedColumns and addedOptions keys. If allowCustomColumns is set to true and new columns are added to the schema, the addedColumns field will be present in the logs and will display an array of added columns. If allowCustomOptions is set to true and new options are added to the columns, the addedOptions field will be present in the logs and will display an array of added options with the corresponding column.
  • mappings - This comprises an array of objects, with each object containing a sourceColumn and a targetColumn. It provides a summary of the mappings executed during the import process.
    Advanced
info

Outside of your testing phase, onResults only returns the first 100 rows when using the dev license key. Please reach out to [email protected] for more information.

ExampleIn the example below, you can see what the data of results, errors and logs can look like
[
  {
    customer_code: "2345678954",
    customer_name: "Nuvo GmbH",
    domain_name: "getnuvo.com",
    address: "Schoeneberger Allee 6",
    region: "Hamburg, Germany",
    deal_size: 10000,
    deal_stage: "Follow Up",
    pipeline: "Pipeline Nr.1",
    deal_ongoing: true,
  },
  {
    customer_code: "2345678955",
    customer_name: "ComDocks Ltd.",
    domain_name: "www.comdocks.com",
    address: "Suedring 28",
    region: "Berlin, Germany",
    deal_size: 25000,
    deal_stage: "Lead",
    pipeline: "Pipeline Nr.2",
    deal_ongoing: false,
  },
  {
    customer_code: "2345678956",
    customer_name: "Nuvo GmbH",
    domain_name: "getnuvo.com",
    address: "Garden Street 12",
    region: "New York, US",
    deal_size: 30000,
    deal_stage: "Follow Up",
    pipeline: "Pipeline Nr.1",
    deal_ongoing: true,
  },
];

Handling errors and success​

RejectSubmitResult​

DescriptionThis enables you to inform the user that their submitted data has been rejected for whatever reason
Run EventThe execution of this function occurs when it is called inside complete() of the onResults function
ParameterRejectSubmitResult(): This function accepts two parameters:
  • title - The title of the modal
  • text - The description of the modal
Example
onResults={(results, errors, complete, logs) => {
  console.log("Results:", results)
  console.log("Error rows:", errors)
  console.log("Logs:", logs)
  complete(new RejectSubmitResult("Error title", "Your customized error text."));
}}

PassSubmitResult​

DescriptionThis enables you to inform the user that their import was successful, and you can provide additional information about the number of successful and rejected entries
Run EventThe execution of this function occurs when it is called inside complete() of the onResults function
ParameterPassSubmitResult(): This function accepts six parameters:
  • successfulRecords - The total number of succesful records
  • failedRecords - The total number of failed records
  • title - The title of the modal
  • text - The description of the modal
  • imageUrl - The URL of the image that should be displayed inside the modal
  • duration - The duration after which the modal should be closed automatically
ExampleIn this following example, we show you how you can customize the success modal and show additional information
onResults={(results, errors, complete, logs) => {
  console.log("Results:", results)
  console.log("Error rows:", errors)
  console.log("Logs:", logs)
  complete(
    new PassSubmitResult({
      successfulRecords: 10,
      failedRecords: 5,
      title: 'Your customized title',
      text: 'Your customized text.',
      imageUrl: 'Your image url',
      duration: 3000
    })
  );
}}

Examples​

Displaying the results in the console​

This code snippet shows the results and the errors array logged inside your browser console.

<NuvoImporter
  licenseKey="Your License Key"
  settings={{
    developerMode: true,
    identifier: "product_data",
    columns: [
      {
        label: "Product ID",
        key: "product_id",
      },
      {
        label: "Article Name",
        key: "article_name",
      },
    ],
  }}
  onResults={(results, errors, complete, logs) => {
    console.log("Results:", results);
    console.log("Error rows:", errors);
    console.log("Logs:", logs);
    complete();
  }}
/>

Sending the results to an API endpoint​

This code snippet shows how to use the function "onResults" to make an API call. This can be used, for example, to send the output of the import process to your backend.

<NuvoImporter
  licenseKey="Your License Key"
  settings={{
    developerMode: true,
    identifier: "product_data",
    columns: [
      {
        label: "Product ID",
        key: "product_id",
      },
      {
        label: "Article Name",
        key: "article_name",
      },
    ],
  }}
  onResults={(results, errors, complete, logs) => {
    return fetch("https://my-json-server.typicode.com/getnuvo/nuvo/customers", {
      method: "POST",
      headers: {
        "Content-Type": "application/json",
      },
      body: JSON.stringify({
        data: {
          results,
          errors,
        },
      }),
    })
      .then((res) => {
        console.log(res);
        complete();
      })
      .catch((err) => {
        console.log(err);
        complete(new RejectSubmitResult("Error", err.message));
      });
  }}
/>

Transforming the results structure​

This example shows how the structure of the importer's output can be transformed within the function "onResults". This can be used to rename keys, enrich the data or increase the depth of the output data. Normally, the results array object has a flat hierarchy. So if your backend needs data with a deeper structure, this code snippet could be useful:

<NuvoImporter
  licenseKey="Your License Key"
  settings={{
    developerMode: true,
    identifier: "product_data",
    columns: [
      {
        label: "Product ID",
        key: "product_id",
      },
      {
        label: "Article Name",
        key: "article_name",
      },
      {
        label: "Street",
        key: "street",
      },
      {
        label: "Postal Code",
        key: "postal_code",
      },
      {
        label: "City",
        key: "city",
      },
    ],
  }}
  onResults={(results, errors, complete, logs) => {
    const targetOutput = results.map((item) => {
      return {
        product_id: item?.product_id ?? "default value id",
        article_name: item?.article_name ?? "default value article name",
        production_address: {
          street: item?.street ?? "default value street",
          postal_code: item?.postal_code ?? "default value code",
          city: item?.city ?? "default value city",
        },
      };
    });

    console.log("Results: ", results);
    console.log("Errors: ", errors);
    console.log("Logs:", logs);
    console.log("Target output: ", targetOutput);
    complete();
  }}
/>

Download results data as csv​

This code snippet triggers a download of the cleaned data as a CSV file once the import is complete (it is possible to do the same for the download of an XLSX file). Please note that you need to install the FileSaver.js library for the code snippet to work:

import { saveAs } from "file-saver";

<NuvoImporter
  licenseKey="Your License Key"
  settings={{
    developerMode: true,
    identifier: "product_data",
    columns: [
      {
        label: "Product ID",
        key: "product_id",
      },
      {
        label: "Article Name",
        key: "article_name",
      },
      {
        label: "Street",
        key: "street",
      },
      {
        label: "Postal Code",
        key: "postal_code",
      },
      {
        label: "City",
        key: "city",
      },
    ],
  }}
  onResults={(results) => {
    if (results.length > 0) {
      const headers = Object.keys(results[0]).map((key) => key);
      const body = [];
      results.forEach((row, rowIndex) => {
        headers.forEach((key) => {
          const value = String(row[key] ?? " ").replace(",", "‚");
          if (body[rowIndex]) {
            body[rowIndex].push(value);
          } else {
            body[rowIndex] = [value];
          }
        });
      });
      const content = [
        headers.join(","),
        body
          .map((row) => {
            return row.join(",");
          })
          .join("\r\n"),
      ].join("\r\n");

      // "saveAs" is a function for download file from "file-saver" library
      // you can see how to install from this link
      // https://github.com/eligrey/FileSaver.js/
      return saveAs(new Blob([content], { type: "text/csv;charset=utf-8;" }), "results.csv");
    }
  }}
/>;