h3.Work with SharePoint List & Library Items and data from CSV, Database and Excel Excel
Perform actions bidirectionally : • Read • Create • Update • Delete/Recycle • Looping (For-Each .. do this and that)
Read/Write data bidirectionally : • SharePoint Lists & Libraries • CSV/TXT files • Databases (SQL Server, Access, MySQL, Generic ODBC etc.) • Excel • MS Flow
Use filters and parameters for your actions.
*Run you job (Component) interactively Step-By-Step, as a separate task or scheduled
with support for recurrence on the built in Job Server*
Connectors to ERP/CRM and Databases.
| “Source” defines the data set used as input for the selected action on the “Target”. |
|
|
|
|
| “Target” is where the actions are performed, using the source data set as variables. (Other Components can be called for each source row.) |
|
|
|
|
| Examples. |
| How to copy data from database to database |
| How to preserve the values in [Modified] & [Modified By] during update of List Items and Document metadata. |
System Parameters
When the component starts, the system Parameter [<<SessionDateTimeNow>>] is updated.
If the job completes with no errors (or within the allowed threshold) the system Parameter[<<SessionDateTimeLast>>] is updated to the value of and [<<SessionDateTimeNow>>], otherwise it is unchanged.
These 2 timestamps can be used as arguments for incremental jobs in SQL statements, SharePoint filters and file selection filters.
Please note that the the value of the 2 parameters is local to the Component in context. All Components that are executed has their own set of values except when referenced from within a Collection.
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..