Copy CSV file data to HTTP request body

Help
1

I have a requirement to copy records from a csv file,including the header row, to HTTP request body attribute to invoke a REST API end point.Could someone please share their inputs on how to achieve this?

2

hi @shravanb007

use read csv activity

3

@Ajju Read CSV activity will return the data in to a data table and i want to use this data inside the Body attribute of HTTP Post request. I am not sure whether we can give a Data Table variable as input in HTTP request body.Can this be done ?

4

@shravanb007 after read csv you can use output Data table activity which will return a string

might help you :slight_smile:

3 Likes
5

It depends on the structure of your request?

but as @Ajju has said, convert DT to string will allow you to add it.

The other option is to build your request from a template and extract data from datatable to insert / replace whats in request template.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.