• State Not Answered
  • Replies 12 replies
  • Subscribers 11 subscribers
  • Views 1912 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

API is giving error invalid JSON format

poojas7155
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 Lead Developer
                                                                                       in reply to poojas7155

                                                                                      Did you read my previous response?

                                                                                    • 0
                                                                                      Certified Associate Developer
                                                                                       in reply to Mathieu Drouin

                                                                                      yes do u think wrong API end point can give this error

                                                                                    • 0 in reply to Narasimha Sai Yerram

                                                                                      Hello, this post seems old but the issue seemed to be that the endpoint was returning an HTML instead of a JSON.

                                                                                      Appian cannot convert HTML to Appian Values when using the "Convert JSON to Appian value", hence the error.

                                                                                    Reply Children
                                                                                    © 2024 Appian. All rights reserved.
                                                                                    We want to hear from you! Submit a review on Gartner or G2.