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

[Ankur Bawiskar]

Hi Bhavana,

Did you try to print the json response received?

Does it have that key?

Can you share the json response here?

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Bhavana Ramesh1]

Hello Ankur

Before parsing to json only iam getting an error, so ideally the result is undefined and i am not sure about the key in that 

Thanks,

Bhavana

[AbhishekGardade]

It seems you are doing it in wrong way,

parsedJSON=JSON.parse(responseBody);

var result=parsedJSON["result"];

gs.log("result"+ result);

var targetTicNumber = result[0]["display_value"];

var targetSys_id=result[0]["sys_id"];

You can try on this way:

var responseBody = response.getBody();

var httpStatus = response.getStatusCode();

var obj = JSON.parse(responseBody); //define JSON parsing for the response JSON file to decode

var targetIncidentID = obj.result.sys_id;

// sys_id is key from response received , you can replace with any key in json like obj.result.number or obj.result.cmdb_ci 

// obj.result.KeyNAME : will be the same for all

gs.log("HTTPCODE:"+httpStatus+"BODY"+response.getBody());

Please mark as Correct Answer and Helpful, if applicable.
Thank You!
Abhishek Gardade

[Bhavana Ramesh1]

Thank you Abhishek for the information, it was helpful:)