Trigger Robust Transform Map on Record Insert

[pgvaishnav]

Hi Team,

I’m working on a use case where I need to insert a record into a staging table, and then automatically execute a Robust Transform Map when the record is inserted.

The reason for using a Robust Transform Map is that I need to perform operations on multiple target tables sequentially. This is part of a MuleSoft integration where user/HR profile data is received via an API, inserted into the staging table, and then needs to be processed into the respective target tables through the Robust Transform Map.

Has anyone implemented a similar approach? What’s the best way to trigger the Robust Transform Map right after the staging record is created?

Thanks in advance!

[Ankur Bawiskar]

@pgvaishnav 

Is it not triggering after record is inserted into Staging table?

check this

Import Set API with Robust Transform map - response is always "Invalid table" error 

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

[pgvaishnav]

Hi @Ankur Bawiskar ,
Thank you for your response, No the robust transform map is not getting triggered

[Ankur Bawiskar]

@pgvaishnav 

if you are using Import Set API and inserting data into staging table using that then it should trigger the transform map.

If not then try to use GlideImportSetTransformer

check the link I shared above.

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