Please enable JavaScript.
Coggle requires JavaScript to display documents.
Docs integration (start (%row=null (docs label (///Get from cell ($SYS.GET…
Docs integration
start
%row=null
docs
label
///Get from cell
$SYS.GET
ANSWER
%row=rowId
%var=0
%b=1
%result
%c=%two
https://api.pipe.bot/docs/spreadsheets/read
%result
#
QUESTION
range=A:A
search=Name
doc=1A2twEixCGut_H1SHh020XYs_WabildzaC4zEraF1Q_8
%two=2
///Update cell
%rowId=/get
https://api.pipe.bot/calc
expr=mt_rand(0,30)
$SYS.POST
QUESTION
value=[[],[],[1,0],[0,1,0],[1,0]]
range=C%rowId
doc=1yYCqJVLRI2XR949lp5mjdxPzimHm-HVuEHZOS4h03OY
https://api.pipe.bot/docs/spreadsheets/update
Cell updated %rowId
#
ANSWER
%rowId
///New Doc
$SYS.POST
QUESTION
FirstName=%sys.givenname
last=Pupkin
doc=1MmON7gutJe-zioRkiqELdRCvmWl3iI2jmYEZlNj6I4U
Dolor=
https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=https://storytellingbot.com/link?bot=moy_bratuha_bot&doc_id=mydocument
somevariablename=%unexistedVar
LastName=%sys.familyname
https://api.pipe.bot/docs?email=warstranger@gmail.com
Вот ваш документ %result
#
ANSWER
%result
Choose bro for new
///Insert row
%code=SECRET_CODE
$SYS.POST
QUESTION
value=asdfsadfa|%sys.familyname|sdfasfsd|
k
|| | [[],[],[1,0],[0,1,0],[1,0]]|%code
range=🖲 Рахунки (270 грн)!A1
doc=1A2twEixCGut_H1SHh020XYs_WabildzaC4zEraF1Q_8
https://api.pipe.bot/docs/spreadsheets/insert
Posted in cell id=%rowId
#
ANSWER
%rowId
///Delete row
$SYS.POST
QUESTION
doc=1yYCqJVLRI2XR949lp5mjdxPzimHm-HVuEHZOS4h03OY
rowId=2
https://api.pipe.bot/docs/spreadsheets/delete
Row deleted
#
ANSWER
%result
///Get List
$SYS.GET
QUESTION
doc=1A2twEixCGut_H1SHh020XYs_WabildzaC4zEraF1Q_8
range=C2:D4
https://api.pipe.bot/docs/spreadsheets/read
Your
result is
%result
#
ANSWER
%result
/// Filter
%rowId=null
$SYS.GET
QUESTION
filter=Пако
range=A20:C40
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
ANSWER
%result
%rowId=rowId
https://api.pipe.bot/docs/spreadsheets/filter
...Вот что мы нашли
...result=%result rowId=%rowId
#
//AsyncInsert
$SYS.POST
QUESTION
doc=1yYCqJVLRI2XR949lp5mjdxPzimHm-HVuEHZOS4h03OY
value=10000 | asdf | %row | sdfg454h4 | [[],[],[1,0],[0,1,0],[1,0]]
https://api.pipe.bot/docs/spreadsheets/insertasync
Posted in cell
#
///Search
%search=Пако
$SYS.GET
QUESTION
doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
range=A:A
search=%search
ANSWER
%rowId=rowId
%value51=51
%value52=52
%value0=0
%value1=1
%value2=2
https://api.pipe.bot/docs/spreadsheets/read
?rowId>0
...Search result:%value0, %value1, %value2, %value51, %value52
...RowId:%rowId
#
else
...We can not find any record
#
///Exit
root
some text after root
///Insert Personal
$SYS.POST
ANSWER
%rowId
https://api.pipe.bot/docs/spreadsheets/insert
Posted in cell id=%rowId
#
QUESTION
value=asdfsadfasdfasfsd|
k
||asdf|123435|
doc=1W8y0lTwiCSdfM904u3r5gM8W27hG9ZuL8mTk9x7wUoM
///New PDF
$SYS.POST
ANSWER
%result
https://api.pipe.bot/docs?email=warstranger@gmail.com&format=pdf
Вот ваш документ %result
#
QUESTION
somevariablename=%unexistedVar
Dolor=
https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=https://storytellingbot.com/link?bot=moy_bratuha_bot&doc_id=mydocument
last=Pupkin
FirstName=%sys.givenname
doc=1gg4JMvZu9SPWd_Y25u05D3PJJM1jyXxw7kntzXiTPBw
LastName=%sys.familyname
//Insert Async
$SYS.POST
ASYNC
https://api.pipe.bot/docs/spreadsheets/insert
Posted
#
QUESTION
value=1111111|2222|3333|4444|55555|
doc=1W8y0lTwiCSdfM904u3r5gM8W27hG9ZuL8mTk9x7wUoM
%result=null
%rowId=null