HTTP Request with dynamic data from Excel file

[CFoufoutos]

Hello there,

I'm new to TOS, I would like to be guided here.

This scenario will take place inside a Linux container and will run continuously.

Use-case:

• We want to iterate a folder named "deletion" that will wait for the creation of a .xlsx file.

    This file will have one column that will contain a resource ID. For example 22cc39db-01217efc-1c94c896-f5a7cd07-1533a8d9. So, each row has to be extracted from column A.

• Then will have to take that ID and make a POST request to a HTTP service that runs locally, its role is deletion of a resource. This will have to be dynamic.

    The curl command that is being used is:

    curl http://localhost:8042/tools/bulk-delete -d '{"Resources":["22cc39db-01217efc-1c94c896-f5a7cd07-1533a8d9"]}'

    Or for multiple resources this would be like this:

    curl http://localhost:8042/tools/bulk-delete -d '{"Resources":["b6da0b16-a25ae9e7-1a80fc33-20df01a9-a6f7a1b0","d6634d97-24379e4a-1e68d3af-e6d0451f-e7bcd3d1"]}'

• Finally, the .xlsx, only after the deletion(s), has to be moved to a folder named "deleted"

How can this be achieved? I suspect the use of tWaitForFile, tFileInputExcel, tMap, tFileFetch or tSystem components, but I'm not sure.

I really appreciate any of your thoughts! In case you will be providing a diagram, please upload some photos!

Thanks in advance!

[gjeremy1617088143]

Hi, for run continuously scenario, it is not a good solution to use standalone job, you have to look for route with Talend esb.