Provides introspection into the metadata of the given Salesforce objects. This function is most useful during development when determining the available object fields and their types.
a!sfcDescribeSObjects( scsExternalSystemKey, usePerUserCredentials, endpoint)
scsExternalSystemKey: (Text) The key from the Third Party Credentials admin console page that corresponds to the set of credentials that should be used to authenticate.
usePerUserCredentials: (Boolean) If
true the credentials set in the Third-Party Credentials settings page by the current user running the expression will be used. If
false the site-wide credential values will be used.
endpoint: (Text) The Salesforce endpoint URL to use for authentication. Possible values are
"https://login.salesforce.com/services/Soap/u/27.0", which is used for production and development environments, and
"https://test.salesforce.com/services/Soap/u/27.0", which is used for the Salesforce "sandbox" test environment. Update the
27.0 portion of the endpoint URL to match the version of the API that you are accessing. As a best practice, create a constant for this value.
sObjectNames: (Text Array) The names of the Salesforce objects whose metadata will be returned
The function returns the standard connector result dictionary described in the main Connectors page.
If successful, the returned
result field will contain list of dictionaries that each have two fields:
nameand another for that attribute's
typeas reported by Salesforce.
Note: This function returns a list in the
result field. Indexing into the list is necessary in order to retrieve the details for a given sObject. See example.
Retrieve a Attributes of a Given sObject
Copy and paste the expression into the Interface Designer, save it, then call the interface in a Tempo Report to test.