Plugins give Vision App Maker rules access to portal data, databases, files, documents, signatures and third-party systems. Each library groups the methods for one area. This page lists the methods described in the App Factory Studio documentation.

Configured plugin instances with library and output cache type
Configured plugin instances with library and output cache type.

Using a plugin

A configurator creates a plugin instance in App Factory Studio for one method. The instance has a name, an output cache type (NoCache or SessionCache), inputs and indexed outputs. A rule runs it with CallPlugin(id) when all inputs are bound, or with CallPluginWithParams to pass inputs at run time.

Portal entities

MethodWhat it does
CreateCmsUserCreates a portal user if no user has the same e-mail or user name; returns the new user id
UpdateCmsUserUpdates a portal user, either all properties or only those provided
GetUsersFromGroupReturns the users assigned to at least one of the given groups
GetUsersFromOrganizationUnitReturns the users of an organizational unit
GetUserDetailsReturns a user's details (contact data, direct manager, unit, job title, stamp) by user name
GetUserDetailsByGuidReturns the same details by user GUID
GetUserDetailsByIdReturns the same details by user id
GetUserGroupsReturns all user groups
GetOrganizationUnitsReturns all organizational units
CreateOrganizationUnitCreates an organizational unit with description, parent unit and manager
UpdateOrganizationUnitChanges the name, parent, manager or description of a unit
ClearOrganizationUnitUsersRemoves all user links from an organizational unit

SQL Server

MethodWhat it does
ExecuteMultiRowQueryRuns a parameterized SQL script and returns several rows
ExecuteSingleRowQueryRuns a query and returns one row
ExecuteNonRowQueryRuns a statement without a result, typically insert, update or delete
ExecuteMultiRowQueryProcedureRuns a stored procedure and returns a list of rows
ExecuteSingleRowQueryProcedureRuns a stored procedure and returns one row
ExecuteNonRowQueryProcedureRuns a stored procedure without a result

System

Process instances

MethodWhat it does
CurrentInstanceInfoReturns the current process instance: ids, module, state, activity, user, role, language, dates
SaveInstanceInfoSaves the process instance when it moves from one state to another
InitProcessStarts a new process instance of a module
LoadProcessLoads an existing process instance
ReadParametersReads parameter values from a module session
SetParametersSets parameter values in a module session
SearchInstancesSearches process instances by id, module, domain, states or identifier
GetProcessInstanceFlowStatesReturns the states of a module
GetFlowStatesLogReturns the state history of the current process: user, date, state, activity, comments
RedirectUrlRedirects the user to a given URL

Notifications

MethodWhat it does
SendEmailSends an HTML or text e-mail, with priority and optional asynchronous sending
SendEmailWithAttachmentSends an e-mail with one attached file
SendEmailWithMultipleAttachmentsSends an e-mail with a list of attachments
SendEmailWithTemplateAttachmentSends an e-mail with a document template as attachment
SendEmailWithTemplateBodySends an e-mail whose body is a template
SendMeetingSends a meeting invitation with start and end dates
GenerateMessageGenerates an info, warning or error message

Files, templates and Excel

MethodWhat it does
RenderTemplateRenders a document template, typically for download
AddPdfWatermarkAdds an HTML watermark to a PDF at a given position and size
PackFileInArchivePacks several files into an archive
SaveFileSaves a file, optionally overwriting an existing one
SaveTextFileWrites or appends text to a file, in Unicode or UTF-8
ReadFileReads a file
ReadEntityFromExcelReads an Excel sheet into a custom type, with column mapping
WriteEntityToExcelWrites a list of custom type values to an Excel file
WriteEntityToFormattedExcelWrites custom type values to Excel with a style defined in JSON
WriteMatrixDataToFormattedExcelWrites a matrix of values to Excel with JSON column formatting

Logic and HTTP

MethodWhat it does
ExecuteJSExecutes JavaScript code
ExecuteRuleExecutes business rule text
GenerateBasicAuthTokenGenerates an authentication token from a user name and password
MakeHttpCallMakes an HTTP call with URL, method, JSON body and headers; returns the response
GetDictionaryFromJsonConverts JSON text into a dictionary

