Please enable JavaScript.
Coggle requires JavaScript to display documents.
JSON, $SYS.GET - Coggle Diagram
JSON
$SYS.GET
QUESTION
doc=1xINAH0OqCm9gwm1MkFvj8ttuptgoJVyL
search>0
range=B:B
ANSWER
%rowId=rowId
%name=0
https://api.pipe.bot/docs/spreadsheets/read
?rowId>0
%rowId: %name
else
...We can not find any record
$SYS.GET
https://sheets.googleapis.com/v4/spreadsheets/15_5Ug8DepHkXJCfU3HVR7MNL-Va3BmyjIz1B_nrik_Q/values/!A2:G6?key=AIzaSyDkZJkXG2ViLpm9_R7u9jJXTWH_7q0G1Sc
%birthday=$.rows[3] %rows
%name=$.rows[0] %rows
%debt=$.rows[5] %rows
%passport=$.rows[2] %rows
%location=$.rows[1] %rows
%AgreementDate=$.rows[4] %rows
%DebtDuration=$.rows[6] %rows
%PresentingLawyer=$.rows[7] %rows
next
$.values %bot.data each(%rows)
exit
Роботу закінчив. Можна і пообідати)
end
next
?debt>0
%rows={"rows":%rows}
else
%PresentingLawyer
1 more item...
%DebtDuration
%AgreementDate
%location
%passport
%debt
%name
%birthday
?debt<0
end
ANSWER
%bot.data