Tiny ERP icon

Tiny ERP

Consumir API do Tiny ERP
Join our community

Actions3

Overview

This node integrates with the Tiny ERP API to search for products. It allows users to query product data based on a search term, supporting pagination and output format options. This is useful in scenarios where you want to automate product data retrieval from Tiny ERP for inventory management, reporting, or synchronization with other systems.

For example, you can:

  • Search all products by using % as a wildcard.
  • Retrieve all pages of product results automatically.
  • Choose between JSON or CSV output formats depending on your workflow needs.

Properties

Name Meaning
Termo de Pesquisa Search term for filtering products. Use % to fetch all products.
Obter Todas as Páginas If enabled, automatically fetches all pages of product results instead of a single page.
Formato de Saída Output format of the results: JSON (default) or CSV.
Página Page number to retrieve when not fetching all pages (used only if "Obter Todas as Páginas" is false).

Output

The node outputs an array of items, each containing:

  • For JSON output: Each item’s json field contains a product object returned by the Tiny ERP API.
  • For CSV output: A single item is output with:
    • json.success set to true.
    • A binary.data field containing the CSV file encoded in base64, with MIME type text/csv and a filename like produtos_tiny_erp_YYYY-MM-DD.csv.

If errors occur during the API request, the node outputs an error message in the json.error field along with location and stack trace information.

Dependencies

  • Requires an API authentication token credential for Tiny ERP.
  • Makes HTTP GET requests to the Tiny ERP API endpoints.
  • Uses internal helper methods for making authenticated requests.
  • No additional external libraries beyond those bundled are required.

Troubleshooting

  • Common issues:
    • Invalid or expired API token will cause API errors.
    • Network connectivity problems may prevent successful API calls.
    • Requesting pages beyond available range may result in empty responses.
  • Error messages:
    • Errors returned by the Tiny ERP API are surfaced with their message prefixed by Erro na API do Tiny:.
    • Unknown API errors default to Erro desconhecido na API do Tiny ERP.
  • Resolution tips:
    • Verify that the API token credential is correctly configured and valid.
    • Check network access to https://api.tiny.com.br.
    • Use the "Obter Todas as Páginas" option to avoid manual pagination errors.

Links and References

Discussion