Document management systems

LibraryMethodWhat it does
SharePointReadMultipleEntitiesReads list items, with selected columns and filters
SharePointReadEntityReads one list item by id
SharePointCreateEntityCreates a list item
SharePointUpdateEntityUpdates a list item
SharePointDeleteEntityDeletes a list item
SharePointUploadFileUploads a file with metadata to a document library
SharePointListFilesInFolderLists the files in a library folder
SharePointDownloadFileReturns a file's name and content
SharePointDeleteFileDeletes a file from a library
AlfrescoListFilesInFolderLists the contents of a folder
AlfrescoDownloadFileDownloads a file from the repository
AlfrescoUploadFileUploads a file to a folder
AlfrescoMoveFileMoves a file to another folder
AlfrescoDeleteFileDeletes a file from the repository
AlfrescoSaveFolderUpdates a folder or creates it if missing
AlfrescoReadUsersInfoReturns the users of a site
AlfrescoReadGroupInfoReturns the user groups of a site
AlfrescoGetUsersEmailsFromGroupsReturns the e-mail addresses of a group's users
LiferayCreateFolderWithGivenPathCreates a folder at a given path
LiferayListFilesInFolderLists the contents of a folder
LiferayUploadFileUploads a file with title, description and change log
LiferayMoveFileToGivenPathMoves a file to another folder
LiferayDeleteFileDeletes a file from the Liferay library

Business applications

LibraryMethodWhat it does
Microsoft Dynamics CRMReadMultipleEntitiesReads records of an entity with filters; the Web API variant adds ordering and paging
Microsoft Dynamics CRMReadEntityReads one record by GUID
Microsoft Dynamics CRMSaveEntitySaves a record
Microsoft Dynamics CRMDeleteEntityDeletes a record by GUID
Microsoft Dynamics CRMGetOptionSetValuesReturns the values of an option set field
Microsoft Dynamics CRMSetEntityStateSets the state code and status code of a record
QuickBooksGetCustomersListReads customers into an App Maker entity
QuickBooksGetInvoicesListReads invoices into an App Maker entity
QuickBooksGetItemsListReads items into an App Maker entity
QuickBooksCreateCustomerCreates a customer and returns the updated instance
QuickBooksCreateInvoiceCreates an invoice and returns the updated instance
QuickBooksGetNewAccessTokenGenerates a new access token from a refresh token

ReadEntity, ReadMultipleEntities, SaveEntity and GetOptionSetValues also exist in a second set that calls the Dynamics CRM Web API. A connector for the Avantax local tax platform reads nomenclatures, taxpayer data and amounts due, saves declarations, records payments and issues reports.

Documents

MethodWhat it does
AddExtraPageToPdfAdds a blank page to a PDF
AddCommentToPdfAdds a comment at a position on a PDF page
AddStampToPDFAdds a stamp image with number and date
AddStampAsTextToPdfAdds a text stamp with registration and approver details
AddQRCodeToPdfAdds a QR code with given text at a position
GetPdfPageNumberReturns the number of pages of a PDF
StringToByteArrayConverts text into a file
ByteArrayToStringConverts a file into text

Digital signature

MethodWhat it does
GetEmptySignatureHashedFilePrepares a PDF with an empty signature field and returns its hash
ReplaceEmptySignatureReplaces the empty field with the user's signature
GetSignaturesFromByteArrayDocumentReturns the number and list of signatures in a file
CheckCertificateChecks the status of a Trans Sped cloud signing certificate
SendOTPBySMSSends a one-time password by SMS to the certificate holder
SignDocumentSigns a PDF with a Trans Sped cloud certificate
STSSignDocumentPrepares a document for signing with another cloud signing service
SignedBytesRetrieves the file signed through that service

Other

MethodWhat it does
UploadUploads a document with its archival metadata to an authorized electronic archive
GetQRCodeFromTextGenerates a QR code image from text
MakePaymentStarts a payment through a payment engine
CheckPaymentChecks the status of a payment