- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2022 07:08 AM
Hello Guys,
I have just simple question on you.
I have simple staging table with its transform map, when I am doing test payload through import set api in REST API Explorer.
I am getting 201 - created. Thats completely fine. Everything is working fine...
But response is quite non-sense. Do you know how I can affect of response ?? or is there anywhere some documentation relevat about responses ?
This is my response.
see "display_name": "u_ricoh_device" - what a nonsense ? where the u_ricoh_device is feeded into response ?
can you please explain how I can affect Import Set API response ? thank you very much guys for help ❤️
{
"import_set": "ISET3783076",
"staging_table": "u_incident_staging_table",
"result": [
{
"transform_map": "Incident Staging Table",
"table": "incident",
"display_name": "u_ricoh_device"
"display_value": "",
"record_link": "https://secret.service-now.com/api/now/table/incident/1c0fb768c3291550f16df1177d013109",
"status": "inserted",
"sys_id": "1c0fb768c3291550f16df1177d013109"
}
]
}
Solved! Go to Solution.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2022 01:59 PM
Here is the answer for those who have the same problem.
display_name and display_value in Import Set API behave OOB following.
display_value - "The value of the field designated as the display field. For example, the display field for the Incident table is the Number field and an example value would be INC10001"
display_name - "The name of the field that is set as the display field for the record that was created or modified"
that means that it depends on the table field and value for display=true/false.
In this case, there was a field on the incident table which was called u_ricoh_device, and the display was set to true. > so It broke the standard behavior of Import Set API output for target table "incident" in transform map.
So be aware of the display true/false on your table's fields. That's all.
I would also recommend reading Kieran's Article mentioned above.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2022 03:51 AM
Feel free to read through my Import Set API article, particularly the bit about adding information to the response object
Import Set API - Goodbye SRAPIs? - Developer Community - Article - ServiceNow Community
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2022 01:48 PM
Hello Kieran - thanks for answer and also for your great Article ! Its just awesome.
Marking as Helpful !!! ❤️
See my reply in next comment what was the trouble with display_name and display_value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2022 01:59 PM
Here is the answer for those who have the same problem.
display_name and display_value in Import Set API behave OOB following.
display_value - "The value of the field designated as the display field. For example, the display field for the Incident table is the Number field and an example value would be INC10001"
display_name - "The name of the field that is set as the display field for the record that was created or modified"
that means that it depends on the table field and value for display=true/false.
In this case, there was a field on the incident table which was called u_ricoh_device, and the display was set to true. > so It broke the standard behavior of Import Set API output for target table "incident" in transform map.
So be aware of the display true/false on your table's fields. That's all.
I would also recommend reading Kieran's Article mentioned above.