Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

API

Microsoft Power Automate GoFileRoom Connector

Background

Microsoft Power Automate is part of the Office 365 suite, that allows you to build powerful automated scenarios across the most common applications and services without the assistance from developers. The GoFileRoom Connector allows many of the existing GoFileRoom application program interfaces (API) to easily communicate with Microsoft applications, such as, Microsoft Power Automate, PowerApps, and Logic Apps within Microsoft’s ecosystem, and doesn’t require programming skills. Your firm can use these tools to integrate GoFileRoom with third-party applications that can help you automate workflows and tasks.
The APIs can be found on the Thomson Reuters Developer Portal.

Using the GoFileRoom connector

When using the Microsoft Power Automate GoFileRoom Connector you must first use the Login action to obtain an authentication token. This token will then be used with any other action within your Flow.
The examples below are one way to use each action. There are many ways each action could be configured.
Examples: User
Enter your GoFileRoom username and password.
Enter the token response from the Login action in the Token field.
Enter the token response from the Login action in the Token field.
Examples: User Group Administration
  1. Select GFRUSERS or CLIENTFLOWUSERS from the UserType drop-down.
  2. Enter the token response from the Login action in the Token field.
  1. Enter the GoFileRoom username of the user within the Login field.
  2. Enter GFRUSERS within the UserType field.
  3. Enter the token response from the Login action in the Token field.
  1. Enter the GoFileRoom username of the user within the Login field.
  2. Enter the token response from the Login action in the Token field.
  1. Enter the GoFileRoom username within the LoginId field.
  2. Enter the CabinetName and DrawerName. Enter the token response from the Login action in the Token field.
Enter the token response from the Login action in the Token field.
  1. Enter the GoFileRoom group name within the GroupName field.
  2. Enter the token response from the Login action in the Token field.
  1. Enter the GoFileRoom group name within the GroupName field.
  2. Enter the CabinetName and DrawerName.
  3. Enter the token response from the Login action in the Token field.
Enter the token response from the Login action in the Token field.
Enter the token response from the Login action in the Token field.
  1. Select Dedicated, Concurrent, or FirmFlow within the LicenseType drop-down.
  2. Enter the token response from the Login action in the Token field.
Enter the token response from the Login action in the Token field.
  1. Enter GFRUSERS in UserType.
  2. Enter the token response from the Login action in the Token field.
  3. Enter true or false for Specify true or false fields.
  4. Enter a value or a blank space for AccountExpiresDate, DisabledComments or UploadLocation.
  5. Enter 'concurrent' or 'dedicated' for LicenseType.
  6. Enter at least one group name within the Groups Item field.
  7. Enter another GoFileRoom user's email address within the ManagerEmail field.
  8. Enter the new user's email address within the LoginName field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter true or false for Specify true or false fields.
  3. Enter a value or a blank space for Comments or UploadLocation fields.
  4. Enter the group name within the GroupName field.
  5. Enter true or false or a blank space within Reports IsAllowAll or Reports IsDenyAll field.
  6. Enter a valid GoFileRoom user name within User Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the GoFileRoom username of the user within the LoginId field.
  3. Enter the CabinetName and DrawerName, and then select the DocumentSecurity DocSecurityType from the drop-down field.
  4. Enter the index name within the DocumentSecurity IndexName – 1 field, and then select DocumentSecurity Values Item from the drop-down field.
  5. Enter the index value within the DocumentSecurity Values Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the group name within the GroupName field.
  3. Enter the CabinetName and DrawerName, and then select DocumentSecurity DocSecurityType from the drop-down field.
  4. Enter the index name within the DocumentSecurity IndexName – 1 field, and then select DocumentSecurity Values Item from the drop-down field.
  5. Enter the index value within the DocumentSecurity Values Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter true or false for Specify true or false fields.
  3. Enter cabinet name within the Cabinet field. Enter drawer name within DrawerPermissions Drawer – 1 field.
  4. Enter the GoFileRoom username within LoginId field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter true or false for Specify true or false fields.
  3. Enter cabinet name within the Cabinet field.
  4. Enter drawer name within DrawerPermissions Drawer – 1 field.
  5. Enter the GoFileRoom group name within the GroupName field.
  1. Enter GFRUSERS within the UserType field.
  2. Enter the token response from the Login action in the Token field.
  3. Enter true or false for Specify true or false fields.
  4. Enter a value or a blank space for AccountExpiresDate, DisabledComments, or UploadLocation.
  5. Enter 'concurrent' or 'dedicated' for LicenseType.
  6. Enter at least one GoFileRoom group name within the Groups Item field.
  7. Enter another GoFileRoom user's email address within the ManagerEmail field.
  8. Enter the user's email address within the LoginName field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter true or false for Specify true or false fields.
  3. Enter a value or a blank space for Comments, UploadLocation, or RenameGroup fields.
  4. Enter the GoFileRoom group name within the GroupName field.
  5. Enter true, false, or a blank space within Reports IsAllowAll or Reports IsDenyAll field.
  6. Enter a valid GoFileRoom username within User Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the GoFileRoom or ClientFlow username within the LoginId field, and then select GFRUSERS or CLIENTFLOWUSERS from the UserType frop-down.
