Services - Databloc Connector
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
https://www.ag-grid.com/javascript-grid/filter-api/
There is 2 approaches: insert record by record or Batch Insert (Copy)
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 --> array of objects

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]"}
Update Record

Updated on: 17/10/2022
Thank you!