How is my Transform Map getting triggered automatically?

[vmanojkumar]

Hello all,

I’m new to ServiceNow and working on a Workday integration.

The data from Workday is being inserted into a staging/import set table, and I have a Transform Map configured to move the data to the target table.

The Transform Map seems to be running automatically as soon as the records are inserted into the staging table. However, I have not configured any Scheduled Import, manual transform, Flow, or other explicit trigger.

A few additional details:

1. The staging table and target table are available under the same application/module.

2. The records are inserted into the staging table successfully.

3. The Transform Map appears to process the records immediately afterward.

4. I would like to identify exactly what is initiating the transformation rather than simply knowing that the transformation is occurring.

Could someone please help me understand how the Transform Map is being triggered automatically and where I can check what is initiating the transformation?

Thanks!

[vmanojkumar]

@jasonutah ,

I’m not using a Data Source with a Scheduled Import in this case.

Currently, I have two integrations in place with Workday:

1. WQL integration – The data is retrieved from Workday using a WQL query and then inserted into the ServiceNow staging table.

2. RaaS API integration – Workday exposes a RaaS API, through which I receive the data and insert it into the staging table.

So, in both cases, the data is being inserted into the staging table through the integration itself, rather than through a scheduled import.

What I’m trying to understand is what is triggering the Transform Map automatically after the records are inserted into the staging table, since I have not configured a Scheduled Import or any manual transform process.

[vmanojkumar]

I am not using a data source scheduled import in this case.

Currently I have two integrations with Workday. In one integration I am getting the data using WQL query from Workday. In the second one, Workday has exposed a RaaS API and I am getting the data through that API.

In both cases the data is getting inserted into the staging table.

What I am trying to understand is what is triggering the transform map automatically after the records are inserted into the staging table. I have not created any scheduled import, manual transform or anything similar for these integrations.

Is there any other process/configuration which can automatically trigger the transform map when records are inserted into the staging table?

[Ankur Bawiskar]

@vmanojkumar 

it should work the same way for the other table if it's extending Import Set Row table i.e. your table should be import set staging table

share the complete setup and screenshots of the config

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[vmanojkumar]

@Ankur Bawiskar ,

Both the staging tables are created by extending the Import set row table.

[vmanojkumar]

@Ankur Bawiskar ,

Just now reconfirmed , both the staging tables are created by extending the Import Set Row table.