row

Creates, updates, deletes, gets or lists a row resource.

Overview

Name	row
Type	Resource
Id	sumologic.lookup_tables.row

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
updateTableRow	exec	id, region, row		Insert or update a row of a lookup table with the given identifier. A new row is inserted if the primary key does not exist already, otherwise the existing row with the specified primary key is updated. All the fields of the lookup table are required and will be updated to the given values. In case a field is not specified then it will be assumed to be set to null. If the table size exceeds the maximum limit of 100MB then based on the size limit action of the table the update will be processed or discarded.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
id	string	Identifier of the lookup table.
region	string	SumoLogic region (enum: [us2, au, ca, de, eu, fed, in, jp], default: us2)

Lifecycle Methods

updateTableRow

Insert or update a row of a lookup table with the given identifier. A new row is inserted if the primary key does not exist already, otherwise the existing row with the specified primary key is updated. All the fields of the lookup table are required and will be updated to the given values. In case a field is not specified then it will be assumed to be set to null. If the table size exceeds the maximum limit of 100MB then based on the size limit action of the table the update will be processed or discarded.

EXEC sumologic.lookup_tables.row.updateTableRow 
@id='{{ id }}' --required, 
@region='{{ region }}' --required 
@@json=
'{
"row": "{{ row }}"
}'
;