Fetch Data from Datamart

This example shows how to fetch data from a Datamart with the name 1669.DMDS. You can define a filter if needed.

<route>
    <from uri="timer://fetchDataFromDatamartByQuery?repeatCount=1"/>
    <to uri="pfx-api:fetch?objectType=DM&dsUniqueName=1669.DMDS&batchedMode=true&batchSize=5000"/>
    <split>
        <simple>${body}</simple>
        <to uri="pfx-api:fetch?objectType=DM&dsUniqueName=1669.DMDS"/>
        <log message="${body}"/>
    </split>
</route>

DsUniqueName can be used to get data from Datamart, Datamart Data Source or Data Feed.

Type of Data Source	Pattern

Type of Data Source	Pattern
Datamart	id.DM
Data Source	id.DMDS
Data Feed	id.DMF