HTTP Request return status

Help
1

Hi.
I am currently into making a robot that check wether or not, a website is up.
Everything is going good, exept the status.
I am using Data Tables (have tried with Dictionary).
I have a excel with site name and their URL in 2nd column.
3rd column is reserved for results.
I use a sequence, Excel App. scope to read from Excel and parse them to a Data Table.
Then I use HHTP Request to check availability on site, but the column remains blank.
The result to variable DTresult as a string.
I included a image of the structure, can you point me into right direction?
Thanks in advance.

image
image564×1572 29.6 KB

2

so you want to add Dtresult to Column 3?

3

Hi and thanks for replying so fast.
Yes, but somehow it doesn’t look like it get the result to DTresult, so it can be entered.
I added 2 message boxes, 1 before and one after, and both are the same, meaning no value added to DTresult.

4

What are the StatusCode results of your HTTP Requests?

5

you can use add data row in for each row and pass your Dtresult like this in ArrayRow Property {Dtresult}

6

There are no errorcodes, it runs without errors, but the field is empty.
I cannot upload the file to you, as i am still a new user.
But i took a screenshot of properties for that request. All i entered is…
EndPoint: DTurl (from Excel column 2, changed to DTurl with Get Row Item)
Result: DTresult
I’m using this extention: UiPath.WebAPI.Activities by UiPath (JSON, REST, SOAP, XML)
The properties look like this:

image
image330×593 13.5 KB

7

I tried what you said, but gets a error.
A value of the type ‘String’ can not be converted to 1-dimentional matrix of Object (translated, so may not be exact errorcode)
image

8

not like that
{Dtstatus} like this

9

These are my variables.

image
image1218×162 10.3 KB

I am sorry, thought the brackets were to simulate it was a variable, my bad.
I did as you suggested, but now i get the errorcode:

19.4.2+Branch.master.Sha.e17a3bedca2a7da0d0b716b5f8f765d1d5ef1ddc

Source: For Each Row

Message: Collection was modified; enumeration operation might not execute.

Exception Type: System.InvalidOperationException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.InvalidOperationException: Collection was modified; enumeration operation might not execute.
at System.Data.RBTree1.RBTreeEnumerator.MoveNext() at UiPath.Core.Activities.ForEach1.InternalExecute(NativeActivityContext context, IEnumerator valueEnumerator)
at UiPath.Core.Activities.ForEach`1.GetStateAndExecute(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.ActivityCompletionCallbackWrapper.Invoke(NativeActivityContext context, ActivityInstance completedInstance)
at System.Activities.Runtime.CompletionCallbackWrapper.CompletionWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

I am going to a meeting, but eager to return to this tread :slight_smile:For now, thank you so much for helping me out :slight_smile:
Much appriciated :slight_smile:

10

Status is String, and not Int32 as shown