Import set api

[manju12]

Hi team,

How to pass the data from staging table to target table using transform map and  import set api ?

Thanks,

Manju

[Ankur Bawiskar]

@manju12 

you don't need to do anything.

Simply insert data into staging table, have transform map associated with this import set table with target table as your table where data is to be transformed.

Once data is inserted into staging table, transform map automatically kicks in and will transform your data.

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

[manju12]

Hi Ankur,

Thank you. But how to trigger the staging table using import set API ? 

We have to trigger the staging table from import set API.

Thanks,

Manju

[Ankur Bawiskar]

@manju12 

import set API will be consumed by 3rd party.

Why are you consuming it from within the instance?

this is how 3rd party will consume

check these

Using Import Sets for REST Integration in ServiceNow 

#3 Rest Inbound Integration| Import Set API - ServiceNow Integration with 3rd Party tool using Rest 

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

[Dr Atul G- LNG]

Hi @manju12 

Just get the data into the staging table, and the rest will be handled by the transform map. It’s basically an out-of-the-box platform feature