Pull

Syntax :

For All: pull <ISLANDNAME> <SERVER TABLENAME> [WHERE CLAUSE] <ENTER>

For Files: pull <ISLANDNAME> "<FOLDER PATH>" <ENTER>

Eg:

For All: eg. pull sqldata sqldata.csv "Country" = 'Germany'

Description : User can pull the available island's data and then store the data to connected database server.

Column names are in SQUARE BRACKETS

For Files provider, we need to give folder path in the place of Server islandname, where all the files will get downloaded from server. 

We also have one optional parameter as where clause if we wants to narrow down our result.

---

Note you can also use

>import

instead of

>pull

---

Please note:

If we wants to use query select statement with LIKE operator as case insenstive then we need to use ILIKE instead of LIKE operator as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, we need to give the payload as:

"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}"

---

Example query using a date filter

pull prospects prospects "acdatadatetime>now()::date - 2"