pfx-api:datamartImport

Import data into a Datamart via the Datamart Import API. This method allows pushing data directly into a Datamart or Datamart Data Source.

URI Format

pfx-api:datamartImport?param1=value1&param2=value2

Parameters

Parameter	Type	Default	Description
objectType	ObjectType (enum)	--	The Pricefx object type. Supported: DM, DMDS
dsUniqueName	String	--	Unique name of the target Data Source or Datamart
maxRows	Integer	50000	Maximum number of rows to import

XML Route Examples

Import into a Datamart Data Source

XML

<route>
    <from uri="direct:dmImport"/>
    <to uri="pfx-api:datamartImport?objectType=DMDS&amp;dsUniqueName=MyDataSource"/>
</route>

Import with row limit

XML

<route>
    <from uri="direct:dmImportLimited"/>
    <to uri="pfx-api:datamartImport?objectType=DMDS&amp;dsUniqueName=MyDataSource&amp;maxRows=10000"/>
</route>

Import into a Datamart

XML

<route>
    <from uri="direct:dmImportDirect"/>
    <to uri="pfx-api:datamartImport?objectType=DM&amp;dsUniqueName=MyDatamart"/>
</route>

Common Pitfalls

dsUniqueName is required: You must specify the unique name of the target Datamart or Data Source. Without it, the import has no target.
objectType must be DM or DMDS: This method only works with Datamart (DM) and Datamart Data Source (DMDS) object types. Using other object types will fail.
maxRows default: The default maximum is 50,000 rows. If your dataset is larger, increase this value explicitly. If it exceeds the server-side limit, the import will be truncated.
Body content: The exchange body must contain the data to import. Ensure the data format matches what the Pricefx DM Import API expects.
Difference from loaddata: Use datamartImport when you want to use the dedicated DM Import API. Use loaddata with objectType=DMDS for the standard bulk-load approach with mapper support.