Hi all, Can someone help me creating json body from excel data and put in the HTTP Request(API) Body. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/5/b/e/5be3a846646cb6ca8a26effbc39ca791bd35c19f.png" data-download-href="/uploads/short-url/d6TcBMJqDMVkKKYEzNWrJemsTKv.png?dl=1" title="The image shows a workflow design interface with a sequence comprising logging messages and configuring an HTTP request, while the properties options for the request include settings for attachments and the request body. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows a workflow design interface with a sequence comprising logging messages and configuring an HTTP request, while the properties options for the request include settings for attachm…

Hi @Mandava_Naresh => Use Read Range Workbook to read the excel to data table Output → dt => Use the below syntax in Assign activity: jsonArray = New JArray( From row In dt.AsEnumerable() Select New JObject( New JProperty("Part", "1"), New JProperty("Direction", "N"), …

How to create json body to pass in HTTP Request(API) using each row data from my excel file

Help Something Else

system (system) Closed May 15, 2025, 1:19pm 5

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

Topic		Replies	Views
How to create json body to pass in HTTP Request(API) using each row data from my excel file and (I have to pass some fields as numbers and not string from excel) Something Else feedback	1	22	May 30, 2025
HttpRequest - Json Creation POST Body Off-Topic Discussions activities	21	4984	May 17, 2019
How to get the http request Json data into excel sheet? Studio studio , question , activities_panel	1	42	September 25, 2024
How to convert api json into excel i.e datatable Help	9	1917	May 14, 2019
Creation of Json string using entries of Excel Sheet Help	4	1540	January 15, 2021

How to create json body to pass in HTTP Request(API) using each row data from my excel file

Related topics