How to access source record from export
I would like to compare data between export's source record and a lookup's response. And I would like to do this in a javascript function within any hook thats available. Whichi object or key has the export record. data?
0
Comments
Vreddhi Bhat you would want to use a postResponseMap script hook on the lookup step. You first need to result map the results of the lookup so that it gets merged into your record. At that point, the original source record and lookup results are 1 record and a page or those merged records are passed to the postResponseMap script.
Thank you. I think this will help me. I prolly need a bit hand holding here :). Looks like I cannot add/delete any data there as the length of data needs to remain same. Maybe I should add a dummy field in mapping and then just update it with relevant value within the hook?
Here is what I am trying to do:
Step 2 will result in a json response containing multiple records, and I would like to compare the surname field of lookup response with familyName field of ADP export record, and extract 'id' field of matching employee(lookup response), and update the export data with this key/value.
This is a one time activity that we are trying to do, as ofcourse identifying with firstName and lastName is definitely not the best way to find the uniqueness.
Vreddhi Bhat, the length of the data array can't be changed, but your data array is an array of records from your ADP step and within each object in the array is the lookup results for that individual record. You can delete and modify any of the data within the record that you want. For example, you could have
[{"employeeId":"123","lookupData":[{"name":"test"},{"name":"test1"},{"name":"test2"}]},{"employeeId":"456","lookupData":[{"name":"test"},{"name":"test1"},{"name":"test2"}]},
{"employeeId":"789","lookupData":[{"name":"test"},{"name":"test1"},{"name":"test2"}]}]
and then delete a the lookup data after you've manipulated the data
[{"employeeId":"123","name":"test1"},{"employeeId":"456","name":"test"},
{"employeeId":"789","name":"test2"}]
Does that make sense?
Please sign in to leave a comment.