topic RE: HTTP Status Code: 500 error while posting JSON to a Web API in Product Forum

HTTP Status Code: 500 error while posting JSON to a Web API

GauravMarkandey — Wed, 01 Mar 2023 13:52:00 GMT

Greetings,
I need to post the following JSON to a REST API:
{"extractionname" : "API_TEST_SEAA","columns" : ["NAME,ADDR,CITY"],"values" : [["Rohit","ABC","Pune"],["Mugun","ABCd","Pune"]]}

However, I get a HTTP 500 Error when executing the Web API action, and using the Utility-HTTP as well. The same API call is successful from POSTMAN. The error details are as follows:

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 500
HTTP Response Content: <!DOCTYPE HTML>
<html>
<head>

<script type="text/javascript" src="/ispring/developer/lib/prop-types/prop-types.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/ispring/developer/lib/react/umd/react.production.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/ispring/developer/lib/react-dom/umd/react-dom.production.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/ispring/developer/lib/react-dnd/dist/ReactDnD.min.js" charset="utf-8"></script>

<script src="/ispring/developer/modules/aera-react-library/arl.min.js" type="text/javascript"></script>
<link href="https://communities.vmware.com/ispring/developer/modules/aera-react-library/arl.min.css" rel="stylesheet"/>

<body>

<div id="app" style="width: 100%;height: 100%;"></div>

<script>
window.ReactDOM.render(React.createElement(window['aera-react-library'].ErrorView, {
requestId: "cd40a45b-33c6-45e4-90f4-a535e84d9e90"
}), document.getElementById('app'));
</script>

</body>
</html>

Thanks & Regards,
Gaurav M

------------------------------
Gaurav Markandey
Senior Consultant
EY LLP
Asia/Kolkata
------------------------------

RE: HTTP Status Code: 500 error while posting JSON to a Web API

shashank.kumar280 — Wed, 01 Mar 2023 14:37:00 GMT

Hi Gaurav,

Can you post a screenshot of your parameters for Post Data action. That will help to debug.

A screenshot of POSTMAN config would be useful as well.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: HTTP Status Code: 500 error while posting JSON to a Web API

GauravMarkandey — Wed, 01 Mar 2023 14:46:00 GMT

Hi Shashank,
Thank you for your response.
Please refer the attached screenshots for Web API definition and POSTMAN details.

------------------------------
Gaurav Markandey
Senior Consultant
EY LLP
Asia/Kolkata
------------------------------

RE: HTTP Status Code: 500 error while posting JSON to a Web API

shashank.kumar280 — Thu, 02 Mar 2023 14:01:00 GMT

Hi Gaurav,

You mentioned that you had tried with Utility HTTP also. Does your config look like below.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: HTTP Status Code: 500 error while posting JSON to a Web API

GauravMarkandey — Fri, 03 Mar 2023 04:16:00 GMT

Yes, that is correct.

------------------------------
Gaurav Markandey
Senior Consultant
EY LLP
Asia/Kolkata
------------------------------