Select SQL Data

Perform select queries in SQL schema


Label (internal name) Type Default Description
Schema Variable Name (var) string DbDescriptor Name of the variable where schema is stored.
SQL SELECT query (select_sql) textarea SQL SELECT Query.
Expected Format (format) Possible Values Below object Try to map request output to a specific format
   • Generic Object (object) format
   • Known Schema (schema) format
      - Table Name (tableName) string Table schema for parsing rows selection.
   • Integer for count(*) queries (int64) format
Output Format (output) Possible Values Below jsonbody How to store output
   • JsonBody (jsonbody) output
   • Variable (variable) output
      - Variable Name (outputVar) string Name of the variable to store
Back to top