🍉 Spreadsheet integration
Spreadsheet maps
examples 🍉
//Search record
%search=search value
$SYS.GET
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=A
search=%search
ANSWER
%value1=1
%value2=2
%rowId=rowId
?rowId>0
...Search result: %value1, %value2
...RowId:%rowId
...We can not find any record
//Create Record
%text=new record
$SYS.POST
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
value=%sys.uid|%text
ANSWER
%rowId
?rowId>0
...Record added with row id %rowId
...Something went wrong and we can not create record
//Reading Spreadsheet
$SYS.GET
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=Sheet1!A1:B1
ANSWER
%result
...Read results
...%result
// Update record
%update=updated value
%rowId=1
$SYS.POST
Something went wrong
?result=1
Row successfuly updated
ANSWER
%result
QUESTION
value=%update
range=B%rowId
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
// Delete record
%rowId=99999
$SYS.POST
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
rowId=%rowId
ANSWER
%result
?result=1
Row successfuly deleted
Can not delete row