I am integrating Checkbox into our recipient communication platform. As part of this integration I need to be able to add thousands of users at a time to the Checkbox database and be able to extract their responses.

I've pretty much figured out how to do everything such as populating the ckbx_Credential and ckbx_CustomUserFieldMap tables and pulling data from the ckbx_ResponseAnswers and ckbx_Response tables (including using ckbx_ItemOptions and ckbx_Text). What I'm missing is how to limit the users to their specific survey.

It appears that I need to have a separate record in ckbx_AccessControlEntry for each respondent, plus a corresponding entry in ckbx_AccessControlEntries to map the respondent to the appropriate access control list. What I haven't been able to find is how to identify which access control list to use. How do I know which list enables the respondent for which survey?

Rick Genter
Silverlink Communications