Http Request got excel format response, how to convert?

Help Studio
1

Http Response as below , it was excel format and not able leverage Deserialize JSON to convert, may i know how to get data from the response?

screenshot9
screenshot91690×916 276 KB

2

Hi,

Can you try ResourcePath property? This will save response to a file.

image
image462×801 48.9 KB

Regards,

3

Trying on this, kindly check if path set correct, i got this error

screenshot10
screenshot101624×762 313 KB

4

Hi,

Can you check Response Status property and Response content property without setting ResourcePath?

Regards,

5

this was the result

screenshot11
screenshot111677×893 315 KB

6

HI,

The above shows response status is 0. This means there is something wrong with communication with server. Can you check your network, settings for proxy etc?

Regards,

7

Network and setup all keep same as postman, postman able to got correct response

image
image1048×703 55.1 KB

8

Hi,

Can you try Wizard of HTTP Request activity? First, we need to communicate with server via HTTP(s).

Regards,

9

Trying with Wizard , keep same setup on headers with postman and add token, but still got response status as 0, kindly help to check where had issue

screenshot12
screenshot122930×1066 250 KB

10

Hi,

In my environment, your URL returns http status via Http request wizard.

image
image596×693 37.6 KB

I suppose there is something wrong with your network matter such as proxy , security gateway etc. Is your network is in company and there are some security gateways?

Or can you try to access this site https://forum.uipath.com ?

image
image596×693 39.3 KB

Regards,

11

yes, i am using company network and try with Uipath URL you provided, able to get status code as 200, my request using post method

image
image1515×931 81.1 KB

12

HI,

It seems no problem regarding intra netowrk because of successful response from this forum site.

It might be necessary to find difference with 2 request : postman and uipath to investigate content of them using Fiddler etc.

Regards,

13

Much thanks Yoichi, i am trying to add headers parameter one by one and felt possible some of them had error, when i add below parameter, response status start to change as 0, kindly let me know if ‘calculated when request is sent’ was wrong to enter here, but i saw postman is like this

image
image1599×787 42.2 KB

14

meanwhile, may i know if HTTP Request wizard could add request body? i didn’t find in the window, i think that is the reason not able to get correct response

15

Hi,

The wizard is not 100% compatible with the activity. If you need to set request body, please try actual run.

Regards,

16

okay, now identify the issue due to below header info, may i know what value should be enter in Uipath? in postman actual it didn’t have value and if i set as null in Uipath, will get response status 0

image
image916×757 53.8 KB

17

Hi,

I think it’s not easy to calculate Content-Length in advance. If you remove these headers, it still fails?

Regards,

18

Yes, now only these two removed will fail, in postman i try same, got same error like Uipath, once add them, got success