What are the steps for adding a new column to an HTTP response's csv output?

Vivek Komarla Bhaskar 911 Reputation points
2024-08-15T10:02:10.7333333+00:00

Hi,

What are the steps for adding a new column to an HTTP response's csv output?

My HTTP request takes the download URL as a GET URL, and the response is a CSV output. To this response, I would like to add a new column, how can I do that?

Screenshot 2024-08-15 at 10.36.15

If the output of above HTTP response looks like below, then I would like to add another column called 'Active' -

Actual HTTP response output:
Screenshot 2024-08-15 at 10.57.28

Expected:

Screenshot 2024-08-15 at 10.58.17

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sonny Gillissen 3,351 Reputation points
    2024-08-16T18:42:19.4066667+00:00

    Hi Vivek Komarla Bhaskar

    Thanks for reaching out on Microsoft Q&A!

    I don't know the exact purpose of your question, but what you could do is a split on new lines, and loop over it. Next, append the string with ',Active' on the first line (you can do this by using and index variable to check whether your on the first line) and ',1' on the other lines.

    Please click ‘Accept answer’ if you think my answer is helpful. Feel free to drop additional queries in the comments below!

    Kind regards,

    Sonny

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.