Skip to main content

Get > 2000 records from Salesforce reports with python.

Project description

salesforce-reporting-chunked

Get > 2000 rows from Your Date-Sortable Salesforce Reports

salesforce-reporting-chunks is a wrapper around cghall's salesforce-reporting module. The Salesforce API limits output to 2000 rows for a given report. salesforce-reporting-chunked works around this limitation by returning a generator that simply pulls a date range from your report a given number of days at a time.

Install

pip install salesforce-reporting-chunked

Documentation

Documentation at readthedocs.

Usage

  1. Obtain a Salesforce security token.
  2. Choose your API version
  3. Get your report id from the Salesforce report URL
from salesforce_reporting_chunked import chunk_report_by_date

CONFIG = {
    "security_token": "REPLACE WITH YOUR TOKEN",
    "username": "REPLACE WITH YOUR USERNAME",
    "password": "REPLACE WITH YOUR PASSWORD",
    "api_version": "v38.0"
}

FIELDNAMES = [
    "First Name",
    "Last Name",
    "Date Column", # this is the magic column use for chunking.
    "Corhuscorrated Plethanth",
    "Other Column",
]

REPORT_ID = "YOURREPORTID"

>>> data = chunk_report_by_date(
    CONFIG,
    REPORT_ID,
    FIELDNAMES,
    date_fieldname="Date Column",
    start_date="2018-01-01",
    start_date="2019-01-31",
)
>>> next(data)
OrderedDict([('First Name', 'Fred'),('Last Name', 'Garvin'),('DATE_COLUMN_NAME', '2018-01-01'),('Corhuscorrated Plethanth', True),('Other Column': 'Yep. Another')])

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for salesforce-reporting-chunked, version 0.1.7
Filename, size File type Python version Upload date Hashes
Filename, size salesforce-reporting-chunked-0.1.7.tar.gz (5.6 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page