Tool to search and filter company records from the full Company Dataset using Elasticsearch or SQL queries via POST method. Use when you need to find multiple companies matching specific criteria with complex filtering.
sqlstringSQL query format: SELECT * FROM company WHERE [condition]. Either 'query' or 'sql' is required, but not both.
sizeintegerBatch size/max records returned. Must be between 1 and 100. Default: 1
querystringAn Elasticsearch (v7.7) DSL query for searching company data. Must be a valid JSON object as a string. Either 'query' or 'sql' is required, but not both.
prettybooleanHuman-readable JSON formatting. Default: false
titlecasebooleanTitlecase response text. Default: false
from_offsetintegerLegacy offset for pagination (0-9999), max 10000 records total. Use scroll_token for unlimited pagination.
scroll_tokenstringPagination token from previous response for unlimited record retrieval. Use this for paginating beyond 10000 records.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
Aident-managed access. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.