Tiny ERP icon

Tiny ERP

Interact with Tiny ERP API v3

Overview

This node integrates with the Tiny ERP API v3 to manage various business resources, including contacts. Specifically, the Contact - Get All operation retrieves a list of all contacts stored in the Tiny ERP system. This is useful for scenarios where you need to synchronize contact data, generate reports, or automate workflows involving customer or supplier contacts.

For example, you might use this node to:

  • Fetch all contacts to update a CRM system.
  • Retrieve contacts filtered by a search term to find specific clients.
  • Paginate through large contact lists to process them in batches.

Properties

Name Meaning
Options Collection of optional parameters to control the retrieval:
- Limit: Max number of results to return (1 to 100). Default is 50.
- Page: Page number to retrieve, starting at 1. Default is 1.
- Search: Search term to filter contacts by name or other fields.

Output

The output is an array of JSON objects, each representing a contact retrieved from Tiny ERP. Each object contains the contact's details as returned by the API, such as name, email, phone, and other contact-specific information.

No binary data is output by this operation.

Example output snippet (simplified):

[
  {
    "json": {
      "id": "123",
      "nome": "John Doe",
      "email": "john.doe@example.com",
      "telefone": "+1234567890",
      ...
    }
  },
  {
    "json": {
      "id": "124",
      "nome": "Jane Smith",
      "email": "jane.smith@example.com",
      "telefone": "+0987654321",
      ...
    }
  }
]

Dependencies

  • Requires an API authentication token configured via OAuth2 credentials to access the Tiny ERP API.
  • The node makes HTTP requests to https://erp.tiny.com.br/public-api/v3/contatos endpoint.
  • Pagination and filtering are supported via query parameters.

Troubleshooting

  • Common issues:

    • Invalid or expired API credentials will cause authentication failures.
    • Exceeding the maximum limit (over 100) will likely result in an error.
    • Network connectivity problems can cause request timeouts or failures.
  • Error messages:

    • "Tiny ERP API request failed: <error message>" indicates an issue with the API call. Check your credentials, network, and parameter values.
    • "Unknown operation: getAll" would indicate a misconfiguration of the operation parameter, but this should not occur if using the provided UI options.
  • Resolutions:

    • Ensure valid OAuth2 credentials are set up in n8n.
    • Use limit values between 1 and 100.
    • Verify network access to the Tiny ERP API endpoint.
    • Use the "Continue On Fail" option in the node settings to handle intermittent errors gracefully.

Links and References

Discussion