Salesforce Connector for C# How to Get Report

Introduction

In this article we will delve deeper into Salesforce and C# integration, and will learn how to get report. We are continuing from where we left off. By this time, you must have installed ODBC PowerPack, created ODBC Data Source, and configured authentication settings in your Salesforce account .

So, let's not waste time and begin.

Use Query Builder to generate SQL query

The first thing you have to do is open Query Builder:

ZappySys API Driver - Salesforce

Amazon Ads Connector can be used to get Amazon advertisements using Amazon Advertisements API, download various advertisement-related reports.

SalesforceDSN
Then simply select the Get Report endpoint (action).
Continue by configuring the Required parameters. You can also set optional parameters too.
Move on by hitting Preview Data button to preview the results.

If you see the results you need, simply copy the generated query:

Get Report

Required Parameters
Metrics	Select the value from the dropdown
Optional Parameters
Record Type	keywords
State Filter
Campaign Type
Segment
Report Date (yyyyMMdd)

SELECT * FROM get_report
WITH
(
    "RecordType" = 'keywords',
    "ReportDate" = 'today',
    "Metrics" = 'abcd-1234-metrics'
)

That's it! You can use this query in C#.

Let's not stop here and explore SQL query examples, including how to use them in Stored Procedures and Views (virtual tables) in the next steps.

SQL query examples

Use these SQL queries in your C# data source:

How to Get report

SELECT * FROM get_report
WITH
(
    "RecordType" = 'keywords',
    "ReportDate" = 'today',
    "Metrics" = 'abcd-1234-metrics'
)

Get Report in C#

Use this code snippet to read the data using SalesforceDSN data source:

"SalesforceDSN" ;
Press F5 to run the code and read the data:

Here is the code in text format:

using System;
using System.Data.Odbc;

namespace ConsoleApp {
    class Program {
        static void Main() {
            var dsn = "SalesforceDSN";
            using (var conn = new OdbcConnection(String.Format("DSN={0}", dsn)))
            {
                conn.Open();
                var cmd = new OdbcCommand("SELECT * FROM Products", conn);
                
                //Increase the timeout duration from the default 30 seconds, which may be insufficient in certain scenarios
                cmd.CommandTimeout=600; // 600-Seconds
                
                var rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    for (int i = 0; i < rdr.FieldCount; i++)
                    {
                            Console.Write("{0}\t", rdr[i]);
                    }
                    Console.WriteLine();
                }
            }
            Console.ReadKey();
        }
    }
}

Download Salesforce Connector for C# Documentation