Synca Priority ERP icon

Synca Priority ERP

Interact with Priority ERP for Products, Sales, Purchase Orders, Agents, and Procedures

Actions29

Generic → Search Rows in Form

AI-generated

Overview

This node operation allows users to search rows within a specified form in the Synca Priority ERP system. It supports applying multiple filters on form fields to refine the search results and optionally selecting specific fields to return. This operation is useful for scenarios where users need to query and retrieve data from forms based on dynamic criteria, such as searching customer records, orders, or any custom form data stored in Priority ERP.

Use Case Examples

  1. Search for customer records in a 'Customers' form where the 'City' field equals 'New York' and return only the 'Name' and 'Email' fields.
  2. Retrieve all rows from a 'Sales Orders' form where the 'Order Date' is greater than a specified date, limiting the results to 100 entries.

Properties

Name Meaning
credentials API credentials to authenticate and authorize access to the Priority ERP system.
formName The specific form within Priority ERP to search rows in.
filters A collection of filters to apply on the form fields to narrow down the search results. Each filter includes a field, an operator (e.g., equals, not equals, starts with), and a value to compare.
fields The specific fields/columns to return from the form. If left empty, all columns will be returned.
limit The maximum number of results to return from the search.
skip The number of items to skip before starting to return results, useful for pagination.

Output

JSON

  • json - The JSON object containing the search results from the form rows.

Dependencies

  • An API key credential to authenticate with the Synca Priority ERP system.

Troubleshooting

  • If no filters are provided for update operations, the node throws an error indicating that at least one filter is required to prevent unintended updates.
  • Ensure the credentials provided have sufficient permissions to access the specified form and perform search operations.
  • If the form name or fields are incorrect or do not exist, the node may return empty results or errors.

Links

Discussion