read data from Json - string

(0) Share

Report

Posted on by SarathVarma

122

HI Every one,

i was trying to read Json message and i could able to read header but not the inner node (Lines) in List details
any suggestion or any existing classes which we have for sub noted in system.

str json;
List values = new List(Types::Class);
ListEnumerator value;
json = '[{"FieldValues": [{"parmFirst": "ValueFirst", "parmSecond": "ValueSecond", "Lines":[{"parmFirst": "ValueFirst", "parmSecond": "ValueSecond"}] }]}]';

values = FormJsonSerializer::deserializeCollection(classnum(List), json, Types::Class, classStr(JSONContract));
value = values.getEnumerator();
while(value.moveNext())
{
JSONContract JSONContractCurrent = value.current();
info(strfmt('%1',JSONContractCurrent.parmFirst(), JSONContractCurrent.parmSecond()));-- Values are getting

info(strfmt('%1',JSONContractCurrent.parmLinesDetail())) -- empty List
}

Thanks in Advance.

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

You can use RetailCommonWebAPI or (dataContract)

community.dynamics.com/.../563100

dev.goshoom.net/.../

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report
Please always post your code with line indentation - it makes code much easier to read. Use Insert > Insert Code to achieve that.

You have this JSON:

[ { "FieldValues": [ { "parmFirst": "ValueFirst", "parmSecond": "ValueSecond", "Lines": [ { "parmFirst": "ValueFirst", "parmSecond": "ValueSecond" } ] } ] } ]

and you're trying to deserialize it as a list of instances of JSONContract class. Could you show us your definition of this class, please?

Was this reply helpful? Yes No
SarathVarma 122 on at

Like (0)

Report

i have used contract class as below

[DataContract]

class JSONContract

{

String50 parmFirst, parmSecond;

List lines = new List (types::Class);

[DataMemberAttribute('parmFirst')]

public String50 parmFirst(String50 _parmFirst = parmFirst)

{

parmFirst = _parmFirst;

return parmFirst;

}

[DataMemberAttribute('parmSecond')]

public String50 parmSecond(String50 _parmSecond = parmSecond)

{

parmSecond = _parmSecond;

return parmSecond;

}

[DataMemberAttribute('lines')],

aifcollectiontypeattribute('lines', types::class, classstr(JSONLineContract)),

aifcollectiontypeattribute('return', types::class, classstr(JSONLineContract))]

public List parmLines(List _lines = lines)

{

lines = _lines;

return lines;

}

}

Iam getting 1st and 2nd param method values but not getting for line details

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report
Please start following my advice and use Insert > Insert Code (in the rich-formatting view) to paste source code. Let me format your code correctly and re-post it in the right way, but please do it by yourself next time.

[DataContract] class JSONContract { String50 parmFirst, parmSecond; List lines = new List(Types::Class); [DataMemberAttribute('parmFirst')] public String50 parmFirst(String50 _parmFirst = parmFirst) { parmFirst = _parmFirst; return parmFirst; } [DataMemberAttribute('parmSecond')] public String50 parmSecond(String50 _parmSecond = parmSecond) { parmSecond = _parmSecond; return parmSecond; } [ DataMemberAttribute('lines'), AifCollectionTypeAttribute('lines', Types::Class, classStr(JSONLineContract)), AifCollectionTypeAttribute('return', types::class, classstr(JSONLineContract)) ] public List parmLines(List _lines = lines) { lines = _lines; return lines; } }

An obvious problem is that you refer to lines parameter in AifCollectionTypeAttribute, but the actual name is _lines.

Was this reply helpful? Yes No
SarathVarma 122 on at

Like (0)

Report

i have changed it to _lines still i'm getting empty list.

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report

How are you testing it? According to your original code, you don't check the list, but the return value of parmLinesDetail(). Maybe you have a bug in this method. Note that no such method exists in the code you showed to us - are you sure you gave at the right version?

Was this reply helpful? Yes No
SarathVarma 122 on at

Like (0)

Report

it's my mistake I have given code from different server but I’m referring to this method JSONContract.parmLines()

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report

If you have a problem with deserializing JSONLineContract object, maybe you have a problem in the class. Please show us your code.

Also, I would check the list directly in the debugger, rather then depending on a default conversion from a list of JSONLineContract objects to string.

Was this reply helpful? Yes No
SarathVarma 122 on at

Like (0)

Report
[DataContract] class JSONLineContract { String50 parmFirst, parmSecond; [ DataMemberAttribute('parmFirst') ] public String50 parmFirst(String50 _parmFirst = parmFirst) { parmFirst = _parmFirst; return parmFirst; } [ DataMemberAttribute('parmSecond') ] public String50 parmSecond(String50 _parmSecond = parmSecond) { parmSecond = _parmSecond; return parmSecond; } } ------------------------------------------ [DataContract] class JSONContract { String50 parmFirst, parmSecond; List lines = new List (types::Class); [ DataMemberAttribute('parmFirst') ] public String50 parmFirst(String50 _parmFirst = parmFirst) { parmFirst = _parmFirst; return parmFirst; } [ DataMemberAttribute('parmSecond') ] public String50 parmSecond(String50 _parmSecond = parmSecond) { parmSecond = _parmSecond; return parmSecond; } [DataMemberAttribute('lines'), aifcollectiontypeattribute('_lines', types::class, classstr(JSONLineContract)), aifcollectiontypeattribute('return', types::class, classstr(JSONLineContract))] public List parmLines(List _lines = lines) { lines = _lines; return lines; } } --------------------------------- class ReadJson { public static void main(Args _args) { str json; List values = new List(Types::Class); ListEnumerator value; json = '[{"FieldValues": [{"parmFirst": "ValueFirst", "parmSecond": "ValueSecond", "Lines":[{"parmFirst": "ValueFirst", "parmSecond": "ValueSecond"}] }]}]'; values = FormJsonSerializer::deserializeCollection(classnum(List), json, Types::Class, classStr(JSONContract)); value = values.getEnumerator(); while(value.moveNext()) { JSONContract JSONContractCurrent = value.current(); info(strfmt('%1',JSONContractCurrent.parmFirst(), JSONContractCurrent.parmSecond())); info(strfmt('%1',JSONContractCurrent.parmLines())); } } }

Was this reply helpful? Yes No
Suggested answer

Sumit Loya 2,230 on at

Like (0)

Report

If I see it correctly, in Json the Node is named as "Lines" but your class data member attribute is "lines". JSON is case sensitive. try by changing the case on DataMemberAttribute for parmLines

Was this reply helpful? Yes No