Object Operations

WFBs that processes objects.

Name	Description	Parameters	Result
Object Data Source	Connect object data source	Datamodel and Datasource: Where the data is located Existing Table: Bind existing table Ad Hoc Table: Link table depending on the selected data source Table: The table you want to select …: Filtering and sorting the table Delta Filter: Only get data that was added since the last this delta filter was called. Preview: Preview the table data Ad Hoc Table – Type: The table type, depends on the data source Ad Hoc Table – Name: The name of the ad hoc table to be created Ad Hoc Table – Resource: resource name inside the data source, for example data.movies Ad Hoc Table – Method Type: None, Get, Put, Post, Delete, Options Parameters: passed to the object Options: General options for the table. For example if it is an excel, which row to start reading from	N/A
Export Objects	Export Objects into a an object table or an ad hoc table. If the table already exists, it will only update the values and not append.	Datamodel and Datasource: Where the data is located Existing Table: Bind existing table Ad Hoc Table: Link table depending on the selected data source Table: the table to be linked to Export settings: Block-mode check, how many inserts are ran at once Ad Hoc Table – Type: the type of the table, depends on the data source Ad Hoc Table – Name: Temporary name for the table Ad Hoc Table – Resource: Where the data will be saved, if it’s a file include the extension Ad Hoc Table – Method Type: None, Get, Put, Post, Delete, Options Parameter: Passed to the data table Options: Depends on the table type	N/A
Generate ObjectReader	Identical to Object Datasource except the data is supplied from another source. After reading it a loop operation is recommended. To use the workflow block, the current parameter that is passed to it should be a list of objects of the same data source that is selected inside of it	Datamodel and Datasource: Where the data is located Table: Table that specifies the object structure	A WorkflowObjectReaderInfo object is returned as current parameter
Execute on Object	Used when you want to execute something on the data object ignoring the reader	N/A	The current object (WorkflowObjectReader) is assigned to the current parameter
Convert To Data Row	The object is converted to one or more relational data rows	Existing Table: select an existing table Generate Row: Generate a row that is not bound to an existing table Datamodel and Datasource: Where the table is located Table: Table that you want to create a row for	N/A
Edit Properties	Add or edit properties to the current object	Add Property: Add Property Property: Set property name if Add Property is set, otherwise select Property Formula: Defiine the value of the property	N/A
Read Out Properties	Read properties and set to status key or current parameter	Property: Select property Status Key: Set Property Value in Status Key	Returns a current parameter when activated
Add Properties	Add a property to the current object using a column in another data source	Search Proprties: define criteria for which data row to select data from Search Proprties - LookUp Property: Property in source table Search Proprties - Comparison Property: Comparison Property from target object Select All: Add all properties to the source object Specific property: Select a specific property from the target to add New property name: What key value is used to get the added property	N/A
Replace Enum Values	GUID is converted into a readable name or a name into a GUID	Name -> ID: Converts name to ID depending on the object ID -> Name: Converts ID to name depending on the object Property: Property on which enum should be written Enum: Enum – Type If value not found, fill with default: Value to be set if enum is not found Default: Values of the enum	N/A