FormsAndFolders - SuperOffice

“FormsAndFolders”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.FormsAndFoldersProvider inside NetServer’s SODatabase assembly. Combined archive of forms (the form table) and form folders (s_picture_folder, folder_type = formFolder) — analogous to MailingsAndFoldersProvider. Unified row schema (after the column-name overrides set up below):

PrimaryKey — row’s own id
formFolderId — row’s container folder id (for filtering)
name — display label (form name on forms, folder name on folders), via overrides
formThumbnail — preview image / folder icon hint (native on both)

Client filter formFolderId = N returns forms whose form.folder_id = N AND folders whose s_picture_folder.parent_id = N — i.e. everything contained in folder N. The name override is applied here (not by renaming the underlying extender column) so FormExtenderBase keeps its native formName column for every OTHER archive that uses it — including the Forms pane’s own flat tabs, which query the plain Forms provider. Same approach as MailingsAndFoldersProvider (mailingDescription / folderName both → name).

Supported Entities

Name	Description
”formfolder"
"form”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
folderId	None
formFolderId	int	x
name	string	x
formThumbnail	None
sortGroup	None
sortName	None	x
type	None
formId	None
formDescription	None
formActive	None
formType	None
formSubmissionCount	None
updatedBy	None
updatedDate	None
registeredBy	None
registeredDate	None
registeredByFullName	None
emailFlow/emailFlowId	None
emailFlow/emailFlowHierarchyId	None
emailFlow/shipmentType	None
emailFlow/overrideConsentSubscription	None
emailFlow/thumbnail	None
emailFlow/mediumThumbnail	None
emailFlow/workflowId	None
emailFlow/workflowName	None
emailFlow/workflowDescription	None
emailFlow/workflowDefinitionStatus	None
emailFlow/workflowDefinitionStatusId	None
emailFlow/jumpToFinish	None
emailFlow/startOnlyOnce	None
emailFlow/workflowEnrolledCount	None
emailFlow/workflowInProgressCount	None
emailFlow/workflowCompletedCount	None
emailFlow/workflowSucceededCount	None
emailFlow/workflowSuccessRate	None
emailFlow/updatedBy	None
emailFlow/updatedDate	None
emailFlow/registeredBy	None
emailFlow/registeredDate	None
associate/firstName	None
associate/lastName	None
associate/middleName	None
associate/fullName	None
associate/contactId	None
associate/personId	None
associate/mrMrs	None
associate/title	None
associate/associateDbId	None
associate/contactName	None
associate/contactDepartment	None
associate/usergroup	None
associate/usergroupId	None
associate/contactFullName	None
associate/contactCategory	None
associate/role	None
associate/assocName	None
associate/assocTooltip	None
associate/assocType	None
associate/ejUserId	None
associate/simultaneousEjUser	None
associate/ejDisplayName	None
associate/ejStatus	None
associate/credentialType	None
associate/credentialDisplayValue	None
associate/isActive	None
associate/isActiveText	None
associate/portraitThumbnail	None
associate/otherGroups	None
associate/userName	None
associate/personEmail	None
associate/locationAddress	None
associate/isLocation	None
historyRank	None

Sample

GET /api/v1/archive/FormsAndFolders?$select=emailFlow/workflowId,emailFlow/updatedBy
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv