GetDimensionRestrictedData
Lists the IDs of related dimensions that are the targets of to-many relationships from a single source dimension.
Stored Procedure Specific Information
Note: This stored procedure will only list OneToMany and ManyToMany relationship types. To get the OneToOne and ManyToOne related record keys, you can directly query the source table, and the relationship column should contain the keys of the related records.
To figure out the relationship fields for a certain table (Sage Intacct object), you can call the GetRelationshipColumns with the TableName input parameter set to the object name.
Helpful information on the dimension type objects and their relationships can be found by querying the tables below.
- Dimensions: Useful to list all the available dimension type objects.
- DimensionRelationships: Useful to get information on the available relationships between dimension type objects.
Input
| Name | Type | Description |
| Dimension | String | The source dimension object name for which to list the related dimension records. |
| Key | String | The ID of the source dimension record for which to list the related dimension records. Leave this parameter blank to query all available IDs per dimension. |
Result Set Columns
| Name | Type | Description |
| RelatedDimension | String | Name of the related standard dimension or UDD that is the target of a to-many relationship. |
| RelatedRecordKey | String | IDs for the related dimension values that are the targets of to-many relationships |