RFC lookup in Integration Scenario

[hashtag_siva]

Hi,

I have a scenario where I need to do RFC lookup first and based on the values ( typically the lookup will give file path and file name), I need to send these values as variable substitution to file adapter to read the file. The above is in loop until all entries from lookup are used up. If all entries in lookup are used up then the scenario should run again every 5 minutes automatically.

Is there anyway possible to achieve the above in XI/PI. We are on SP14.

Thanks in advance for your help

[former_member190389 · Accepted solution]

Do you want to pickup files based on the path & file name?

if so then you will have to use BPM for this.

[hashtag_siva · Accepted solution]

If I use BPM, how to make the integration process run every 5 minutes? and also can you specify the loop for the number records the RFC lookup gives back?

[former_member859847]

Hi,

you will use RFCLook up at Message mapping.

the out put values of RFC look up mapped to two target fields

1. file name

in the variale substitution give file name schema as %var%

mention var = payload:Message type,1,item,filename

warm regards

mahesh.