sheeba
Reputable Poster
Hi Orchestrator Gurus ,
Hoping you are able to assist me .
Here’s what I am trying to do :
1. read a JDE table using Data Request with filters as needed - return lease number and LNID ( primary key on lease security deposit table ) - ( returns multiple records ; marked it Dataset1)
2. Pass the lease number and line ID to a Custom Request and get the row number on the form - used NER instead of groovy - returns Row Number ( returns multiple records based on iterate over Dataset1)
I made it work this far
3. Using a form request , I am now trying to update only the lease records based on the row numbers returned by the NER or the Custom Request ( as in step 2)
My orchestration always updates only the last row number returned .
How do I make this work and
what am I missing ?
please help!
Hoping you are able to assist me .
Here’s what I am trying to do :
1. read a JDE table using Data Request with filters as needed - return lease number and LNID ( primary key on lease security deposit table ) - ( returns multiple records ; marked it Dataset1)
2. Pass the lease number and line ID to a Custom Request and get the row number on the form - used NER instead of groovy - returns Row Number ( returns multiple records based on iterate over Dataset1)
I made it work this far
3. Using a form request , I am now trying to update only the lease records based on the row numbers returned by the NER or the Custom Request ( as in step 2)
My orchestration always updates only the last row number returned .
How do I make this work and
what am I missing ?
please help!