topic Iterate Delete API call with body parameters in Talend Studio

Iterate Delete API call with body parameters

dura45 — Sat, 02 Mar 2024 15:01:41 GMT

Hello, I'm fairly new to the Talend world but I find it very useful for my needs.

I would like to make a DELETE API call that in POSTMAN (where it works) is structured like this: In the body, I pass two parameters in x-www-form-urlencoded format:

address_id
uid

The goal is to start from an Excel file that has these two columns with a series of rows containing the values of address_id and uid that I need to delete (about 400), and ensure that all rows are iterated.

I can't figure out how to set up the body so that it takes each row from the Excel file.

Here the current schema and Postaman call structure

Anyone can help me?

Re: Iterate Delete API call with body parameters

Shicong_Hong — Mon, 04 Mar 2024 05:47:19 GMT

Hello

For your question on using content type form in tRestClient component, once you select the HTTP method to POST, the content type option will appear on the UI. You can then select the Content Type to FORM

In the backend, the content type is set to "application/x-www-form-urlencoded" once the selection is made.

Please try it and let me know if you have any additional questions.

Regards

Shicong

Re: Iterate Delete API call with body parameters

dura45 — Mon, 04 Mar 2024 08:10:41 GMT

Hi @Shicong_Hong and thank you for your reply.

I saw the option that you suggest but it appears only if the method is POST and not when the method is DELETE as I want.

I tried to choose POST method, I selected content type FORM and after that I switched to DELETE post and it didn't save the content type.

If there is a solution for this topic the next question is: how can I pass the address_id and uid iterating from excel file? Thanks a lot!