Excel Uploader Overview

How The Excel Uploader Works

The Excel Uploader essentially reads the Excel file with the Pandas library looking for the sheets and columns that it recognizes. Then I believe it joins rows together in places needed, such as relation columns, and considers that as a single row, and converts that row into a JSON like structure (Python dictionary), then deserializes it into a node, creating a new node.

Then takes all the nodes and uploads them to the API in a specific order so it doesn’t get a node does not exist error. For example, it first uploads all the file nodes and then the data nodes creating a connection between them. If it first uploaded all the data nodes without file nodes it would have an error because data nodes cannot exist without file nodes inside of them.

More documentation coming soon ...