Please enable JavaScript.

Coggle requires JavaScript to display documents.

🍉 Spreadsheet integration (start (//Search record (%search=search value…

- - - - $SYS.GET
        
        ANSWER
        
        %value1=1
        
        %value2=2
        
        %rowId=rowId
        
        http://api.storytellingbot.com/docs/spreadsheets/read
        
        ?rowId>0
        
        ...RowId:%rowId
        
        ...Search result: %value1, %value2
        
        else
        
        ...We can not find any record
        
        QUESTION
        
        doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
        
        range=A
        
        search=%search
  - - - %rowId=1
        
        $SYS.POST
        
        http://api.storytellingbot.com/docs/spreadsheets/update
        
        else
        
        Something went wrong
        
        ?result=1
        
        Row successfuly updated
        
        ANSWER
        
        %result
        
        QUESTION
        
        value=%update
        
        range=B%rowId
        
        doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
  - - - $SYS.POST
        
        QUESTION
        
        doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
        
        value=%sys.uid|%text
        
        range=SheetName!A1
        
        ANSWER
        
        %rowId
        
        http://api.storytellingbot.com/docs/spreadsheets/insert
        
        ?rowId>0
        
        ...Record added with row id %rowId
        
        else
        
        ...Something went wrong and we can not create record
  - - - $SYS.POST
        
        QUESTION
        
        rowId=%rowId
        
        doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
        
        ANSWER
        
        %result
        
        http://api.storytellingbot.com/docs/spreadsheets/delete
        
        ?result=1
        
        Row successfuly deleted
        
        else
        
        Can not delete row
  - - - QUESTION
        
        doc=1IkUINIHZX7zauXKSjvcUPYdJepZtKmo8b4gCDx_8224
        
        range=Sheet1!A1:B1
      - ANSWER
        
        %result
      - http://api.storytellingbot.com/docs/spreadsheets/read
        
        ...Read results
        
        ...%result