smartsheet: appmixer.smartsheet.core.GetRow – Appmixer connector library

Basic Information

Name

appmixer.smartsheet.core.GetRow

Version

1.0.0

Visibility

Public

Description

Gets the row specified in the URL.

Input Ports

in

Field	Type	Description
Sheet Id	number	Sheet Id of the sheet being accessed.
Row Id	number	Row Id in the sheet being accessed.

Output Ports

out

Field	Type	Description
Id		-
Sheet Id		-
Row Number		-
Expanded		-
Cells		-
Created At		-
Modified At		-

Full Metadata

#metadata-viewer { display: none; }{ "version": "1.0.0", "name": "appmixer.smartsheet.core.GetRow", "author": "Appmixer <info@appmixer.com>", "description": "Gets the row specified in the URL.", "private": false, "inPorts": [ { "name": "in", "schema": { "type": "object", "required": [ "sheetId", "rowId" ], "properties": { "sheetId": { "type": "number" }, "rowId": { "type": "number" } } }, "inspector": { "inputs": { "sheetId": { "type": "number", "index": 0, "label": "Sheet Id", "tooltip": "<p>Sheet Id of the sheet being accessed.</p>", "source": { "url": "/component/appmixer/smartsheet/core/ListSheets?outPort=out", "data": { "transform": "./ListSheets#sheetsToSelectArray" } } }, "rowId": { "type": "number", "index": 1, "label": "Row Id", "tooltip": "<p>Row Id in the sheet being accessed.</p>" } } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Id", "value": "id" }, { "label": "Sheet Id", "value": "sheetId" }, { "label": "Row Number", "value": "rowNumber" }, { "label": "Expanded", "value": "expanded" }, { "label": "Cells", "value": "cells", "schema": { "description": "Cells objects.", "type": "array", "items": { "type": "object", "properties": { "columnId": { "type": "number", "description": "The Id of the column that the cell is located in.", "example": 1 }, "columnType": { "type": "string", "description": "Only returned if the include query string parameter contains **columnType**.", "example": "TEXT_NUMBER" }, "value": { "anyOf": [ { "type": "string" }, { "type": "number" }, { "type": "boolean" } ], "description": "A string, number, or a Boolean value -- depending on the cell type and the data in the cell. Cell values larger than 4000 characters are silently truncated. An empty cell returns no value.", "example": "Sample cell value" }, "displayValue": { "type": "string", "description": "Visual representation of cell contents, as presented to the user in the UI.", "example": "$1,000.00" } } } } }, { "label": "Created At", "value": "createdAt" }, { "label": "Modified At", "value": "modifiedAt" } ] } ], "auth": { "service": "appmixer:smartsheet" }, "icon": "data:image/svg+xml;base64,PHN2ZyB2ZXJzaW9uPSIxLjIiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgdmlld0JveD0iMCAwIDEyMzggMTUxNCIgd2lkdGg9IjEyMzgiIGhlaWdodD0iMTUxNCI+Cgk8dGl0bGU+c21hcnRzaGVldC1sb2dvLWJsdWUtbmV3LXN2ZzwvdGl0bGU+Cgk8c3R5bGU+CgkJLnMwIHsgZmlsbDogIzBlMjk0NyB9IAoJPC9zdHlsZT4KCTxnIGlkPSJMYXllciI+CgkJPGcgaWQ9IkxheWVyIj4KCQkJPHBhdGggaWQ9IkxheWVyIiBjbGFzcz0iczAiIGQ9Im02MTUgMTIwNGMwIDAgMjYzLjQtNjU3LjggNjIyLjktMTA5Ni4zIDAgMTgwLjkgMCA1MzkuOSAwIDgxMS4zIDAgMTUwLjctNS41IDI3NC0xMSAzMjguOC01LjUgNTQuOS0xOS4yIDkwLjUtNDEuMSA5Ni0xNi41IDIuNy00My45LTIuOC05Ni4xLTYzLjEtNDYuNi01NC44LTkzLjMtMTU2LjItOTMuMy0xNTYuMmwtNS41LTExLTguMiA4LjNjLTIuNyAwLTE0NS40IDE0Mi41LTUxNS45IDI3NC0yMDguNSA3NC00MTEuNSAxMDkuNy00NjYuNCAxMTcuOSA1LjUtMjEuOSAxNi40LTc2LjggMTYuNC0xNTAuOCAwLTk1LjkgMC0xMjQ2LjkgMC0xMzYyLjFoMTIxNS42Yy0xOTcuNiAxODYuNC00NDEuOCA0NjYtNTg5LjkgNzk0LjgtMTYuNS0zNS42LTEyMy41LTI3NC0yNTgtMjcxLjMtODUgMi44LTE1MC45IDkzLjItMTUwLjkgOTMuMiAyMDguNi0yLjcgMzgxLjQgNTg2LjUgMzgxLjQgNTg2LjV6Ii8+CgkJPC9nPgoJPC9nPgo8L3N2Zz4=" }