Please enable JavaScript.
Coggle requires JavaScript to display documents.
New Map, $SYS.GET, 1, 2, 3 - Coggle Diagram
New Map
start
$SYS.GET
ANSWER
%result
https://api.pipe.bot/docs/spreadsheets/read
result
$SYS.GET
ANSWER
%ceo_name=ceo_name
%location=location
%full_name=full_name
%short_name=short_name
error
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/insert
?rowId>0
1 more item...
else
1 more item...
QUESTION
doc=1cbiBhA-HmEO5wWQn3XEN44UGkiNxDFwu1OSRrzf1sW8
range=Sheet3!A2
value=%location|%full_name|%ceo_name|%short_name
ANSWER
%rowId
QUESTION
range=Sheet2!A2
doc=1cbiBhA-HmEO5wWQn3XEN44UGkiNxDFwu1OSRrzf1sW8
$SYS.GET
QUESTION
range=Sheet2!A3
doc=1cbiBhA-HmEO5wWQn3XEN44UGkiNxDFwu1OSRrzf1sW8
ANSWER
%result
https://api.pipe.bot/docs/spreadsheets/read
result
$SYS.GET
ANSWER
%ceo_name=ceo_name
%location=location
%full_name=full_name
%short_name=short_name
error
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/insert
?rowId>0
...Record added with row id %rowId
$SYS.GET
3 more items...
else
...Something went wrong and we can not create record
QUESTION
doc=1cbiBhA-HmEO5wWQn3XEN44UGkiNxDFwu1OSRrzf1sW8
range=Sheet3!A2
value=%location|%full_name|%ceo_name|%short_name
ANSWER
%rowId
1
2
3