HTTP Request with dynamic data from Excel file

CFoufoutos — Fri, 15 Nov 2024 23:18:35 GMT

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!

Re: HTTP Request with dynamic data from Excel file

gjeremy1617088143 — Fri, 14 Jan 2022 13:19:18 GMT

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

topic Re: HTTP Request with dynamic data from Excel file in Talend Studio

HTTP Request with dynamic data from Excel file

Re: HTTP Request with dynamic data from Excel file