Please enable JavaScript.
Coggle requires JavaScript to display documents.
Aut, range=Invoices!R14 - Coggle Diagram
Aut
label
$SYS.GET
https://api.pipe.bot/docs/spreadsheets/read
?rowId>0
?status=True
?role=adm
error
end
...Привіт, чим можу допомогти?
?role=teacher
error
...Привіт, чим можу допомогти?
else
access denied
else
else
user not found
?userstatus
$SYS.POST
https://api.pipe.bot/docs/spreadsheets/insert
#
ANSWER
%rowId
QUESTION
range=Users!A:A
value=%sys.givenname %sys.familyname||%sys.uid|%userstatus|True
doc=1FWM3cEswNhJjUxp9VFVwIM2YtbQnwGA7XcxYgSbI9nc
ANSWER
%rowId=rowId
%status=4
%role=3
QUESTION
doc=1FWM3cEswNhJjUxp9VFVwIM2YtbQnwGA7XcxYgSbI9nc
range=Users!C:C
search=%sys.uid
range=Invoices!R14