GetDimensionRestrictedData
Lists target dimension IDs that have many-to-one or one-to-many relationships from a given 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 name of the source dimension object for which related dimension records are to be listed. |
| Key | String | The ID of the source dimension record for which related dimension records are to be listed. Leave this blank to query all available related IDs for the specified dimension. |
Result Set Columns
| Name | Type | Description |
| RelatedDimension | String | The name of the related standard dimension or user-defined dimension (UDD) that is the target of a to-many relationship. |
| RelatedRecordKey | String | The IDs of the related dimension records that are targets of to-many relationships. |