pfx-api:resetcolumn

Reset a column on a Pricefx object. This clears the values of the specified column across all records of the given object type. The method name is case-insensitive: both resetColumn and resetcolumn are accepted in the URI.

Parameters

Parameter	Type	Default	Description
`objectType`	ObjectType (enum)	--	The Pricefx object type on which to reset the column (e.g., `P`, `C`, `DMDS`, `PX`, etc.).
`resetColumnName`	String	--	The name of the column to reset (e.g., `attribute1`, `attribute5`).

XML Route Examples

Reset a column on products

XML

<route>
    <from uri="direct:resetProductColumn"/>
    <to uri="pfx-api:resetcolumn?objectType=P&amp;resetColumnName=attribute5"/>
</route>

Reset a column on a Data Source

XML

<route>
    <from uri="direct:resetDSColumn"/>
    <to uri="pfx-api:resetcolumn?objectType=DMDS&amp;resetColumnName=attribute3"/>
</route>

Reset a column on customer extensions

XML

<route>
    <from uri="direct:resetCXColumn"/>
    <to uri="pfx-api:resetColumn?objectType=CX&amp;resetColumnName=attribute1"/>
</route>

Common Pitfalls

Both parameters are required: You must specify both objectType and resetColumnName. Omitting either will cause the operation to fail.
Irreversible operation: Resetting a column clears the values for all records of that object type. There is no undo. Verify the column name carefully before executing in production.
Column name must be valid: The resetColumnName must correspond to an actual attribute on the object type (e.g., attribute1 through attribute50 for products). Invalid column names will result in an error.