SalesforceQuery()
Executes a query against SalesForce, caching the result if necessary in the given cache region
Usage
QUERY = SalesforceQuery(
email,
passwordtoken,
query,
cacheage,
timeout,
region,
all
)
| Argument | Summary |
|---|---|
| SalesFoce Email address | |
| passwordtoken | SalesForce password and token concatenated together |
| query | SalesForce SOQL statement |
| cacheage | Age of the cache in seconds. If this is 0 (default) then the query is not cached. Otherwise, if the query is within the time given then the cached version is returned [optional] |
| timeout | the time in milliseconds, that the connection will wait for a response [optional] |
| region | the cache region to use, defaults to SALESFORCE [optional] |
| all | boolean indicating whether to query all. Defaults to false [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
SalesforceQuery( email=?, passwordtoken=?, query=?, cacheage=?, timeout=?, region=?, all=? );
Supports passing parameters as a structure using ArgumentCollection:
SalesforceQuery( ArgumentCollection={
email : ?,
passwordtoken : ?,
query : ?,
cacheage : ?,
timeout : ?,
region : ?,
all : ?
} );