Actions62
- SQL Actions
- Client Access Actions
- User Access Actions
- Tools Actions
- HTML to PDF
- Markdown to PDF
- Text to PDF
- Merge PDFs
- Split PDF
- Extract PDF Text
- Resize Image
- Convert Image
- Compress Image
- Add Image Watermark
- Create Thumbnail
- Generate Barcode
- Read Barcode
- Validate CPF/CNPJ
- Format CPF/CNPJ
- Generate UUID
- Transform JSON
- CSV to JSON
- JSON to CSV
- Normalize Text
- Extract Regex Fields
- Validate JSON Schema
- Generate Hash
- HMAC Sign
- Base64 Encode/Decode
- JWT Decode
- Encrypt Text
- Decrypt Text
- Format Date
- Parse Date
- Add Business Days
- Format Currency
- Number to Words
- Build Socket Event Payload
- Validate Client Token
- Validate Agent Context
- Build SQL Request
- Parse SQL Rows
- Generate Access Request Summary
- Publish Socket Event
- Wait for Socket Event
Tools → Parse SQL Rows
AI-generatedSummary
Parse JSON-formatted SQL query result rows into structured n8n items under a specified output JSON property.
Inputs
- toolCategory — Select the group of tools to display; defaults to 'documents' but does not affect runtime for this operation.
- rowsJson (required) — Provide the SQL rows as a JSON array to be parsed.
- outputJsonProperty — Set the JSON property name in the output where parsed rows will be stored; defaults to 'sqlRows'.
Output shape
a JSON property on the output item containing the parsed SQL rows as structured JSON objects.
The operation requires a valid JSON array input for rowsJson. The parsed rows are assigned to the specified output JSON property on each output item. No pagination or streaming applies as input is direct JSON.
Examples
Example 1: Parsing SQL query results stored in JSON
Input valid JSON array of SQL rows into the 'Rows JSON' parameter, optionally change the output property name; node outputs parsed rows under that property.