salesforce: appmixer.salesforce.crm.Query – Appmixer connector library

Basic Information

Name

appmixer.salesforce.crm.Query

Version

1.0.0

Visibility

Public

Description

Executes the specified SOQL query. See more in the SOQL Docs .

Input Ports

in

Field	Type	Description
SQL Query	text	Enter an SOQL query. See more in the SOQL Docs .
Output Type	select	Choose whether you want to receive the result set as one complete list, or one row at a time or stream the rows to a file. For large datasets, streaming the rows to a file is the most efficient method.

Output Ports

out

Dynamic variables loaded from /component/appmixer/salesforce/crm/Query?outPort=out

emptyResult

Field	Type	Description
totalSize		-
done		-
records		-

Full Metadata

#metadata-viewer { display: none; }{ "name": "appmixer.salesforce.crm.Query", "author": "Vladimir Talas <lades@client.io>", "icon": "data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCA5OTkgNjk5LjI0MSI+PGRlZnM+PHN0eWxlPi5he2ZpbGw6IzAwYTFlMDt9PC9zdHlsZT48L2RlZnM+PHBhdGggY2xhc3M9ImEiIGQ9Ik00MTYuMjI0LDc2Ljc2M2MzMi4yMTktMzMuNTcsNzcuMDc0LTU0LjM5MSwxMjYuNjgyLTU0LjM5MSw2NS45NDYsMCwxMjMuNDgsMzYuNzcyLDE1NC4xMiw5MS4zNjFhMjEyLjk4NCwyMTIuOTg0LDAsMCwxLDg3LjEwNi0xOC41MTRjMTE4Ljk0LDAsMjE1LjM2OCw5Ny4yNjgsMjE1LjM2OCwyMTcuMjQ3UzkwMy4wNzIsNTI5LjcyNyw3ODQuMTMyLDUyOS43MjdBMjEzLjc0LDIxMy43NCwwLDAsMSw3NDEuNzEsNTI1LjVhMTU3LjQzNiwxNTcuNDM2LDAsMCwxLTIwNi4yODksNjQuNzkzLDE3OS42MjEsMTc5LjYyMSwwLDAsMS0zMzMuOTExLTguMTI2LDE2NC43NzUsMTY0Ljc3NSwwLDAsMS0zNC4yNjgsMy41NzJDNzUuMTU1LDU4NS43NC41LDUxMC4zMTcuNSw0MTcuMjYyQTE2OC43NDEsMTY4Ljc0MSwwLDAsMSw4My44NzgsMjcxLjMyNWExOTIuODY2LDE5Mi44NjYsMCwwLDEtMTUuOTY3LTc3LjA2QzY3LjkxMSw4Ny4yNSwxNTQuNzkuNSwyNjEuOTQ4LjVBMTkzLjc5MSwxOTMuNzkxLDAsMCwxLDQxNi4yMjQsNzYuNzYzIiB0cmFuc2Zvcm09InRyYW5zbGF0ZSgtMC41IC0wLjUpIi8+PC9zdmc+", "description": "Executes the specified SOQL query. See more in the <a href='https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm' target='_blank'> SOQL Docs </a>.", "trigger": true, "webhook": true, "version": "1.0.0", "auth": { "service": "appmixer:salesforce" }, "inPorts": [ { "name": "in", "schema": { "type": "object", "properties": { "query": { "type": "string" }, "outputType": { "type": "string" } } }, "inspector": { "inputs": { "query": { "type": "text", "index": 0, "label": "SQL Query", "tooltip": "Enter an SOQL query. See more in the <a href='https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm' target='_blank'> SOQL Docs </a>." }, "outputType": { "type": "select", "options": [ { "content": "All items at once", "value": "array" }, { "content": "One item at a time", "value": "object" }, { "content": "Save items to file", "value": "file" } ], "defaultValue": "array", "index": 1, "label": "Output Type", "tooltip": "Choose whether you want to receive the result set as one complete list, or one row at a time or stream the rows to a file. For large datasets, streaming the rows to a file is the most efficient method." } } } } ], "outPorts": [ { "name": "out", "source": { "url": "/component/appmixer/salesforce/crm/Query?outPort=out", "data": { "properties": { "generateOutputPortOptions": true }, "messages": { "in/outputType": "inputs/in/outputType" } } } }, { "name": "emptyResult", "options": [ { "label": "totalSize", "value": "totalSize", "schema": { "example": 25 } }, { "label": "done", "value": "done", "schema": { "example": true } }, { "label": "records", "value": "records", "schema": { "type": "array", "items": { "type": "object", "properties": {} } } } ] } ] }