smartsheet: appmixer.smartsheet.core.DeleteRows

Basic Information

Name

appmixer.smartsheet.core.DeleteRows

Version

1.0.0

Visibility

Public

Description

Deletes one or more rows from the sheet specified in the URL.

Input Ports

in

Field	Type	Description
Sheet Id	number	Sheet Id of the sheet being accessed.
Ids	text	A comma-separated list of row Ids.
Ignore Rows Not Found	toggle	true or false. If set to false and any of the specified row Ids are not found, no rows are deleted, and the "not found" error is returned.

Output Ports

out

Field	Type	Description
Message		-
Result Code		-
Result		-

Full Metadata

#metadata-viewer { display: none; }{ "version": "1.0.0", "name": "appmixer.smartsheet.core.DeleteRows", "author": "Appmixer <info@appmixer.com>", "description": "Deletes one or more rows from the sheet specified in the URL.", "private": false, "inPorts": [ { "name": "in", "schema": { "type": "object", "required": [ "sheetId", "ids" ], "properties": { "sheetId": { "type": "number" }, "ids": { "type": "string" }, "ignoreRowsNotFound": { "type": "boolean", "default": false } } }, "inspector": { "inputs": { "sheetId": { "type": "number", "index": 0, "label": "Sheet Id", "tooltip": "Sheet Id of the sheet being accessed.", "source": { "url": "/component/appmixer/smartsheet/core/ListSheets?outPort=out", "data": { "transform": "./ListSheets#sheetsToSelectArray" } } }, "ids": { "type": "text", "index": 1, "label": "Ids", "tooltip": "A comma-separated list of row Ids." }, "ignoreRowsNotFound": { "type": "toggle", "index": 2, "label": "Ignore Rows Not Found", "tooltip": "true or false. If set to false and any of the specified row Ids are not found, no rows are deleted, and the \"not found\" <a href=\"../../tag/commonObjects#section/Error-Object\" rel=\"noopener noreferrer\" target=\"_blank\">error</a> is returned.", "defaultValue": false } } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Message", "value": "message" }, { "label": "Result Code", "value": "resultCode" }, { "label": "Result", "value": "result", "schema": { "type": "array", "items": { "type": "number" } } } ] } ], "auth": { "service": "appmixer:smartsheet" }, "icon": "data:image/svg+xml;base64,PHN2ZyB2ZXJzaW9uPSIxLjIiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgdmlld0JveD0iMCAwIDEyMzggMTUxNCIgd2lkdGg9IjEyMzgiIGhlaWdodD0iMTUxNCI+Cgk8dGl0bGU+c21hcnRzaGVldC1sb2dvLWJsdWUtbmV3LXN2ZzwvdGl0bGU+Cgk8c3R5bGU+CgkJLnMwIHsgZmlsbDogIzBlMjk0NyB9IAoJPC9zdHlsZT4KCTxnIGlkPSJMYXllciI+CgkJPGcgaWQ9IkxheWVyIj4KCQkJPHBhdGggaWQ9IkxheWVyIiBjbGFzcz0iczAiIGQ9Im02MTUgMTIwNGMwIDAgMjYzLjQtNjU3LjggNjIyLjktMTA5Ni4zIDAgMTgwLjkgMCA1MzkuOSAwIDgxMS4zIDAgMTUwLjctNS41IDI3NC0xMSAzMjguOC01LjUgNTQuOS0xOS4yIDkwLjUtNDEuMSA5Ni0xNi41IDIuNy00My45LTIuOC05Ni4xLTYzLjEtNDYuNi01NC44LTkzLjMtMTU2LjItOTMuMy0xNTYuMmwtNS41LTExLTguMiA4LjNjLTIuNyAwLTE0NS40IDE0Mi41LTUxNS45IDI3NC0yMDguNSA3NC00MTEuNSAxMDkuNy00NjYuNCAxMTcuOSA1LjUtMjEuOSAxNi40LTc2LjggMTYuNC0xNTAuOCAwLTk1LjkgMC0xMjQ2LjkgMC0xMzYyLjFoMTIxNS42Yy0xOTcuNiAxODYuNC00NDEuOCA0NjYtNTg5LjkgNzk0LjgtMTYuNS0zNS42LTEyMy41LTI3NC0yNTgtMjcxLjMtODUgMi44LTE1MC45IDkzLjItMTUwLjkgOTMuMiAyMDguNi0yLjcgMzgxLjQgNTg2LjUgMzgxLjQgNTg2LjV6Ii8+CgkJPC9nPgoJPC9nPgo8L3N2Zz4=" }