Object Metadata
Pull all the objects in your Salesforce instance, or optionally just a single specified one.
Results are loaded to table ss_SysObject
Parameters
Parameter | Purpose |
@ObjectName | Salesforce Object Name (for example Account). alternatively pass "All" to retrieve all Objects. |
@Env | SQL Sales Environment Name, see Setup |
@Special1 | Future use, not currently used |
@Special2 | Future use, not currently used |
Example of Use – All
exec ss_MetaObject 'DEMO', 'All'
SQL-SALES ss_SysObject run date: 2023-11-09 ----------------------
23:04:16: Using Env|Schema: DEMO|dbo
23:04:16: Starting ss_SysObject retrieval for: All Objects
23:04:19: Connection method BULK & SOAP API
23:04:19: Drop existing ss_SysObject if exists and recreate
23:04:21: Load to dbo.ss_SysObject
-----------------------------------------------------------------
Example of Use – Single
exec ss_MetaObject 'DEMO', 'Account'
SQL-SALES ss_SysObject run date: 2023-11-09 ----------------------
23:06:59: Using Env|Schema: DEMO|dbo
23:06:59: Starting ss_SysObject retrieval for: Account
23:07:02: Connection method BULK & SOAP API
23:07:02: Drop existing ss_SysObject if exists and recreate
23:07:04: Load to dbo.ss_SysObject
-----------------------------------------------------------------
ss_SysObject table
Name (api Name)
Label (Label)
KeyPrefix (where available/relevant, Object Id first 3 characters)
Replicateable (boolean)
Queryable (boolean)
Createable (boolean)
Updateable (boolean)
Deletable (boolean)
Searchable (boolean)
Retrieveable (boolean)
Layoutable (boolean)
Triggerable (boolean)
Mergeable (boolean)
Custom (boolean)