Databloc is an Easyflow capability that is very similar to databases or tables. You can use it for a variety of purposes such as storing data, transferring data between workflows, preparing data for analytics and visualisation and more.

While creating a databloc ensure all your column names are lower case



Search Records
Filter Criteria
https://www.ag-grid.com/javascript-grid/filter-api/
{"KEY1": {"filterType": "text", "type": "startsWith", "filter": "VALUE1"}, "KEY2": {"filterType": "text", "type": "equals| notEqual | contains | notContains | startsWith | endsWith", "filter": "VALUE2"}}

Sort
[{"colId": "KEY1", "sort": "asc"}]


Add Record
There is 2 approaches: insert record by record or Batch Insert (Copy)

Batch Insert
Dataset: array
Record: json payload represents valid with the selected datastore schema. the values of key inside the record should reflect the data read by the selected array in the dataset

Dataset --> array of arrays
dataset
[["1a", "1b"], ["2a", "2b"]]

Record
{ "key1": "$.[0]", "key2": "$.[1]"}

Dataset --> array of objects
dataset
[{"name": "Kevin", "address": "Australia"}, {"name": "Albert", "address": "USA"}]

Record
{ "key1": "$.['name']", "key2": "$.['address']"}
Was this article helpful?
Cancel
Thank you!