sfdcDigest Parameters

Performs an incremental sync, which extracts only changes to the Salesforce object since the last dataflow run. Valid values: true or false. Incremental sync:

• Is available if you have enabled data sync.
• Isn’t supported for Salesforce big objects.

Performs a one-time full extraction to synchronize the data in the dataset with data in the Salesforce object. Specify any value for this parameter.

After the full extraction, the dataflow performs an incremental extraction each time thereafter even though the fullRefreshToken parameter is included in the dataflow definition. To run a full extraction again, change the value of the fullRefreshToken parameter to a different value.

Incremental sync is available if you have enabled data sync.

An array of names of all fields from which you want to extract data from the specified Salesforce object. The sfdcDigest transformation doesn’t support extraction from all field types.

See Field Attributes.

A filter that restricts the records extracted from the specified Salesforce object. The sfdcDigest transformation extracts all records from the Salesforce object for which the filter is true. You can specify a structured or advanced filter.

See Filter Conditions Parameters.

Used for text and numeric fields that can be null. Numeric fields can have a literal null, while text fields can have “null”. A default value replaces a null value for the specified field. Enter a string value.

Example: "defaultValue": "0"

CRM Analytics field type associated with the specified field. Valid types are Text, Numeric, or Date. Any value, including numeric values, can be Text. For example, by default, fiscal quarter from Salesforce objects is Number. However, you can change it to Text. Specify a type to override the type determined by CRM Analytics.

Example: "type": "Text"

You can’t change a field’s type to Numeric or Date.

For date fields only. The difference, in months, between the first month of the fiscal year and the first month of the calendar year (January). For example, if the fiscal year starts in January, the offset is 0. If the fiscal year starts in October, the offset is 9.

Example: "fiscalMonthOffset": 9

This attribute also controls whether CRM Analytics generates fiscal date fields. To generate fiscal date fields, set fiscalMonthOffset to a value other than 0.

CRM Analytics doesn’t support fields with different fiscalMonthOffset values in the same dataset. Using different fiscalMonthOffset values can produce unexpected results when you filter by relative fiscal date ranges. We recommend that you set the same value for all fiscalMonthOffset attributes in a dataset.

For date fields only. Indicates whether the fiscal year is the year in which the fiscal year ends or begins. Because the fiscal year can start in one calendar year and end in another, you must specify which year to use for the fiscal year.

• If true, then the fiscal year is the year in which the fiscal year ends. The default is true.
• If false, then the fiscal year is the year in which the fiscal year begins.

Example: "isYearEndFiscalYear": true

This field is relevant only when fiscalMonthOffset is greater than 0.

CRM Analytics doesn’t support fields with different isYearEndFiscalYear values in the same dataset. Using different isYearEndFiscalYear values can produce unexpected results when you filter by relative fiscal date ranges. We recommend that you set the same value for all isYearEndFiscalYear attributes in a dataset.

For date fields only. The first day of the week for the calendar year and, if applicable, fiscal year. Use 0 to set the first day to be Sunday, 1 to set the first day to be Monday, and so on. Use -1 to set the first day to be on January 1. The default is -1.

Example: "firstDayOfWeek": 0

CRM Analytics doesn’t support fields with different firstDayOfWeek values in the same dataset. Using different firstDayOfWeek values can produce unexpected results when you filter by relative week date ranges. We recommend that you set the same value for all firstDayOfWeek attributes in a dataset.

For text fields only. Indicates whether the specified field has multiple values.

Example: "isMultiValue": false

For text fields only. Single character used to separate multiple values in the specified field when isMultiValue equals true. This value defaults to a semicolon (;) if you do not specify a value and isMultiValue equals true. Set to null when isMultiValue equals false.

Example: "multiValueSeparator": ";"

The maximum number of digits in a numeric value, or the length of a text value. For numeric values: Includes all numbers to the left and to the right of the decimal point (but excludes the decimal point character). Value must be from 1 through 18, inclusive. For text values: Value defaults to 255 characters, and must be from 1 through 32,000 characters, inclusive.

Example: "precision": 10

The number of digits to the right of the decimal point in a numeric value. Must be less than the precision value. Value must be from 0 through 17 characters, inclusive.

Example: "scale": 2

The field in the Salesforce object on which you want to apply a filter condition. Each filter condition in a structured filter uses the following syntax:

{ 
"field": "<field name>", 
"operator": "<operator>", 
"value": "<value>", 
"isQuoted": true|false}

The purpose depends on the context.

• operator can be used as a comparison operator–like =, <, and IN–that compares the field value against a constant value.
• operator can also be used as a logical operator (AND, OR, or NOT) that links multiple filter conditions together.

"filterConditions": [
   {
      "operator": "OR",
      "conditions": [
         {
            "field": "StageName",
            "operator": "=",
            "value": "Closed Won"
         },
         {
            "field": "Probability",
            "operator": ">=",
            "value": "90"
         }
      ]
   }
]

Indicates whether you quoted the string value in a filter condition.

"filterConditions": [
   {
   "field": "StageName",
   "operator": "IN",
   "value": "('Closed Won', 'Closed Lost')",
   "isQuoted": true
   }
]

"filterConditions": [
   {
   "field": "StageName",
   "operator": "IN",
   "value": ["Closed Won", "Closed Lost"],
   "isQuoted": false
   }
]

If you don’t include isQuoted for a filter on a string value, CRM Analytics assumes that the string value is not quoted and adds the quotes for you.