Salesforce.Reports
A Salesforce org's reports, each report's detail rows 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.Reports(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, Folder and Id, a row per report, by name.
Remarks
- A report's Data is its detail rows, at most 2,000 (Salesforce's Analytics API runs it), its columns named by their labels. Amounts are numbers; other values as the report shows them.
- Signed in in your browser, the first time this computer reads the org.
Examples
One report's rows
Salesforce.Reports("https://login.salesforce.com"){[Name = "Open opportunities"]}[Data]Result: not shown here: it needs a Salesforce org and a sign-in.