Salesforce.Data
A Salesforce org's objects you may query, each object's records as a table.
Group: Online services. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Salesforce.Data(optional loginUrl as any, optional options as nullable record) as table| Parameter | Type | Description |
|---|---|---|
loginUrl | any optional | The login address: https://login.salesforce.com (the default), a sandbox's test.salesforce.com, or your My Domain. |
options | nullable record optional | ApiVersion: the REST API's version (62 unless you give another). |
Returns
table. Name, Data, Label and Kind ("Table"), a row per object.
Remarks
- An object's Data has its fields but binary and compound ones (address, location), typed as Salesforce types them: int and long Int64.Type, double, currency and percent number, boolean logical, date date, datetime datetimezone, the rest text.
- Records are read with SOQL, every page.
- Signed in in your browser, the first time this computer reads the org.
Compared with Power Query
Of Power Query's options only ApiVersion is read; the others are accepted and change nothing.
Examples
The Account object
Salesforce.Data("https://login.salesforce.com", [ApiVersion = 62]){[Name = "Account"]}[Data]Result: not shown here: it needs a Salesforce org and a sign-in.