How to Export Organization Relationship System Record ID?

Austin Stallman

I have a relationship query in RE that returns about 50 organization relationships when I run the query, however I need the organization relationship's system record ID, which is not available as a field in query. I tried creating an export based off of that query since organization relationship system record ID is a field in export. Whenever I ran the export though I got 0 rows presumably because the export type is individual relationship not organization relationship. Is there a way to export organization relationships that I cannot find? Alternatively, is there a way to output organization relationship system record ID in a relationship query? Thanks for the help.

Heather MacKenzie

You mean when organizations are relationships with each other? Like a parent bank and a specific branch, for example?

Jeannie Goings

You need to use export to get this information out of the system. Under relationships, select organization. When you click on ID, you then select which values and how many of the values you want to export. From there, add import ID to the export and you should get what you're after ... if the relationships have been reciprocated.