Example: Drawer
Enter the token response from the Login action in the Token field.
Examples: Index
  1. Enter the drawer id within the DrawerID field. (This value can be obtained from the Get Drawers action).
  2. Enter the token response from the Login action in the Token field.
  1. Enter the index id value within the IndexId field. (This can be obtained from the Get Drawer Indexes action.)
  2. Enter the token response from the Login action in the Token field.
  1. Enter the index id value within the IndexId field.
  2. Enter the list id within the ListId field. (These can be obtained from the Get Drawer Indexes action.)
  3. Enter the token response from the Login action in the Token field.
This action will return index field values which have related lookup list indexes. For example, Client Name and Client Number.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the IndexID by which you want to search.
    The index id can be obtained using the Get Drawer Indexes action.
  3. Select an Action Type from the drop-down field. (1- Search Lookuplist, 2- Add Lookuplist, 3- DocumentTracking Lookuplist, 4-TaxflowSearch Lookuplist, 5-GroupDocumentSecurity Lookuplist, 6-LookupContactManagement Lookuplist)
  4. Enter the amount of values to be returned in the Count field. For example, 25,50,100.
  5. Select a Search Type from the drop-down. (0-Exact, 1-Pre, 2-Post, 3-Contain)
  6. Enter a value within the IndexValue field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the Indexes IndexIds and Indexes IndexValues to validate. (These can be obtained from the Get Drawer Indexes action.)
  1. Enter the IndexId value. (This can be obtained from the Get Drawer Indexes action.)
  2. Enter the token response from the Login action in the Token field.
Examples: Documents
  1. Enter the token response from the Login action in the Token field.
  2. Enter the Index Ids and Index Values. (These can be obtained from the Get Drawer Indexes action.)
  1. Enter the token response from the Login action in the Token field.
  2. Enter the Document Id(s) in the Body Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter the Index Id’s and Index Values. (These can be obtained from the Get Drawer Indexes action.)
  1. Enter the token response from the Login action in the Token field.
  2. Enter the DrawerId value. (The Drawer Id value can be obtained from the Get Drawer action.)
  3. Enter NumberOfRows to be returned.
  4. Enter PageNumber to view.
  5. Enter SortField which can be obtained from Get Drawer indexes action, and then Select SortOrder from the drop-down list.
  6. Enter IndexValues IndexId-1 value which can be obtained from Get Drawer Indexes action.
  7. Enter IndexValues IndexValues – 1. The percent symbol can be used as a wildcard.
  1. Enter the token response from the Login action in the Token field.
  2. Enter DocumentId of the document for which to view the history.
  1. Enter the token response from the Login action in the Token field.
  2. Enter DocumentId for the document you wish to delete.
  1. Enter the token response from the Login action in the Token field.
  2. Enter Document Ids of the documents that you want to merge within the Body Item fields.
  1. Enter the token response from the Login action in the Token field.
  2. Enter DocumentIds of the documents you wish to reindex.
  3. Enter Index Ids and Index Values to be reindexed. (These can be obtained from the Get Drawer Indexes action.)
  1. Enter the token response from the Login action in the Token field.
  2. Enter Document Id within the Body Item – 1 field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter Document Id within the DocumentId field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter Document Id within the DocumentId field.
  1. Enter the token response from the Login action in the Token field.
  2. Enter Document Id within the DocumentId field.
  3. Enter True or False in the IsPublished field.
Example: FirmFlow Reports
Enter the token response from the Login action in the Token field.
The following fields must be completed (at minimum).
  1. DrawerId (can be obtained from the Get Drawers actions)
  2. ServiceType (can be obtained from the FirmFlow application)
All other fields can be completed with a value which can be obtained from the application or left blank.
The following fields must be completed (at minimum).
  1. DrawerId
  2. ServiceType
The following fields must be completed (at minimum).
  1. DrawerId
  2. ServiceType
Example: FirmFlow
The following fields must be completed (at minimum).
  1. Drawer Name
  2. Service Type
  3. Page Number
  4. Page Size
The following fields must be completed (at minimum).
  1. Deliverable Name
  2. Due Date
  3. All Extension Dates (First/Second/Third) C or F for Calendar/Fiscal, 0 or 1 if extended or not.
  4. Drawer Name
  5. Service Type
The following fields must be completed (at minimum).
  1. Drawer Name
  2. Service Type
The following fields must be completed (at minimum).
  1. Current Deliverable Name
  2. UIpdate Deliverable Name
  3. Due Date
  4. All Extension Dates (First/Second/Third) C or F for Calendar/Fiscal, 0 or 1 if extended or not.
  5. Drawer Name
  6. Service Type
The following fields must be completed (at minimum).
  1. Drawer Name
  2. Service Type
  3. Client Name
  4. Client Number
  5. Engagement Type
  6. Year
  7. Period End
  8. Workflow Name
  9. Description
  10. Status Name
The following fields must be completed (at minimum).
  1. Filing ID (can be obtained via one of the FirmFlow report API calls)
  2. Completed Date
  3. Next Step
  4. Assigned To (in U-# Format, obtained via Get User Info API)
  5. Assigned date
  6. Priority
  7. Status
The following fields must be completed (at minimum).
  1. Filing ID (can be obtained via one of the FirmFlow report API calls)
The following fields must be completed (at minimum).
  1. Filing ID (can be obtained via one of the FirmFlow report API calls)

Questions and additional help

If you have questions on using the Microsoft Power Automate GoFileRoom Connector, contact Technical Services for additional training. Currently, this article is to help you to get started with Power Automate, for additional training Technical Services can assist.
If you have questions integrating other connectors which are non-Thomson Reuters, contact Microsoft Power Automate Support.

error-icon

error-close