Notes

Query a CSV file or list of JSON Dictionaries using SQL statement. You can use all the Sqlite functions, and a custom function 'parsedate(string, format)' that uses the same format as 'Parse Date'. This action requires GizmoPack Pro.

Syntax

queryRecords(fields: <#Array#>, input: <#Variable#>, outputType: <#Enumeration (QueryRecordsOutput)#>, hasWhere: <#Boolean#>, whereClause: <#String (Allows Variables)#>, hasGroupBy: <#Boolean#>, groupByClause: <#Array#>, hasOrderBy: <#Boolean#>, orderByClause: <#Array#>, hasLimit: <#Boolean#>, limitClause: <#Integer#>)

Example

queryRecords(fields: [""], input: ShortcutInput, outputType: automatic, hasWhere: false, whereClause: """", hasGroupBy: false, groupByClause: "", hasOrderBy: false, orderByClause: "", hasLimit: false, limitClause: "")