pfx-api:fetch, pfx-dsFetch - Fetch Data from Data Source

This component is used to get the required data from Pricefx. It retrieves arbitrary objects from the backend. You can define here filters, sort order and paging. However, some object types are restricted from the general fetch.

Attributes	Description	Required?

Attributes	Description	Required?
`id`	Bean ID	yes
`objectType`	Type of the Pricefx table (P, C, CX, PX, etc.) For a list of all types, see Type Codes.	yes
`filter`	Filter of records in the table See also Filters Used with Fetch/Delete.	yes
`countOnly`	Returns the number of valid records for a specific filter definition.	no
`partitionPfxApi`		no
`startRow`	Used for paging
`endRow`	Used for paging
`typedId`		yes – for `objectType =` PLI where it is the Price List ID no – for other cases

<to uri="pfx-api:fetch?objectType=P&filter=allProductsFilter"/>

<to uri="pfx-api:fetch?filter=pxCarsFilter&amp;objectType=PX&amp;batchedMode=true&batchSize=5000"/>
<split>
    <simple>${body}</simple>
    <to uri="pfx-api:fetch?filter=pxCarsFilter&amp;objectType=PX"/>
	<log message="${body}"/>
</split>

You cannot tamper the body before pfx-api:fetch call in split, otherwise the call would not recognize batch and fetch without batching.

<pfx:filter id="allProductsFilter" resultFields="sku,label">
    <and/>
</pfx:filter>
 
<pfx:dsFetch id="fetchAllProducts" objectType="P" filter="allProductsFilter"/>