function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jim_lukensjim_lukens 

How to Get SFDC ID instead of Text in Reference Fields like User Profile ID?

I apologize if this is a known response. Want to get the ID instead of the name or ideally both one column for each.

Connector returns on users queries the Profile ID as text name instead of SFDC ID. How do you use connector to get the ID. The ID is by far more useful. Same for other areas like this where a reference object is given.

Thank you
Surfwriter.comSurfwriter.com
Hi Jim,
Have you looked at Options -> Related Names?
AMartinAMartin
Hi Jim,
 
Without rewriting parts of the code there doesn't seem to be a way to get the Excel Connector to return the Profile ID or Role ID instead of the text names. 
 
If all you need is the the ID fields of a table like the User table, you can use the SOQL Tester on Apex Explorer to query tables and it will return all reference fields with their ID's instead of text. 
 
You can then select the rows in the results list, copy and paste into Excel.
 
hth.
 
Aiden