Please enable JavaScript.

Coggle requires JavaScript to display documents.

addTest ($SYS.POST (https://sheets.googleapis.com/v4/spreadsheets/1UhyIOX0…

- - - - https://api.pipe.bot/docs/spreadsheets/insert
        
        $SYS.GET
        
        QUESTION
        
        range=Data!A:A
        
        doc=1RFjvNQysxZ55cUyjwbc6M-82-SuOK_H1Dlk3cuM5NOo
        
        search=%userIDForPush
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        else
        
        replace /\/ %quizzesForPush %replaceForPush
        
        %replaceForPush=\"
        
        replace /"/ %quizzesForPush %replaceForPush
        
        %jsonForPush={
        "majorDimension": "ROWS",
        "values": [
        ["%userIDForPush","%quizzesForPush"]
        ]
        }
        
        $SYS.POST
        
        https://sheets.googleapis.com/v4/spreadsheets/1RFjvNQysxZ55cUyjwbc6M-82-SuOK_H1Dlk3cuM5NOo/values/A2:append?valueInputOption=RAW
        
        QUESTION
        
        1 more item...
        
        Authorization: Bearer %tokenForPush
        
        %quizzesForPush={"Quizzes":{},"Amount":1,"QuizzesIDs":["%idForPush"]}
        
        %replaceForPush=\\\\
        
        $.Quizzes.%idForPush %quizzesForPush set(%nameForPush)
        
        ?answerForPush>0
        
        $.Quizzes.%idForPush %dataForPush set(%nameForPush)
        
        %amountOfQuizzesForPush=$.Amount %dataForPush
        
        calc %amountOfQuizzesForPush=%amountOfQuizzesForPush+1
        
        $.Amount %dataForPush set(%amountOfQuizzesForPush)
        
        $.QuizzesIDs %dataForPush add(%idForPush)
        
        replace /\/ %dataForPush %replaceForPush
        
        %replaceForPush=\\\\
        
        %replaceForPush=\"
        
        replace /"/ %dataForPush %replaceForPush
        
        %jsonForPush={
        "majorDimension": "ROWS",
        "values": [
        ["%dataForPush"]
        ]
        }
        
        $SYS.PUT
        
        3 more items...
        
        ANSWER
        
        %answerForPush=rowId
        
        %dataForPush=1
      - QUESTION
        
        range=Answers!A2
        
        value=%idForPush|{"Total":%JSONTotalForPush}|{"Total":%JSONTotalForPush}|0
        
        doc=1u_gRkW9PkCPnLw649Uq0NZX2hsn2yzYV9bgRycxmHSI