I had used Import Set API for importing a incident table data. First the data goes to "incident staging table" then after transformation, it will go to main "incident" table.
I tried from postman,
POST https://dev185338.service-now.com/api/now/import/u_incident_staging_table
with a payload,
{
"u_number": "EXT001", (coelasce)
"u_caller": "Priyam Sharma",
"u_short_description": "this is test",
"u_description": "this is test2",
"u_urgency": "2",
"u_impact": "2"
}
and its working fine as expected and successfully data inserted into incident.
But, when i am hitting this api from postman,
Regards
Priyam Sharma
Servicenow Developer
and its working fine as expected and successfully data inserted into incident.
But, when i am hitting this api from postman,
POST https://dev185338.service-now.com/api/now/import/u_incident_staging_table/insertMultiplewith payload,
{
"records": [
{
"u_number": "EXT002",
"u_caller": "Abel Tuter",
"u_short_description": "2nd short description",
"u_description": "2nd description",
"u_urgency": "1",
"u_impact": "3"
},
{
"u_number": "EXT003",
"u_caller": "Abraham Lincoln",
"u_short_description": "3rd short description",
"u_description": "3rd description",
"u_urgency": "3",
"u_impact": "1"
},
{
"u_number": "EXT004",
"u_caller": "Arron Ubhi",
"u_short_description": "4th short description",
"u_description": "4th description",
"u_urgency": "3",
"u_impact": "3"
}
]
}
it is responding me with 201 created response and also with a multi_import_sys_id also. but, when i am checking the incident staging table, the records are getting created but no values are populating inside the records.
it is responding me with 201 created response and also with a multi_import_sys_id also. but, when i am checking the incident staging table, the records are getting created but no values are populating inside the records.
I don't know, what's wrong? Is there any other role is required to give for multi import set request or payload must be different for this type of requests. i had already checked all ACLs, still no solution i am getting.
Regards
Priyam Sharma
Servicenow Developer
