Http Request got excel format response, how to convert?

[372402124]

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?

[Yoichi]

Hi,

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

HTTP Request

Regards,

[372402124]

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

[Yoichi]

Hi,

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

Regards,

[372402124]

this was the result

[Yoichi]

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,

[372402124]

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

[Yoichi]

Hi,

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

Regards,

[372402124]

@Yoichi

Wizard

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

[Yoichi]

Hi,

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

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 ?

Regards,

[372402124]

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

[Yoichi]

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,

[372402124]

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

[372402124]

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

[Yoichi]

Hi,

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

Regards,

[372402124]

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

[Yoichi]

Hi,

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

Regards,

[372402124]

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