Pull

From Data Islands
Revision as of 10:46, 13 January 2023 by WikiSysopdi (talk | contribs)

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