Read

Search for entities and load them into PFX:

    <route id="sap4hana-list-with-connection">
        <from uri="timer:in?repeatCount=1&delay=5000"/>
        <to uri="pfx-odata2://read?entity=A_CreditMemoRequest&$select=CreditMemoRequest,TransactionCurrency,TotalNetAmount,CreditMemoRequestType,PricingDate,CreditMemoRequestDate&$filter=TransactionCurrency eq 'USD' and OverallSDProcessStatus eq 'A'&$orderby=CreditMemoRequest desc&$top=1&$skip=0&connection=cognitus"/>
        <to uri="pfx-api:loaddata?objectType=P&connection=aperture-labs&mapper=pfimcore354"/>
    </route>

Authenticate using serviceUrl and credentials in URI:

    <route id="sap4hana-list-with-properties-connection-details">
        <from uri="timer:in?repeatCount=1&delay=5000"/>
        <to uri="pfx-odata2://read?entity=A_CreditMemoRequest&$select=CreditMemoRequest,TransactionCurrency,TotalNetAmount,CreditMemoRequestType,PricingDate,CreditMemoRequestDate&$filter=TransactionCurrency eq 'USD' and OverallSDProcessStatus eq 'A'&$orderby=CreditMemoRequest desc&$top=1&$skip=0&serviceUrl={{sap.url}}&username={{sap.username}}&password={{sap.password}}"/>
        <to uri="pfx-api:loaddata?objectType=P&connection=aperture-labs&mapper=pfimcore354"/>
    </route>

Search for an entity defined by a single ID:

    <route id="sap4hana-get">
        <from uri="timer:in?repeatCount=1&delay=5000"/>
        <setHeader headerName="PfxOpenData2.id"><constant>60000001</constant></setHeader>
        <to uri="pfx-odata2://read?entity=A_CreditMemoRequest&connection=cognitus"/>
        <to uri="pfx-api:loaddata?objectType=P&connection=aperture-labs&mapper=pfimcore354"/>
    </route>

IntegrationManager Documentation

OpenData v2 Integration

Read

Create

Update

Delete