topic RE: JSON to Collection Issue. in Product Forum

JSON to Collection Issue.

JishnuP_Nair1 — Wed, 05 Jul 2023 14:45:00 GMT

Hi All,

Greetings.

need some help.

I need to access the data in value field.

could you please help me with this.

------------------------------
Jishnu P Nair
------------------------------

RE: JSON to Collection Issue.

shashank.kumar280 — Wed, 05 Jul 2023 15:31:00 GMT

@Jishnu P Nair Access it using dot notation in a calculation stage

Coll_GroupDetails.infoField.output.JSON:Array.value

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: JSON to Collection Issue.

JishnuP_Nair1 — Wed, 05 Jul 2023 16:55:00 GMT

@shashank.kumar280 I tried that approach but not working.

getting error like this :

Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.

at AutomateUI.frmExpressionTest.MakeRow(IDataField item, Int32 top, Int32 tabIndex, Int32 scrollbarAdj)

at AutomateUI.frmExpressionTest.Populate()

at AutomateUI.frmExpressionTest..ctor(Control owner, clsProcess proc, String expr, clsProcessStage stage, String name)

at AutomateUI.ctlProcessExpressionBuilder.TestExpression(String localExpr)

------------------------------
Jishnu P Nair
------------------------------

RE: JSON to Collection Issue.

Athiban_Mahamathi — Wed, 05 Jul 2023 17:23:00 GMT

Hello Jishnu,

I think you are getting the above-mentioned error while evaluating the expression in the calc stage. Please run the calc stage in debug mode to get the value in an output variable. Are you using BP 6.10 version?

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: JSON to Collection Issue.

JishnuP_Nair1 — Thu, 06 Jul 2023 10:31:00 GMT

Hi,

Yes i am using BP 6.10.

I am runing the bot in debug mode as well.

------------------------------
Jishnu P Nair
------------------------------

RE: JSON to Collection Issue.

Athiban_Mahamathi — Thu, 06 Jul 2023 11:04:00 GMT

Hi Jishnu,

It was a known bug and BP fixed it in 6.10.1 version. You will get the error only when you try to evaluate the expression for collections. You won't get the error when you run the process in debug mode or from control room.

[BPE] BP-1497 - Error when evaluating stages referencing collections whilst debugging : (blueprism.com)

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------