Skip to main content

Request formation - Kind of For Each loop

Comments

7 comments

  • Andrew Circelli
    Engaged

    Hello Sachin - 

    What are the APIs (Source & Destination) you are working with? 

    0
  • Sachin kumar Rana
    Engaged
    Celigo University Level 2: Seasoned

    Hi Andrew

    On the source we have Celigo State API.

    On the destination we have 2 lookups and 1 import.

    Out of 2 lookup the one which I am interested here is the last one.

    It accepts XML and respond XML. The response has multiple data which I want to pass down stream one by one. I was hoping that page size = 1 on the lookup will send the data to import one by one. I am expecting multiple request for import with this configuration

    My understanding is page size on export ( lookup here) should the send the data down stream packaging as one record per page.

    However when I run the flow and debug the lookup and import I don't see multiple request on import, also when I see under pages heading for lookup in Dashboard it has value 1. I think the count should be number of records return in response of lookup as page size is 1. 

    Please let me know if it explains the picture. 

    Thanks

    Sachin

     

     

     

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Sachin kumar Rana,

    It's still not quite clear to me. Could you post a screenshot of your flow in Flow Builder, what you have set in your export and what preview you're getting, as well as what you're getting in the lookup and what you're getting when you run the flow versus what you expect? What mapping are you doing? Do you have any hooks or filters applied? There are several factors to consider. Make sure to hide any PII before posting. Thanks!

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Sachin kumar Rana,

    In your import, do you have your One-to-many option set to No? If so, try using the One-to-many option set to Yes (Advanced). If that doesn't work, please provide the information I asked for above to help us understand your issue better. Thanks!

    0
  • Sachin kumar Rana
    Engaged
    Celigo University Level 2: Seasoned
    Hi Courtney,


    3rd Step: QXTEND Bank Create API
    ************************************
    The response preview

    {
    "page_of_records": [
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "5617-536d-4f73"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "448959968"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "391a-8a5a-40d4"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "451083116"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "47a9-885a-4ec1"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "455199587"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "47a9-885a-4ec1"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "455228164"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "2"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "82b6-7548-4b81"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "474290620"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code , Invalid Invoice Number"
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "65a8-aa2b-4ea6"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "474773339"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "650c-494d-40b3"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "477425723"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    },
    {
    "record": {
    "$": {
    "xmlns:ns1": "urn:schemas-qad-com:xml-services"
    },
    "ns1:ttRBankTransaction_ID": [
    {
    "_": "84ba-977f-4ac6"
    }
    ],
    "ns1:ttRCardknoxTransaction_ID": [
    {
    "_": "477914008"
    }
    ],
    "ns1:ttRBankStateLineNumber": [
    {
    "_": "1"
    }
    ],
    "ns1:tt_result": [
    {
    "_": "Error"
    }
    ],
    "ns1:tt_message": [
    {
    "_": " Invalid Customer code "
    }
    ]
    }
    }
    ]
    }


    ************************************************************
    Export Configuration
    **************************************************************




    I was expecting to split the record page wise and send it to step 4 one by one.

    Please suggest.

    Thanks




    1
  • Andrew Circelli
    Engaged

    Sachin - did you give the One-to-Many (Advanced) a try? Then set the 'Path to many' form box to the array with multiple records? 

    0
  • Sachin kumar Rana
    Engaged
    Celigo University Level 2: Seasoned

    Thanks Courteny & Andrew.

    It helped and I can split multiple records and send one by one, downstream with this options. 

    0

Please sign in to leave a comment.