Pull

Syntax :

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

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

Eg:

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

Description : User can pull the available island's data and then store the data to connected database server. 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.

---

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%'\"}"