Input · Databases and cloud

Salesforce Reader

Reads the records of a Salesforce object through a saved connection, or the result of a SOQL query you write. An object is read whole unless you set a row limit.

Also known as: CRM

How it works

Add it from Add data source → Salesforce with a saved Salesforce credential. Mode is object, where Object names the object to read, or soql, where you write the SOQL query yourself. In object mode, Row limit caps the records read; blank reads every record, and the node warns when the limit truncated the source.

Inputs and outputs

Settings

Example

Every account in the org: Mode object, Object Account, Row limit blank. For only the fields you need, switch to soql with SELECT Id, Name, Industry FROM Account.

More in Databases and cloud

• DB Reader — Reads a table from a PostgreSQL or MySQL database through a saved connection. You pick the schema and table.
• S3 Reader — Reads a file stored in an Amazon S3 bucket, or another S3-compatible store, into a table. A pattern such as s3://bucket/exports/*.csv reads every matching object into one table.
• Snowflake Reader — Reads a table from Snowflake through a saved connection, or the result of a SQL query you write. A table is read whole unless you set a row limit.
• Strava Reader — Reads your Strava activities, athlete profile or activity streams through your own connected Strava app.