Update Record To Data Connector

With this node you can update a record in a database through a Data Connector.

It has the following configuration options:
  • Record Data Type: here you can specify how the contents of the JSON data parameter should be interpreted. Options:
    • Auto detect: if you select this option, the code will examine the content of the provided data, and then use it either as JSON Data or as a URL.
    • JSON in a container (output from another node): if you select this option, the content will be interpreted as content in a container, coming from another node.
    • JSON Data (e.g. from a variable): if you select this option, the content of the data will be interpreted as JSON Data.
    • URL Reference: if you select this option, the content of the data will be interpreted as a URL.
  • Record Data: here you can specify the data you want to save in the data connector.
    • If you want to update a record, it must include the id field.
    • If you want to create a new record, must not include the id field.

    Only the fields that you specify will be updated, all other fields in existing records will be unchanged. Options:

    • JSON data generated by a previous node.
    • A URL reference to a XML file.
    Note: See also JSON Data Type.
  • 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.
  • 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.