JDBC Driver for Salesforce

Build 22.0.8462

GetCustomReport

Get the custom report by report Id.

Input

Name Type Description
ReportId String The ID of the report.
ReportUrl String The base url of the report, like: https://na2.salesforce.com/
ReportFilter String Filter in the form of SQL condition (EX: WHERE CREATE_DATE>"2015-01-01"). Used to sort and get specific rows. Note, the name of the column being filtered must be the full column name (including the table name if applicable) and not its label. If you want to use labels for filtering or sorting the data, consider creating a report schema with the stored procedure CreateReportSchema and then querying from the created schema.

Result Set Columns

Name Type Description
* String Output the records in report.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462