The CreatorCon Call for Content is officially open! Get started here.

How can I retrieve this sys_id when the transform map is triggered automatically?

PavanKumar8
Tera Contributor

Hi 

I am automating the Excel upload process that runs when my custom request record gets approved. The data is being imported successfully, but I also want to store the request record’s sysid or number in the target table to identify which request triggered the import.

Could anyone please help me understand how to achieve this?

Thanks in advance

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@PavanKumar8 

It's somewhat challenging to know the REQ/RITM number in your transform map since there could be multiple requests raised around same time.

Could you please share your config what you have done to achieve this?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader