Base Data Activities
Last updated
Last updated
appConnector Base Activities are made up the most commonly used activity modules in the appRules product suite.
appConnector Base Activities
The Base Data activities module provides activities for generalized data access in your project.
Base Data Activities
The table below shows the activities in the Base Data Activities module and their key properties. The Base Data activities can be applied to all data sources defined in the current project.
ClearRecord
This activity clear the current record content of a selected source or target
CloseSource
This activity closes a selected source
CloseTarget
This activity closes a selected target
CopyRecord
This activity copies the record content from the specified source to the specified target (source and target must have the same data definition)
DeleteRecord
This activity deletes a target record(s) based on a filter defined
ExecuteSQLScript
Execute a SQL script on a specific target
ExecuteStatements
Execute a SQL statement on a specific datasource
ExecuteStoredProcedure
Execute a storedprocedure of a specific datasource
InitializeSource
Initialize a datasource table/entity for reading
InitializeTarget
Initialize a datasource table/entity for Insert/Update/Delete
GetNextRecord
Read the next record of an InitializeSource loading multiple records.
InitializeSourceList
Creates and read an organized list of values (can be set from a csv file or adhoc (activity preset))
InitializeTargetFile
Initialize a text/csv file target
LookupRecord
This activity is used to lookup a record based on filters (example: loads the company record from a company table based on the contact table companyid field)
MapAndSaveRecords
Maps and Save multiple records in a target based on the source content.
MapRecordsFields
Maps the target fields from multiple sources (records, variables, transformedfields etc)
PerformRecordListAction
Perform a specific action on a preloaded list of records
SaveRecord
Save a specific target record (Insert,Update,Upsert,Skipsert)