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":"AnnualRevenue FROM Lead",
3   "targetObject":"bigDemo__b",
4   "targetFieldMap":{
5      "AnnualRevenue":"cf0__c"
6   },
7   "targetValueMap":{
8      "Today Count":"cf3__c"
9   }
10}
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; one level relationship fields (no subqueries); GROUP BY; aggregate functions COUNT(field),​ SUM(), AVG(). Required 35.0
targetFieldMap Map<String, String> A mapping of SOQL query fields to target object fields. Required 35.0
targetValueMap Map<String, String> A mapping of literal values to target object fields. Optional 37.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