Articles on: Connectors

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



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

Was this article helpful?

Share your feedback

Cancel

Thank you!