Regarding Rest integration import set API

[Bhavana Ramesh1]

Hello,

"{"error":{"message":"Invalid staging table""detail":"Specified table does not extend'sys_import_set_row'"}"status":"failure"}", The following error is populating in logs when an incident is created in source instance( I have created a Staging table extending import set row in target instance) and also i am getting the below error.

org.mozilla.javascript.EcmaError: Cannot read property "0" from undefined
Caused by error in sys_script.dc22603bdb460010fac27a61399619d8.script at line 21

18: parsedJSON=JSON.parse(responseBody);
19: var result=parsedJSON["result"];
20: gs.log("result"+ result);
==> 21: var targetTicNumber = result[0]["display_value"];
22: var targetSys_id=result[0]["sys_id"];
23: current.u_client_sysid=targetSys_id;
24: var logString = "targetTicNumber -" + targetTicNumber +"\ntargetSys_id-" +targetSys_id;( screenshot for the before insert BR is attached) and the result is showing like undefined.

Thanks 

Bhavana

[Noor · Accepted solution]

Hi Bhavana,

{"error":{"message":"Invalid staging table""detail":"Specified table does not extend'sys_import_set_row'"}"status":"failure"}

for this error you can check with rest message end point as well as HTTP method end point this problem occurs when there is a mismatch in end point URL 

as you are extending the sys_import_set_row i think you are trying with import set API Please also check the end point format it should be

https://devxxxx.service-now.com/api/now/import/{stagingTableName}

Thanks,
S Noor Mohammad