将Salesforce报告导出为CSV (Java)

import com.sforce.soap.partner.Connector;
import com.sforce.soap.partner.PartnerConnection;
import com.sforce.soap.partner.QueryResult;
import com.sforce.soap.partner.sobject.SObject;
import com.sforce.ws.ConnectionException;
import com.sforce.ws.ConnectorConfig;

import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class SalesforceReportExporter {

    private static final String USERNAME = "your_salesforce_username";
    private static final String PASSWORD = "your_salesforce_password";
    private static final String SECURITY_TOKEN = "your_salesforce_security_token";

    public static void main(String[] args) {
        try {
            // 创建Salesforce连接配置
            ConnectorConfig config = new ConnectorConfig();
            config.setUsername(USERNAME);
            config.setPassword(PASSWORD + SECURITY_TOKEN);

            // 创建PartnerConnection对象
            PartnerConnection connection = Connector.newConnection(config);

            // 执行SOQL查询获取报告数据
            String soqlQuery = "SELECT Field1, Field2, Field3 FROM Your_Report";
            QueryResult queryResult = connection.query(soqlQuery);

            // 将报告数据写入CSV文件
            FileWriter csvWriter = new FileWriter("report.csv");
            List<String> headers = new ArrayList<>();
            headers.add("Field1");
            headers.add("Field2");
            headers.add("Field3");
            writeCsvHeader(csvWriter, headers);
            writeCsvData(csvWriter, queryResult.getRecords());
            csvWriter.flush();
            csvWriter.close();

            System.out.println("报告已成功导出为CSV文件。");

        } catch (ConnectionException | IOException e) {
            e.printStackTrace();
        }
    }

    private static void writeCsvHeader(FileWriter writer, List<String> headers) throws IOException {
        for (String header : headers) {
            writer.append(header);
            writer.append(",");
        }
        writer.append("\n");
    }

    private static void writeCsvData(FileWriter writer, SObject[] records) throws IOException {
        for (SObject record : records) {
            writer.append(record.getField("Field1").toString());
            writer.append(",");
            writer.append(record.getField("Field2").toString());
            writer.append(",");
            writer.append(record.getField("Field3").toString());
            writer.append("\n");
        }
    }
}