Report on/Export all Salesforce fields that are used in data sets/flows
Hello,
I was wondering if there is any way to pull a list of all fields that are being used from Salesforce? We have thousands of fields that we use from SF and every month new fields are added or discontinued by our developers. The developers give us a list of the new fields but we'd like an easy way to track down what deperacted fields we are still using in data sets and flows.
Thank you.
Comments
-
Options that I see:
- Filter all datasets to only show Salesforce datasets and export them all and combine in Excel to get a list of ALL fields being used.
- If you're code savvy it would be better to use the Domo API get retrieve this. You can get a list of all datasets and their columns
The endpoint for all datasets is
https://api.domo.com/v1/datasets
The endpoint for all columns in a dataset is
https://api.domo.com/v1/datasets/{DatasetID}
The only complication seems to be that the neither response explicitly states which connector was used for the dataset so you'd have to have some way to filter which ones are Salesforce. My naming convention for datasets starts with the system aka "Salesforce - Cases" so i'm able to just filter on if the name contains Salesforce, i don't know if you'll have this luxury. Might be another endpoint to get this info I just haven't had to yet.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive