API is giving error invalid JSON format

Certified Associate Developer

Hi All,

I am getting this error when i select convert JSON to appian I am getting error invalid JSON format but when I select raw value i get response . Is Swagger file not formated well to return the JSON which Swgager file version will appian 23.2 will use and consume 

ion response
error-result-guidance

The response body could not be converted to an Appian value The jsonText parameter was not valid JSON. Received: <...

Time

498 ms Prepare: 4 ms - Execute: 494 ms - Transform: < 1 ms

Value: Result
This value is available as a node output when using the Call Integration smart service in the process modeler and as fv!result when configuring onSuccess and onError parameters inside a saveInto on a SAIL component or as part of a Web API.
      • (Text)
        • m)

        Discussion posts and replies are publicly visible

      Parents
      • 0
        Certified Associate Developer
        • successfalse(Boolean)
            • resultHttpResponse
                • statusLine"HTTP/1.1 200 "(Text)
                    • statusCode200(Number (Integer))
                        • headersDictionary
                            • Cache-Control"no-cache"(Text)
                                • X-Frame-Options"SAMEORIGIN"(Text)
                                    • Content-Security-Policy"frame-ancestors 'self'"(Text)
                                        • X-UA-Compatible"IE=edge"(Text)
                                            • Content-Type"text/html;charset=UTF-8"(Text)
                                                • Content-Length"3948"(Text)
                                                    • Date"Wed, 23 Aug 2023 13:39:23 GMT"(Text)
                                                        • Keep-Alive"timeout=60"(Text)
                                                            • Connection"keep-alive"(Text)
                                                              • contentType"text/html;charset=UTF-8"(Text)
                                                                  • body"<!DOCTYPE html> <HTML LANG="en-US"> <HEAD> <META http-equiv="content-type" content="text/html; charset=UTF-8"> <script>var csThemeSupportPath = "/img/style/images/";</script> <LINK REL="stylesheet" TYPE="text/css" HREF="/img/style/screen.css?v=1697.285" id="primaryCSS"> <LINK REL="stylesheet" TYPE="text/css" HREF="/img/style/csform.css?v=1697.285"> <link rel="shortcut icon" href="https://cs-1-meag-i.eu.munichre.com/img/favicon.ico" type="image/x-icon"> <TITLE>Content Server - Error</TITLE> </HEAD> <BODY CLASS="pageBody"> <A id="top"></A> <LINK REL="stylesheet" TYPE="text/css" HREF="/img/style/jquery-ui.min.css"> <script src="/img/core/jquery.min.js"></script> <script src="/img/core/jquery-ui.min.js"></script> <script src="/img/core/ajax_dhtml_util.js"></script> <script src="/img/core/globalmenu.js"></script> <script src="/img/menu_en_US.js"></script> <script src="/img/menu.js"></script> <script src="/img/core/jquery.validate.min.js"></script> <script src="/img/core/jquery.validate_en_US.js"></script> <script src="/img/core/csform.js"></script> <script src="/img/core/csform_en_US.js"></script> <script src="/img/webnode/multipartupload_en_US.js"></script> <script src="/img/webnode/multipartupload.js"></script> <script> multipartSetup(false, 2050, 4100, 1); </script> <SCRIPT> function checkTabKey( event ) { if( event !=undefined ){ if ( event.keyCode == 9 ) return true; else return false; } else if( window.event != undefined ){ if ( window.event.keyCode == 9 ) return true; else return false; } else{ return false; } } function goToURL( url ) { if ( ( parent == self ) || ( parent.ButtonBarFrame != null ) ) { location.href = url; } else { parent.location.href = url; } } </SCRIPT> <A id="start"></A> <SCRIPT> contentTable = true; document.write( '<TABLE CLASS="pageBody tightTable" STYLE="height: 100%">' ); document.write( '<TR>' ); document.write( '<TD CLASS="cs-valign-top">' ); </SCRIPT> <HEADER role="banner"> <FORM NAME="headerForm"> <TABLE CLASS="tightTable"> <TR> <TD CLASS="header cs-valign-top"> <div id="header" class="csx" role="navigation" aria-labelledby="logo"> <div id="header-inner"> <h1 id="logo"> <a href="/OTCS/cs.exe?func=Enterprise.Home" title="Go to Enterprise Workspace">Open Text Content Server</a> </h1> </div> </div> <SCRIPT> baseURL = "/OTCS/cs.exe" </SCRIPT> <DIV ID="functionMenuParent"> <IFRAME ID="bridgeFrame" SRC="/img/spacer.gif" TITLE="hidden frame"> </IFRAME> </DIV> <TABLE CLASS="tightTable"> </TABLE> </TD> </TR> <TR> <TD CLASS="pagebody cs-valign-top"><IMG HEIGHT="15" ALT="" SRC="/img/spacer.gif" WIDTH="1" BORDER="0"></TD> </TR> </TABLE> </FORM> </HEADER> <SCRIPT> function resetPopup() { } document.write( '<TABLE CLASS="pageBody tightTable" STYLE="padding:15px; margin-left:auto; margin-right:auto;">'); document.write( '<TR>' ); document.write( '<TD CLASS="cs-valign-top">'); </SCRIPT> <main tabindex="0"> <!-- --> <div class="cs-form-container cs-form-message-container"> <div> <div class="cs-form-line-text cs-form-message cs-form-message-error" title="Error" id="errMsg" > <p> Content Server Error: Error dispatching request. </p> <p> Required input argument "func" not specified. </p> </div> </div> </div> </MAIN> <SCRIPT> if ( window.contentTable ) { if ( contentTable ) { document.write( '</TD></TR></TABLE></TD></TR><TR><TD CLASS="cs-valign-bottom">' ) } } </SCRIPT> <footer role="contentinfo"> <div id="footer" tabindex= "0"> <div class="copyright"> OpenText Content Server version 21.4. Copyright &copy; 1995 - 2021 Open Text. All Rights Reserved. </div> </div> </footer> <SCRIPT> if ( window.contentTable ) { if ( contentTable ) { document.write( '</TD></TR></TABLE>' ) } } </SCRIPT> </BODY> </HTML> "(Text)
                                                                    • errorIntegrationError
                                                                        • title"Error processing integration response"(Text)
                                                                            • message"The response body could not be converted to an Appian value"(Text)
                                                                                • detail"The jsonText parameter was not valid JSON. Received: <..."(Text)
                                                                                  • connectedSystemnull(Connected System)
                                                                                      • binaryDoc75MbLimitExceededfalse(Boolean)

                                                                                      Error when I select convert JSON to Appian values

                                                                                    • 0
                                                                                      Certified Associate Developer
                                                                                      in reply to poojas7155

                                                                                      Hi  , did you get it fixed?
                                                                                      Please help me i'm facing the same issue.

                                                                                    • 0
                                                                                      Certified Lead Developer
                                                                                      in reply to Rishu Kumar Gupta

                                                                                        As mentioned by others earlier in this discussion, the API was returning HTML instead of a JSON response. 

                                                                                      Appian cannot convert HTML to Appian Values when using the "Convert JSON to Appian value". So check if you are receiving HTML as well in response or not

                                                                                    Reply Children