Retrieving Salesforce Metadata
Retrieving Salesforce Metadata
DBAmp retrieves Salesforce metadata information in two ways:
-
SF_Metadata—a DBAmp stored procedure that accesses the Salesforce Metadata API
-
tooling tables—tables within the Salesforce Tooling API
Note that if you use SF_Metadata
:
-
The metadata is returned to an XML type column in Salesforce. You must know about the XML column type and be able to use XQuery expressions in SQL
SELECT
statements. -
SF_Metadata
implements the Salesforce Metadata API LIST and RETRIEVE functions. These functions require specific type and member inputs as defined in the Salesforce Metadata API Developer Guide.
You must have an understanding of metadata types as described in the Salesforce Metadata Developer API Guide.