Querydb

Syntax :

For SQL/MySQL/PostgreSQL: querydb "<SQL QUERY>" <ENTER>

For CSV: querydb "<CSV FILE NAME>" <ENTER>

For Xero: querydb <ENTITY> <FILTER> <ENTER>

For Files: querydb<PATTERN> <ENTER>

Eg:

For SQL/ MySQL / PostgreSQL: eg.querydb "select top 10 comp_name from company"

For CSV: eg.querydb "test.csv"

For Xero: eg.querydb contacts firstname = 'CRM' AND UpdatedDateUTC > DateTime(2022, 03, 24) FILES

For Files: eg.querydb "*.csv"

Description : Executes the given query on the currently connected local Server (marked with a *) and gets the response in tabular form.  For files provider, user can get the file list using a pattern. For xero provider with Invoices entity, user can give last parameter as FILES as optional which means user wants to get PDF resource instead of tabular data and later user can upload those PDF resources to S3 with using push command.

---

Save Locally (from version 2.0.3.0)

To save the data locally you can type

>savelocal <folder and filename>

EG

>savelocal "c:\temp\test.csv"

This is available without needing a subscription

---

Files

The syntax is

>querydb "*PATTERN"  "DAYS" "maxsize"

so if you wannted to query all pdf's with a name starting with "v" created in the last day you would use

  .querydb "v*.pdf"  "-1" "3mb"

---

Files Size

As of 15 Feb 2024 there is a limit of 5mb for files being uploaded.