Skip to main content
Skip table of contents

Operation: PutRow

With the PutRow operation, you insert rows with values from the XML input document into a table.

For more information on other operations of the Google Cloud Storage BigTable Connector, see Google Cloud Storage BigTable Connector.

Parameters

Adapter

Main class of the adapter (do not change!)

Possible values:

de.softproject.integration.adapter.google.cloud.bigtable.storage.GoogleCloudBigtableAdapter: Main class (Default)

serviceAccountFile

Path to the JSON file that contains the Service Account Key to authenticate against Google Cloud Storage.

Possible values:

  • System path, e.g.: C:\X4\V_5.4\Server\X4DB\1\ExampleProcess\GoogleCloud\Config\serviceAccountFile.json

  • X4DB URL, e.g.:
    X4db://1/ExampleProcess/GoogleCloud/Config/serviceAccountFile.json

  • XStore URL, e.g.:
    XStore://ExampleProcess/GoogleCloud/Config/serviceAccountFile.json

projectID

ID of the project

Possible values:

ID of a Google Cloud project. Can be viewed in the Google Cloud Console.

instanceID

ID of the instance

Possible values:

ID of a Google Cloud instance. Can be viewed in the Google Cloud Console.

Note:

For more information on how to create an instance in Google BigTable, see the Google Cloud documentation:

Bigtable>Create and manage instances>Create an instance (https://cloud.google.com/bigtable/docs/creating-instance?hl=en).

tableName

This parameter is required for this operation.

Name of the table

columnFamilyName

This parameter is required for this operation.

Column family name. Groups columns with unique names.

rowKey

Row key of the row. Identifier to insert or search rows.

Note:

The operation uses the columnName and value attributes for the rowKey parameter.

Status values

1

The adapter operation was executed successfully

0

The operation was not completed, but no error occurred.

-1

The operation failed due to a technical error.

Input

For the PutRow operation, the adapter expects XML in the following structure:

CODE
<ListRows>
    <row rowKey="IT employee">
        <rowAttribute1 columnName="ID" value="00001" />
        <rowAttribute2 columnName="Address" value="Karlsruhe" />
        <rowAttribute3 columnName="Name" value="Paolo" />
        <rowAttribute4 columnName="Surname" value="Green" />
        <rowAttribute5 columnName="Phone" value="552-968-369" />
        <rowAttribute6 columnName="Bonus" value="Yes" />
        <rowAttribute7 columnName="Profession" value="System Administrator" />
    </row>
</ListRows>

Note:

Element names can be freely selected, but the rowKey, columnName, and value attributes are required.

Output

The adapter inserts rows with values from the XML input document into the specified table.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.