Skip to main content

Stop Flow if a Lookup yields zero results?



  • Stephen Brandt Documentation Manager Community moderator
    Great Answer
    Top Contributor
    Celigo University Level 3: Master

    Hi, Steve Klett.

    Have you tried this option? 

  • Steve Klett Channel Partner
    Awesome Follow-up
    Celigo University Level 2: Seasoned

    Hi Stephen,

    Doesn't apply in this case because IIO correctly interprets a lookup with no results as a success. What is needed is an option on the lookup to tell it zero results is NOT a success. Super easy feature to add, you guys should totally do it. :)

  • Muneswara Thotakura NetSuite Integration Whiz Salesforce Integration Whiz Software Engineer
    Celigo University Level 4: Legendary

    Hi Steve Klett,
         If this is the case, then you can set the success path in your import lookup.
    Ex: let say from the lookup import for success, you got results as: {results [{id: "123"}]. and for empty response you got as {results : []}.

    Now all you need to do is set the success path as "results[0].id", now always it will check for the path present or not from the response, otherwise, it will give you an error.

    you can find the success path in the import lookup --> Non-standard API respose --> Success path. Add the success path here, you no need to set the success value. all we are required to check the id present in a zeroth index or not.

    Hope this helps you.


Please sign in to leave a comment.