mapping JSON feilds to importset table feilds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2025 11:41 PM
Hi team
im trying to map the feilds in the json req to my importset table feilds.
example json
{
test1 ="abc",
test2="cdf"
}
my import set fields that i want to map to above
u_test1
u_test2, how do i map these? i know its possible using scripted REST API but i want to use import set api for this, any insights are appreciated
Kind Regards,
Mohamed Azarudeen Z
Developer @ KPMG
Microsoft MVP (AI Services), India
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2025 04:36 AM
if you are planning to use the JSON request and post to Import set table API then the json key should match the staging table names.
So if staging field names are u_test1, u_test2 and so on then the JSON will look like this
{
"u_test1":"test1",
"u_test2":"test2",
"u_test3":"test3"
}
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2025 05:31 AM
Hey ankur, im asking like how to map the json feilds to my import set table feilds manually?
importset - u_test and json test?
how can i map this manually ?
Kind Regards,
Mohamed Azarudeen Z
Developer @ KPMG
Microsoft MVP (AI Services), India
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2025 05:40 AM
that cannot happen.
If 3rd party wants to use Import Set API then they need to send JSON with that syntax only.
The json key means the staging field name
It's clearly mentioned in documentation.
if they want to send custom JSON request then you need to use Scripted REST API and then handle it
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2025 06:43 AM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader