JSON String to Axapta MAP

(0) Share

Report

Posted on by Community Member

I have the below JSON string, which I am converting to a map and then reading the values based on the keys

str json = '{"PortalId" : "POR146", 
             "MemberId" : "MEM132", 
             "ParmContainer": [{"Key1":"First",
                                "Key2":"Second"},
                               {"Key1":"Third",
                                "Key2":"Fourth"}]}';

I am able to read the keys and values using the RetailCommonWebAPI::getMapFromJSONString.

The problem that I have is reading the values inside the parmContainer key. From the documentation that I found, the keys are stored as strings, and values are stored as containers. When I look inside the container, I get integer values instead of "First", "Second", "Third" and "Fourth".

while ( mapEnumerator.moveNext())
        {
            switch (mapEnumerator.currentKey().ToString())
            {
                case "ParmContainer"     :
                container test = mapEnumerator.currentValue();
                info(conPeek(test,1));
                info(conPeek(test,2));
                info(conPeek(test,3));
                info(conPeek(test,4));
            }
        }

Any ideas on how to solve this issue please?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report

I would rather use classes. For example, you can create a C# class library, then generate classes by Edit > Paste Special > Paste JSON as Classes, use Newtonsoft.Json to parse the JSON string to these classes and use them in X++.

Welcome to the world of .NET, full of options. :-)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
static void Job24(Args _args) { str json = '{"PortalId" : "POR146", "MemberId" : "MEM132", "ParmContainer": [{"Key1":"First", "Key2":"Second"}, {"Key1":"Third","Key2":"Fourth"}]}'; Map map; Map map1; List testList; ListEnumerator listEnumerator; container test; mapEnumerator mapEnumerator; map = RetailCommonWebAPI::getMapFromJsonString(json); mapEnumerator = map.getEnumerator(); while ( mapEnumerator.moveNext()) { switch (mapEnumerator.currentKey()) { case "ParmContainer" : test = mapEnumerator.currentValue(); testList =List::create(test); listEnumerator = testList.getEnumerator(); while (listEnumerator.moveNext()) { test = listEnumerator.current(); map1 = Map::create(test); info(map1.lookup('Key1')); info(map1.lookup('Key2')); } } } }

?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Brilliant thanks, exactly what i needed!

Was this reply helpful? Yes No

Community site session details

JSON String to Axapta MAP

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

JSON String to Axapta MAP

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 > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates