Get Involved. Join the Conversation.


    Janardhan Kothapalli
    Response variable not found on the database
    Topic posted March 26, 2018 by Janardhan KothapalliGold Medal: 3,500+ Points, last edited March 27, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Database, Integration 
    53 Views, 12 Comments
    Response variable not found on the database
    Response variable not found on the database

    Hi Team,


    I'm facing an issue while developing an integration.

    where as integration monitoring, the value is provided. the same one is mapped to other connection request, for this throwing an error stated: Variable not found on the database.

    Please find attachment of  integration flow for reference. I will share the iar if required.

    Thanks in advance.


    • Hemanth Lakkaraju

      You need to create a rest connection for SN_TEST endpoint and use it in SHIPMENT_CONVERT flow.

      Can you try using this function in the request mapper to GetShipmentDetails in Consignor_Shipment flow?

      You may need to export the flow, make changes manually to the xsl, (may be add namespace declaration of prefix for the function) and then re-import and test.

    • Hemanth Lakkaraju

      Yes. Try and let me know. - You may need to apply it for options and data query params both

    • Hemanth Lakkaraju

      I can see the only difference in original iar and updated iar as below


      I think QueryParams are by default url-encoded when sent to the endpoint. In the first case - %22 looks like the % symbol is getting url-encoded literally and causing the failure.