smartsheet: appmixer.smartsheet.core.MoveRows

Basic Information

Name

appmixer.smartsheet.core.MoveRows

Version

1.0.0

Visibility

Public

Description

Moves rows from the sheet specified in the URL to (the bottom of) another sheet.

Input Ports

in

Field	Type	Description
Sheet Id	number	Sheet Id of the sheet being accessed.
Include	multiselect	A comma-separate list of row elements to move in addition to the cell data.
Ignore Rows Not Found	toggle	true or false: default is false. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are moved).
Row Ids	textarea	The Ids of the rows to move or copy from the source sheet. JSON array. Example: [51092505,340284765]
To Sheet Id	number	The Id of the destination sheet.

Output Ports

out

Field	Type	Description
Destination Sheet Id		-
Row Mappings		-

Full Metadata

#metadata-viewer { display: none; }{ "version": "1.0.0", "name": "appmixer.smartsheet.core.MoveRows", "author": "Appmixer <info@appmixer.com>", "description": "Moves rows from the sheet specified in the URL to (the bottom of) another sheet.", "private": false, "inPorts": [ { "name": "in", "schema": { "type": "object", "required": [ "sheetId" ], "properties": { "sheetId": { "type": "number" }, "include": { "type": [ "array", "string" ] }, "ignoreRowsNotFound": { "type": "boolean", "default": false }, "rowIds": { "description": "The Ids of the rows to move or copy from the source sheet.", "type": "string", "path": "rowIds" }, "to|sheetId": { "description": "The Id of the destination sheet.", "type": "number", "path": "to.sheetId" } } }, "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" } } }, "include": { "type": "multiselect", "index": 2, "label": "Include", "tooltip": "A comma-separate list of row elements to move in addition to the cell data.", "options": [ { "content": "attachments", "value": "attachments" }, { "content": "discussions", "value": "discussions" } ] }, "ignoreRowsNotFound": { "type": "toggle", "index": 3, "label": "Ignore Rows Not Found", "tooltip": "true or false: default is false. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are moved).", "defaultValue": false }, "rowIds": { "type": "textarea", "index": 4, "label": "Row Ids", "tooltip": "The Ids of the rows to move or copy from the source sheet. JSON array. Example: [51092505,340284765]" }, "to|sheetId": { "type": "number", "index": 5, "label": "To Sheet Id", "tooltip": "The Id of the destination sheet.", "source": { "url": "/component/appmixer/smartsheet/core/ListSheets?outPort=out", "data": { "transform": "./ListSheets#sheetsToSelectArray" } } } } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Destination Sheet Id", "value": "destinationSheetId" }, { "label": "Row Mappings", "value": "rowMappings", "schema": { "description": "Array of rowMapping objects.", "type": "array", "items": { "type": "object", "properties": { "from": { "description": "Row Id in the source sheet.", "type": "number", "example": 1 }, "to": { "description": "Row Id in the destination sheet.", "type": "number", "example": 1 } } } } } ] } ], "auth": { "service": "appmixer:smartsheet" }, "icon": "data:image/svg+xml;base64,PHN2ZyB2ZXJzaW9uPSIxLjIiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgdmlld0JveD0iMCAwIDEyMzggMTUxNCIgd2lkdGg9IjEyMzgiIGhlaWdodD0iMTUxNCI+Cgk8dGl0bGU+c21hcnRzaGVldC1sb2dvLWJsdWUtbmV3LXN2ZzwvdGl0bGU+Cgk8c3R5bGU+CgkJLnMwIHsgZmlsbDogIzBlMjk0NyB9IAoJPC9zdHlsZT4KCTxnIGlkPSJMYXllciI+CgkJPGcgaWQ9IkxheWVyIj4KCQkJPHBhdGggaWQ9IkxheWVyIiBjbGFzcz0iczAiIGQ9Im02MTUgMTIwNGMwIDAgMjYzLjQtNjU3LjggNjIyLjktMTA5Ni4zIDAgMTgwLjkgMCA1MzkuOSAwIDgxMS4zIDAgMTUwLjctNS41IDI3NC0xMSAzMjguOC01LjUgNTQuOS0xOS4yIDkwLjUtNDEuMSA5Ni0xNi41IDIuNy00My45LTIuOC05Ni4xLTYzLjEtNDYuNi01NC44LTkzLjMtMTU2LjItOTMuMy0xNTYuMmwtNS41LTExLTguMiA4LjNjLTIuNyAwLTE0NS40IDE0Mi41LTUxNS45IDI3NC0yMDguNSA3NC00MTEuNSAxMDkuNy00NjYuNCAxMTcuOSA1LjUtMjEuOSAxNi40LTc2LjggMTYuNC0xNTAuOCAwLTk1LjkgMC0xMjQ2LjkgMC0xMzYyLjFoMTIxNS42Yy0xOTcuNiAxODYuNC00NDEuOCA0NjYtNTg5LjkgNzk0LjgtMTYuNS0zNS42LTEyMy41LTI3NC0yNTgtMjcxLjMtODUgMi44LTE1MC45IDkzLjItMTUwLjkgOTMuMiAyMDguNi0yLjcgMzgxLjQgNTg2LjUgMzgxLjQgNTg2LjV6Ii8+CgkJPC9nPgoJPC9nPgo8L3N2Zz4=" }