Actions12
- Datastore Actions
- GraphQL Actions
- Session Actions
- Table Record Actions
Table Record → Query or Delete Records
AI-generatedSummary
Query or delete records from a specified SAI360 class using filter expressions to identify the target records.
Inputs
- Authentication — The authentication method to use (hidden parameter, default is OAuth2).
- Class Name or ID (required) — Select the class to query or delete records from; can be chosen from a list or provided via expression.
- Action (required) — Choose 'Get XML' to retrieve records as XML or 'Delete' to delete matching records.
- Query — The filter expression to find records; do not include the class name. Supports expressions like label like '*', fieldId = 'Admin', etc.
- Options — Additional options including fields to follow references, whether to include metadata, subtypes, workflow info, and mode of referencing related records (GUID or Label).
Output shape
a single item containing either the XML data string under 'data' when querying, or a JSON object indicating success of deletion with queryId, action, success boolean, and message.
If 'Get XML' action is chosen, the output JSON includes 'queryId' and 'data' with the XML response body (string). If 'Delete' is chosen, output JSON includes 'queryId', action ('delete'), success status, and message string. The node performs a POST to initiate the query then a GET or DELETE for the results. The response is not parsed into JSON from XML but returned as raw data in the 'data' field.
Examples
Example 1: Query records as XML
Select the class, choose 'Get XML' as action, specify a filter query, and set options as needed.
Example 2: Delete matching records
Select the class, choose 'Delete' as action, specify a filter query to identify deletable records, configure options if necessary.