Clarify

The Clarify Developer Hub

Welcome to the Clarify Developer hub. You'll find comprehensive guides and documentation to help you start working with Clarify as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    API Reference

Importing Files

How to import Excel, CSV, JSON, XML files, and more to Clarify

Importing files can be useful in scenarios where you have software that supports automated or manual exporting. You can set up automatic importing jobs to send the data to Clarify.

XLS, XLSX, ODS

Importing spreadsheets to Clarify using Node-RED
You can use nodes such as node-red-contrib-spreadsheet-in to import spreadsheet data from Excel and ODS.

  1. Add an Inject node
  2. Add a File In node and configure its file path
  3. Add book, sheet & sheet to JSON nodes
  4. Add a Function node and write a function that formats data for Clarify
  5. Add a Clarify input node to send data to Clarify

Example flow for importing data from a spreadsheet (xls, xlsx, etc) to Clarify

CSV

Importing CSV files to Clarify using Node-RED

  1. Add an Inject node
  2. Add a File In node and configure its file path
  3. Add a CSV node and adapt it to your file format
  4. Add a Function node and write a function that formats data for Clarify
  5. Add a Clarify input node to send data to Clarify

Example flow for sending data from CSV files to Clarify

JSON

Importing JSON files to Clarify using Node-RED

  1. Add an Inject node
  2. Add a File In node and configure its file path
  3. Add a JSON node and adapt it to your file format
  4. Add a Function node and write a function that formats data for Clarify
  5. Add a Clarify input node to send data to Clarify

Example flow for sending JSON data to Clarify

XML

Importing XML files to Clarify using Node-RED

  1. Add an Inject node
  2. Add a File In node and configure its file path
  3. Add an XML node and adapt it to your file format
  4. Add a Function node and write a function that formats data for Clarify
  5. Add a Clarify input node to send data to Clarify

Example flow for sending data from XML files to Clarify

HTML

Importing HTML files to Clarify using Node-RED

  1. Add an Inject node
  2. Add a File In node and configure its file path
  3. Add an HTML node and adapt it to your file format
  4. Add a Function node and write a function that formats data for Clarify
  5. Add a Clarify input node to send data to Clarify

The Node-RED HTML node accepts selectors. This means that if you want to import all h1 elements in the HTML file you specify h1 as the selector in the node properties.

Example flow for sending data from HTML files to Clarify

Other

YAML
Use the same flows as the above examples and use the native YAML node in Node.RED

Updated 25 days ago


Importing Files


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.