Parse Nested JSON

(0) Share

Report

Posted on by Charan_12

115

I need to parse the following JSON, i have been able to parse each object into a JSon Array, but i am having trouble parsing the TransactionItems into an array. TransactionItem are Sales Lines i need to loop through the TransactionItem and create a sales line for each object in there.

[
{
"Id": 314324236316890,
"CustomerId": null,
"StaffId": 10922343821,
"TransactionItems": [
{
"Id": 1051958756,
"TransactionId": 316334316890,
"ProductId": 1673432427092,
"UnitPrice": 1.2500000000000000,
"UnitPriceExcTax": 1.25000343400000000000,
"CostPrice": 34334
},
{
"Id": 1051958757,
"TransactionId": 343434340,
"ProductId": 167343427096,
"UnitPrice": 1.3503340000000000000,
"UnitPriceExcTax": 1.3500343000000000000,
"CostPrice": 0.0000000034300000000,
}
]
},

{
"Id": 314324236316890,
"CustomerId": null,
"StaffId": 10922343821,
"TransactionItems": [
{
"Id": 1051958756,
"TransactionId": 316334316890,
"ProductId": 1673432427092,
"UnitPrice": 1.2500000000000000,
"UnitPriceExcTax": 1.25000343400000000000,
"CostPrice": 34334
},
{
"Id": 1051958757,
"TransactionId": 343434340,
"ProductId": 167343427096,
"UnitPrice": 1.3503340000000000000,
"UnitPriceExcTax": 1.3500343000000000000,
"CostPrice": 0.0000000034300000000,
}
]
},

]

Any Ideas how i can do this?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

Hi,

You can try Newtonsoft Json parser to parse json objects in your code

Was this reply helpful? Yes No
Charan_12 115 on at

Like (0)

Report

what is Newtonsoft?

Was this reply helpful? Yes No
Dan Kinsella 468 on at

Like (1)

Report

Something like this?:

    procedure parseArray(jsonText: Text)

    var

        SalesOrderArray: JsonArray;

        SalesLineArray: JsonArray;

        SalesOrderToken: JsonToken;

        SalesOrderLineToken: JsonToken;

        JsonContents: JsonObject;

    begin

        JsonContents.ReadFrom(jsonText);

        SalesOrderArray := JsonContents.AsToken().AsArray();

        foreach SalesOrderToken in SalesOrderArray do begin

            SalesOrderToken.AsObject().Get('TransactionItems', SalesOrderLineToken);

            SalesLineArray := SalesOrderLineToken.AsArray();

        end;

    end;

Was this reply helpful? Yes No
Verified answer

Dan Kinsella 468 on at

Like (1)

Report

[quote user="Charan_12"]
what is Newtonsoft?
[/quote]
This is a .NET library we use to work with JSON in C/AL.

With AL we have inbuilt JSON types.

Was this reply helpful? Yes No
Charan_12 115 on at

Like (0)

Report

thanks it worked

Was this reply helpful? Yes No
Terrance Morgan 515 on at

Like (0)

Report

You're getting undefined because json.total[0] is itself, an array. You need to isolate the specific array inside json.total[0]. So you would need to do something like json.total[0][0].votes or json.total[0][1].votes.

I think a better structure for your JSON would be something like this:

{"total": [

{

"votes": "79,060"

"percent": "11%"

"winner": "0",

},

...

{

"votes": "156,787",

"percent": "21%",

"winner": "0"

}],

"useWinnerColors": 1,

"timestamp": "3:00 p.m. April 26",

"candidateCount": 5

}

Now you can do json.total[0].votes.

You don't need to create an array where each entry is a name-value pair. You can directly use an associative-array.

EDIT: To iterate over your associative array, use for..in along with hasOwnProperty(). The hasOwnProperty() check will prevent you from iterating over properties that it has inherited (some third-party libraries pollute the namespace):

var map = json.total[0];

for(var prop in map) if(map.hasOwnProperty(prop)) {

var value = map[prop];

...

}

Was this reply helpful? Yes No

Join the conversation

Community site session details

Parse Nested JSON

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Parse Nested JSON

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates