Lexware Office icon

Lexware Office

Interact with Lexware Office API

Actions61

Overview

This node interacts with the Lexware Office API to retrieve article data. Specifically, the "Get All" operation for the "Article" resource allows users to fetch multiple articles from their Lexware Office account, optionally filtered and sorted by various criteria. This operation is useful for scenarios where you want to list or process multiple articles, such as generating reports, syncing article data with other systems, or filtering articles for inventory management.

For example, you could use this node to:

  • Retrieve all active service-type articles in a specific category.
  • Search articles by a keyword in their name or description.
  • Paginate through articles to process them in batches.
  • Sort articles by creation date or name.

Properties

Name Meaning
Search Term Search articles by name or description (text filter).
Category ID Filter articles by a specific category ID.
Article Type Filter articles by type. Options: Service, Material, Custom.
Archived Status Filter articles by archived status. Options: Active Only, Archived Only, All Articles.
Return All Whether to return all matching results or limit the number of results returned.
Limit Maximum number of results to return (used if Return All is false). Range: 1-250.
Page Page number for pagination (0-based index).
Sort Sort order for results. Options include Created At (Asc/Desc), Updated At (Asc/Desc), Voucher Date (Asc/Desc), Name (Asc/Desc), ID (Asc/Desc). Default is Created At (Descending).
Cursor Cursor string for cursor-based pagination (optional).
Offset Offset number for offset-based pagination (optional).

Output

The node outputs a JSON array where each element represents an article object retrieved from Lexware Office. Each article object contains fields as defined by the Lexware Office API, typically including article identifiers, names, descriptions, types, category information, pricing, tax rates, and archived status.

No binary data output is produced by this operation.

Dependencies

  • Requires an API key credential for Lexware Office API authentication.
  • The node uses the Lexware Office API base URL configured in the credentials.
  • No additional external dependencies are required.

Troubleshooting

  • Missing Required Fields Error: If required parameters are missing for the operation, the node throws an error listing the missing fields. Ensure all mandatory fields are provided.
  • API Authentication Errors: If the API key credential is invalid or missing, authentication will fail. Verify that the API key and resource URL are correctly configured in the credentials.
  • Pagination Issues: When using pagination parameters (page, limit, cursor, offset), ensure values are within valid ranges and consistent with Lexware API expectations.
  • Empty Results: If filters are too restrictive (e.g., category ID or search term), no articles may be returned. Try broadening filter criteria.

Links and References

Discussion