Picklist Metadata
Pull all Picklist values, per Object, or optionally just a single specified Object's picklists.
Results are loaded to table ss_SysPicklist
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_MetaPick 'DEMO', 'All'
SQL-SALES ss_SysPicklist run date: 2023-11-09 -------------------
23:29:32: Using Env|Schema: DEMO|dbo
23:29:32: Starting ss_SysPicklist retrieval for: All Objects
23:29:34: Connection method BULK & SOAP API
23:29:34: Drop existing ss_SysPicklist if exists and recreate
23:30:57: Load to dbo.ss_SysPicklist
-----------------------------------------------------------------
Example of Use - Single
exec ss_MetaPick 'DEMO', 'Account'
SQL-SALES ss_SysPicklist run date: 2023-11-09 -------------------
23:37:52: Using Env|Schema: DEMO|dbo
23:37:52: Starting ss_SysPicklist retrieval for: Account
23:37:55: Connection method BULK & SOAP API
23:37:55: Drop existing ss_SysPicklist if exists and recreate
23:37:58: Load to dbo.ss_SysPicklist
-----------------------------------------------------------------
ss_SysPicklist table
ObjectName (Object api Name)
FieldName (Field api Name)
Value (Picklist Value)
Label (Picklist Label)
Active (boolean)
DefaultValue (boolean)