Home > Integrating > WSI Nodes > (WSI) Set
This node can be used to update fields in almost any table, keying off of ID, GUID, or a columnID you specify.
<Set Table="string" ID="integer" GUID="uniqueidentifier" IDColumn="string" GUIDColumn="string">
This is a very powerful node, which should only be used if absolutely necessary, by someone familiar with SQL. This node should be contained in a Transaction node.
Update a Product Name
<Set Table="Product" ID="14">
<Name>Lion King Updated Name</Name>
Update an Order record with shipping tracking information. Note that the WSI knows that the "ID" identity column for an order is "OrderNumber" and sets that for you during execution. Unless specifying a different column to use, you always just provide an ID or GUID and WSI will figure it out.
<Set Table="Orders" ID="100003>