csv: appmixer.utils.csv.GetRows – Appmixer connector library

Basic Information

Name

appmixer.utils.csv.GetRows

Version

1.0.1

Visibility

Public

Description

Get rows from a CSV file.

Properties

Field	Type	Description
Use column names	toggle	-
Filter rows	toggle	Set to true if you want to define filters to return only rows that match your filter criteria.

Input Ports

in

Dynamic fields loaded from /component/appmixer/utils/csv/CreateInspector?outPort=out

Output Ports

out

Field	Type	Description
fileId		-
rows		-

Full Metadata

#metadata-viewer { display: none; }{ "name": "appmixer.utils.csv.GetRows", "author": "Camilo Manrique <camilo@client.io>", "description": "Get rows from a CSV file.", "version": "1.0.1", "dependencies": { "module": "1.0.1" }, "private": false, "properties": { "schema": { "properties": { "withHeaders": { "type": "boolean" }, "filterRows": { "type": "boolean" } }, "required": [ "withHeaders", "filterRows" ] }, "inspector": { "inputs": { "withHeaders": { "type": "toggle", "label": "Use column names", "index": 1, "defaultValue": true, "attrs": { "label": { "data-tooltip": "Set to true if the first row represents column names (CSV header) and you want to use them to identify the columns." } } }, "filterRows": { "type": "toggle", "label": "Filter rows", "index": 2, "defaultValue": true, "tooltip": "Set to true if you want to define filters to return only rows that match your filter criteria." } } } }, "inPorts": [ { "name": "in", "schema": { "type": "object" }, "source": { "url": "/component/appmixer/utils/csv/CreateInspector?outPort=out", "data": { "properties": { "withHeaders": "properties/withHeaders", "filterRows": "properties/filterRows" }, "transform": "./CreateInspector#getRowsInspector" } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "fileId", "value": "fileId" }, { "label": "rows", "value": "rows" } ] } ], "icon": "data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIyNCIgaGVpZ2h0PSIyNCIgdmlld0JveD0iMCAwIDI0IDI0Ij4KICA8ZyBpZD0iR3JvdXBfNTA5IiBkYXRhLW5hbWU9Ikdyb3VwIDUwOSIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoLTI2OCAtNTMxLjUwNSkiPgogICAgPHJlY3QgaWQ9IlJlY3RhbmdsZV8zMzUxIiBkYXRhLW5hbWU9IlJlY3RhbmdsZSAzMzUxIiB3aWR0aD0iMjQiIGhlaWdodD0iMjQiIHRyYW5zZm9ybT0idHJhbnNsYXRlKDI2OCA1MzEuNTA1KSIgZmlsbD0ibm9uZSIvPgogICAgPGcgaWQ9ImFwcC51dGlscy5jc3YiIHRyYW5zZm9ybT0idHJhbnNsYXRlKDI3MC4zMzcgNTM0KSI+CiAgICAgIDxwYXRoIGlkPSJTdWJ0cmFjdGlvbl8yIiBkYXRhLW5hbWU9IlN1YnRyYWN0aW9uIDIiIGQ9Ik0xOTI1LDgzaC0yVjc4YTMsMywwLDAsMSwzLTNoNWEzLjAwOCwzLjAwOCwwLDAsMSwyLjgzLDJIMTk0MGEzLDMsMCwwLDEsMywzdjNoLTJWODBhMSwxLDAsMCwwLTEtMWgtNy41ODVsLS40NzItMS4zMzRBMSwxLDAsMCwwLDE5MzEsNzdoLTVhMSwxLDAsMCwwLTEsMXY1WiIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoLTE5MjIuODM3IC03NSkiLz4KICAgICAgPHBhdGggaWQ9IlBhdGhfMjIxIiBkYXRhLW5hbWU9IlBhdGggMjIxIiBkPSJNMy44LjEyMkEzLjAyOCwzLjAyOCwwLDAsMCw2LjctMS41MjNhMS4zMTksMS4zMTksMCwwLDAsLjExMi0uNTE4Ljc3Ljc3LDAsMCwwLS44NC0uNzkxLjc4Ny43ODcsMCwwLDAtLjc4MS41NDIsMS40NzYsMS40NzYsMCwwLDEtMS40MjYuOTc3Yy0uOTg2LDAtMS42LS44MzUtMS42LTIuMjE3cy42Mi0yLjIsMS42LTIuMmExLjUwNywxLjUwNywwLDAsMSwxLjQxMS45NzIuODQ2Ljg0NiwwLDAsMCwuODM1LjU1Mi43MjQuNzI0LDAsMCwwLC43ODEtLjc1NywxLjM3OSwxLjM3OSwwLDAsMC0uMTgxLS42NTRBMy4wMjksMy4wMjksMCwwLDAsMy43NC03LjE2OGMtMi4wOCwwLTMuNCwxLjM0My0zLjQsMy42NDNTMS42MzEuMTIyLDMuOC4xMjJabTYuNzc5LDBjMS44NTUsMCwyLjk2NC0uOSwyLjk2NC0yLjMxNCwwLTEuMTA4LS42ODQtMS43MTktMi4xODctMi4wMDdsLS43MjMtLjEzN2MtLjc2Ny0uMTQ2LTEuMDg0LS4zNTItMS4wODQtLjcyMywwLS40MTUuMzgxLS43MDgsMS4wMy0uNzA4YTEuMTU5LDEuMTU5LDAsMCwxLDEuMTM4LjYxLjg5Ljg5LDAsMCwwLC44NDUuNDgzLjY5Mi42OTIsMCwwLDAsLjc1Mi0uNy45ODcuOTg3LDAsMCwwLS4wNzMtLjM4NiwyLjYzMSwyLjYzMSwwLDAsMC0yLjY3Ni0xLjQxMWMtMS42MjEsMC0yLjguODc0LTIuOCwyLjIzMSwwLDEuMDc0LjczMiwxLjc2MywyLjEzNCwyLjAyNmwuNzI4LjEzN2MuODM1LjE2MSwxLjEzMy4zNjEsMS4xMzMuNzUyLDAsLjQzLS40NTQuNzQyLTEuMTUyLjc0MkExLjM1MywxLjM1MywwLDAsMSw5LjMyOC0xLjlhLjg3Ni44NzYsMCwwLDAtLjgxMS0uNDc0LjcyOS43MjksMCwwLDAtLjc3Ni43NTIsMS4xMTYsMS4xMTYsMCwwLDAsLjA5My40NDRDOC4xMjYtLjQ1NCw5LjA0OS4xMjIsMTAuNTc4LjEyMlpNMTcuMy4xMDdhMS40LDEuNCwwLDAsMCwxLjQ0LTEuMDg5TDIwLjUtNS44NDVhMS4zMTQsMS4zMTQsMCwwLDAsLjA4OC0uNDc0LjgzOC44MzgsMCwwLDAtLjkyMy0uODM1LjgzNi44MzYsMCwwLDAtLjg5NC42OTNMMTcuMzYxLTEuNzUzaC0uMDM5TDE1LjktNi40MzZhLjg2OC44NjgsMCwwLDAtLjkyOC0uNzE4Ljg2Mi44NjIsMCwwLDAtLjk0Ny44NjQsMS41MywxLjUzLDAsMCwwLC4wODMuNWwxLjc0OCw0LjhBMS40LDEuNCwwLDAsMCwxNy4zLjEwN1oiIHRyYW5zZm9ybT0idHJhbnNsYXRlKC0wLjMzNyAxOCkiLz4KICAgIDwvZz4KICA8L2c+Cjwvc3ZnPgo=" }