Records Catalog Joins Available for SuiteScript and Rest Query API
The Records Catalog is available for all users with the Records Catalog permission. To assign the Records Catalog permission, first select the role you want to allow access to the Records Catalog in Setup > Users/Roles > Manage Roles. On the role page, you can then add the permission to view the Records Catalog under Permission > Setup > Add (Records Catalog).
To open the Records Catalog go to Setup > Records Catalog or https://system.netsuite.com/app/recordscatalog/rcbrowser.nl.
|
1 |
Search joins - Search box for searching available joins using keywords. |
|
2 |
Join Type - Based on a join type, you need to use an appropriate API method. For more information, see SuiteScript 2.x. |
|
3 |
Source / Target Record Type - Related record types. To copy the field ID, click the Copy icon beside the field ID. Click the Information icon to see join pairs for manual SuiteQL. For more information, see SuiteQL. |
|
4 |
Field ID - ID of a field to which the join belongs. To copy the field ID, click the Copy icon beside the field ID. |
|
5 |
Cardinality - Cardinality of join. The cardinality of a join between two tables is the numerical relationship between rows of one table and rows in the other. Common cardinalities include one-to-one, one-to-many, and many-to-many. |
The Join tab of the record type’s SuiteScript and Rest Query API displays the join relationships grouped by a record type (for example, Customer) and by its subrecords. For each field, Records Catalog displays the join type, related record types, ID, and cardinality.