Integration

Get Involved. Join the Conversation.

Topic

    Cesar Tepetla Corte
    Pull specific File from Agent server leveraging File Adapter
    Topic posted April 3, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Agent, Connection, Database, Integration, Mapping, Orchestration, Process, xml 
    64 Views, 3 Comments
    Title:
    Pull specific File from Agent server leveraging File Adapter
    Summary:
    Pull specific File from Agent server leveraging File Adapter
    Content:

    I am working on two integrations the first one writes a file on a server using the file adapter and also inserts in a database table the name of the file that you just created.

    In the integration two using the file adapter as trigger performs the operation 'File polling' here is where the interesting thing begins because I just want to get the file created in the first integration
    That's why in the second integration after placing the trigger I invoke the database where I save the file name and add a switch object to make the comparison where I establish that if the name obtained from the file adapter is equal to the field of the database table then write your content in another FTP directory (filename and content file).

    I do not get any errors when making this comparison however the comparison is only done once but according to my understanding the comparison should be made for each file that the file adapter is reading.

    I tried adding a for-each to perform the comparison for each read file however it marks me an error (The select node (InboundFileHeaderType) is not repeating.)

     

    Image:

    Comment