Composable AI
Populating reference control types via DataPortal Sync #59
Answered
by
liamfratturo
ben-composable
asked this question in
DataPortals
|
Is there a way to populate a reference control type using DataPortal Sync? If so, what should the name of the column header be? Specifically if I do not have access to its primary key (ID), but another field (name) that is presumably unique. |
Answered by
liamfratturo
Nov 20, 2025
Replies: 1 comment
|
Yes, you can populate a reference control column via DataPortal Sync. The column header in your input table should match the column name in the DataPortal, and the values in the column should be the ID (primary key) of the object being referenced. In this case, since you don't already have access to the primary key, you'll want to |
0 replies
Answer selected by
ben-composable
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Yes, you can populate a reference control column via DataPortal Sync. The column header in your input table should match the column name in the DataPortal, and the values in the column should be the ID (primary key) of the object being referenced.
In this case, since you don't already have access to the primary key, you'll want to
JOINyour input data to the referenced table on your unique field before you perform the Sync.