Integration

Get Involved. Join the Conversation.

Topic

    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
    Title:
    Response variable not found on the database
    Summary:
    Response variable not found on the database
    Content:

    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.

    Comment

    • 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

      Comparison.JPG

      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.