Newer Version Available

This content describes an older version of this product. View Latest

Async Query Input

Create an asynchronous query job.

This feature is currently available to select customers through a pilot program. To be nominated to join this pilot program, contact salesforce.com. Additional terms and conditions may apply to participate in the pilot program. Please note that pilot programs are subject to change, and as such, we cannot guarantee acceptance into this pilot program or a particular time frame in which this feature can be enabled. Any unreleased services or features referenced in this document, press releases, or public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.

Note

Root XML tag
<asyncQueryInput>
JSON example
1{
2    "query":"select NewValue from FieldHistory​Archive where ArchiveField​Name = '​NumberOf​Employees'",
3    "targetFieldMap": {
4        "NewValue":"TargetNewValue__c"
5    },
6    "targetObject":"MyResult__c"
7}
Properties
Name Type Description Required or Optional Available Version
query String SOQL query string. The pilot release supports these SOQL features in WHERE statements: simple equality filtering; AND and OR clauses; 1-level relationship fields (no subqueries); GROUP BY; aggregate functions COUNT(field),​ SUM(), AVG(). Required 35.0
targetFieldMap String A map showing which SOQL query fields correspond to which target object fields. Required 35.0
targetObject String An object that stores the results of the SOQL query. The object can be a standard or custom Salesforce object, a big object, or an external object. Required 35.0