The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Recommended Posts

Posted
I am told that it is possible to add some conditional logic to a Lookup step inside Scribe Online. It appears that you can drag an if/else block below the Lookup but it isnt clear how to write the formula. Has anyone been able to get this to work
  • 2 months later...
  • 2 weeks later...
Posted

A common pattern used in Scribe is this:(see attached Sample)

Do a lookup and right after the lookup, add an IF /Else block to determine if that particular record lookup, was successful or not.

You can add as much lookups and If blocks as you need to determine the exact results and actions needed in your App Flow design logic.

 

Result.RecordsMatchedcan have three results:

match = 0 ; no match found, in that case the lookupfields are set to NULL, (no use to keep using these resultsets as it will most likely generate errors in the next lookup or update block.)Sometimes this is what you expect in order to do an alternate lookup (i.e. lookup account, if account not found, lookup contact.)

match =2 ; meaning multiple matches have been found, this is usually also not a good result, since you will need to use a Fetch block to loop thru all the different match results. (a lookup only shows one resultset, no matter how many matches you have.)

match =1 ; usually this is what you expect from a lookup result and this asserts you that your data is ready for the next step in the integration.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...