Phacet icon

Phacet

Interact with Phacet API to manage spreadsheet data
Join our community

Actions2

Overview

This node integrates with the Phacet API to create new rows in a specified spreadsheet-like structure called a "phacet." It allows users to add data cells to a particular session within a phacet, effectively enabling dynamic data entry and management in automated workflows.

Common scenarios include:

  • Automating data collection by adding rows to a phacet from various sources.
  • Integrating form submissions or other input data into structured spreadsheets.
  • Managing session-specific data entries programmatically.

For example, you might use this node to add survey responses as rows in a phacet session or log transaction details automatically.

Properties

Name Meaning
Phacet Name or ID Select the target phacet where the new row will be created. You can choose from a list of available phacets or specify an ID using an expression.
Session Name or ID Select the session within the chosen phacet where the row will be added. Options depend on the selected phacet. You can also specify an ID via expression.
Cells Define the cell data for the new row. This is a collection of one or more cells, each specifying:
- Column Name or ID: The column in which to place the value (selectable from columns of the phacet).
- Value: The content for the cell. For text columns, enter text; for file columns, provide a file ID obtained from a previous file upload operation.

Output

The node outputs JSON objects representing the newly created row as returned by the Phacet API. Each output item corresponds to one created row and includes all properties returned by the API, such as the row's unique identifier and its cell data.

Example output structure (simplified):

{
  "id": "row-id",
  "sessionId": "session-id",
  "cells": [
    {
      "columnId": "column-id",
      "value": "cell-value"
    }
  ],
  ...
}

No binary data is output by this operation.

Dependencies

  • Requires an API key credential for authenticating with the Phacet API.
  • The node depends on the Phacet API endpoints to fetch available phacets, sessions, and columns dynamically.
  • Network access to https://api.phacetlabs.com is necessary.

Troubleshooting

  • Missing Required Fields: Errors occur if the phacet ID, session ID, or at least one cell is not provided. Ensure these are set correctly.
  • Invalid Cell Data: If cell values do not match expected types (e.g., providing a non-file ID for a file column), the API may reject the request.
  • API Authentication Failures: Verify that the API key credential is valid and has appropriate permissions.
  • Empty Lists in Dropdowns: If phacets, sessions, or columns lists are empty, check your API credentials and network connectivity.
  • Error Messages: The node throws errors with messages like "Phacet ID is required," "Session ID is required," or "At least one cell is required" when mandatory inputs are missing.

To resolve issues:

  • Double-check all required parameters.
  • Confirm API credentials and permissions.
  • Use expressions carefully to ensure correct IDs are passed.
  • Review API limits or restrictions on the Phacet side.

Links and References

Discussion