Dataiku DSS icon

Dataiku DSS

Use the Dataiku DSS API

Actions364

Overview

This node interacts with the Dataiku DSS API to perform various operations on dataset statistics worksheets, specifically including the ability to delete a worksheet within a dataset. It is useful in scenarios where you need to programmatically manage statistical worksheets associated with datasets in Dataiku DSS projects, such as cleaning up obsolete worksheets or automating dataset statistic management workflows.

For example, if you have automated data quality checks and generate multiple statistical worksheets over time, this node can help you delete specific worksheets that are no longer needed, ensuring your project stays organized and up-to-date.

Properties

Name Meaning
Project Key The unique key identifying the Dataiku DSS project containing the dataset.
Dataset Name The name of the dataset within the project for which the worksheet exists.
Worksheet ID The identifier of the specific worksheet to delete within the dataset's statistics.

Output

The output of the node is a JSON array containing the response from the Dataiku DSS API after attempting to delete the specified worksheet. Typically, for a delete operation, the response may be empty or contain status information confirming the deletion.

  • json: Contains the parsed JSON response from the API call.
  • If the API returns no content (HTTP 204), the output will include a status code message indicating "204 No Content".

No binary data output is produced by this operation.

Dependencies

  • Requires an active connection to a Dataiku DSS instance via an API key credential.
  • The node expects the Dataiku DSS server URL and a valid user API key configured in the credentials.
  • Proper permissions on the Dataiku DSS project and dataset to delete worksheets are necessary.

Troubleshooting

  • Missing Credentials Error: If the node throws an error about missing credentials, ensure that the Dataiku DSS API credentials (server URL and API key) are correctly set up in n8n.
  • Required Parameter Errors: The node validates required parameters such as Project Key, Dataset Name, and Worksheet ID. Missing any of these will cause an error. Double-check that all required fields are provided.
  • API Permission Issues: If the API returns authorization errors, verify that the API key has sufficient permissions to delete worksheets in the specified project and dataset.
  • Network or Server Errors: Connection issues or server errors from Dataiku DSS will be reported. Check network connectivity and the status of the Dataiku DSS server.

Links and References

Discussion