Tiny ERPInstall

Overview

This node integrates with the Tiny ERP API v3 to manage product data within an ERP system. Specifically, the Product - Get All operation retrieves a list of products from the Tiny ERP system, supporting pagination and search filtering.

Typical use cases include:

• Synchronizing product catalogs between Tiny ERP and other systems.
• Fetching product lists for reporting or inventory management.
• Automating workflows that require up-to-date product information.

For example, you could use this node to fetch all products matching a search term "laptop" and limit results to 20 per page, enabling efficient processing of large product inventories.

Properties

These options allow controlling the volume and scope of the product data retrieved.

Output

The output is a JSON array where each item represents a product object as returned by the Tiny ERP API. Each product object contains fields such as product ID, name, description, price, SKU/code, and other product details.

The node does not output binary data for this operation.

Example output structure (simplified):

[
  {
    "id": "123",
    "nome": "Product Name",
    "descricao": "Product Description",
    "preco": 99.99,
    "codigo": "SKU123"
    // ... other product fields
  },
  {
    "id": "124",
    "nome": "Another Product",
    "descricao": "Description here",
    "preco": 149.99,
    "codigo": "SKU124"
  }
]

Dependencies

• Requires an OAuth2 API credential configured in n8n for authenticating with the Tiny ERP API.
• The node makes HTTP requests to https://erp.tiny.com.br/public-api/v3.
• No additional external dependencies are needed beyond the configured API authentication.

Troubleshooting

• API Request Failures: Errors like Tiny ERP API request failed: <message> indicate issues with the API call. Common causes:

  • Invalid or expired API credentials.
  • Network connectivity problems.
  • Incorrect parameter values (e.g., invalid page number).

  Resolution: Verify API credentials, check network access, and ensure parameters are valid.

• Empty Results: If no products are returned, confirm that the search term is correct and that the requested page contains data.

• Limit Exceeded: The API limits the maximum number of results per request to 100. Setting a higher limit will be ignored or cause errors.

Links and References

• Tiny ERP Public API Documentation (official API docs)
• n8n OAuth2 Credential Setup (for configuring API authentication)

This summary covers the logic and usage of the Tiny ERP node's Product Get All operation based on static code analysis and provided property definitions.