Tool to retrieve objects from a specified Backendless table with filtering, sorting, and pagination. Use after confirming the table name and query options. Example: "Get Users where age > 30 sorted by created desc".
propsstringComma-separated list of properties to include, e.g., 'name,email'
wherestringSQL-like condition to filter objects, e.g., 'age > 25'
havingstringCondition to filter groups after aggregation, e.g., 'COUNT(*) > 1'
offsetintegerNumber of objects to skip before returning results. Default is 0 if not specified.
sortBystringComma-separated list of properties to sort by (append 'desc' for descending), e.g., 'created desc'
groupBystringComma-separated list of properties to group by, e.g., 'department'
distinctstringColumn name to return distinct values for, e.g., 'city'
pageSizeintegerNumber of objects to return per page. Default is 10 if not specified.
table_nameRequiredstringName of the data table to query, e.g., 'Users'
user-tokenstringUser authentication token to apply user-level security policies
excludePropsstringComma-separated list of properties to exclude, e.g., 'password'
loadRelationsstringComma-separated list of related properties to include, e.g., 'profile,address'
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
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.