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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive