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 

Hope you are doing good.

Did my reply answer your question?

💡 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

[Viraj Hudlikar]

Hello @manju12 

Refer this link for more understanding on same. 
Using Import Sets for REST Integration in ServiceNow - ServiceNow Guru

If my response has helped you, hit the helpful button, and if your concern is solved, do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Renat Akhmedov]

Hi @manju12,

To move data from a staging (import set) table into a target table using a Transform Map and the Import Set API, you generally need three parts:

1. Import Set table (staging table) – usually u_xxx_import or system-generated u_<source>_import.

2. Transform Map – defines how fields from the staging table map to the target table.

3. Import Set API – to load data into the import set table and optionally trigger the transform.

I hope it helps. If my answer was helpful, please don’t hesitate to give it a thumbs-up - it only takes a second, but it means a lot to me. Thank you!

Best regards,
Renat Akhmedov