List Records From Data Connector

With this node you can list records from a data connector.

It has the following configuration options:
  • Data Connector: here you can specify the base URL where the data connector is located in the network. There are two options:
    • If the data connecter is hosted internally in CLOUDFLOW, it should contain the name of the data connector.
    • If the data connector is hosted externally, it should include:
      • The address of the workstation the data connector is on.
      • The base path to the data connector (for example http://mybox.mydomain.com:8080/MyDataConnector).
  • Table: here you can specify the table name you want to use in the data connector, which maps to a table in the database.
    Note: This is the assigned name in CloudBuilder, which does not always map exact to the table name in the database. In most cases the only difference is the capitalization.
  • Query: here you can specify the query you want to run in the data connector to get the records you want. Select + to add a query. Select the pencil to open Expression Builder.
  • Order By: here you can specify the fields to order by, and whether they should be sorted ascending or descending. Select + to add a field. Select the pencil to open Expression Builder.
  • Fields: here you can specify the fields to get. Select + to add a field. Select the pencil to open Expression Builder.
  • Limits
    • First Record: here you can specify the first object that matches the query that should be returned. This value is zero based, which means that 0 will return the first match as first result.
    • Maximum number of records: here you can specify the maximum records that should be returned.
  • JSON Output: here you can specify where to save the JSON data. Options:
    • If you leave this field blank, the data will be sent to a container in the database and no physical file will be created.
    • If you define an absolute CLOUDFLOW URL (cloudflow://..., see Server URL for more information), containing a file name and an extension, a physical output file with the specified file name will be created.
  • Overwrite existing file: if you select this checkbox, files that already exist will be overwritten. If you leave this checkbox unselected, existing files will not be overwritten and an error is displayed.