read out JSON node in Dynamics 365 Finance and Operations

(0) Share

Report

Posted on by Yash Doshi

{
    "message": "SUCCESS",
    "status": 10001,
    "data": {
        "hostapplicationlocaldata_id": 118942,
        "transactiontype_id": 518,
        "hostapplicationkeyvalues": [
            {
                "key": "Invoice Number",
                "value": "Inv_1001"
            },
            {
                "key": "Invoice Description",
                "value": "Inv_desc_1001"
            },
            {
                "key": "Invoice Account",
                "value": "1001"
            },
            {
                "key": "Invoice Date",
                "value": "2020-09-16"
            }
        ],
        "canbeassociated": false,
        "showadddocumentpromptonsave": null,
        "showsidebysideentryprompt": null
    },
    "end_point": null,
    "timestamp": "637365283511395216",
    "error": []
}

While I'm consuming URL of 3rd Party, got response in JSON Node, need to use KEY and Value node value.

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

vinitgoyal2005 6,332 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Check community.dynamics.com/.../621319

and ariste.info/.../

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can create a contract class and utilize FormJsonSerializer::deserializeCollection method to get the values, you can refer example here or you can use RetailCommonWebAPI class to get values in a map as you have key and value and then read values from map . You can use find references to look at the examples in standard code.

Stream responsestr = httpWwebresponse.GetResponseStream(); StreamReader reader = new System.IO.StreamReader(responsestr); map = RetailCommonWebAPI::getMapFromJsonString(reader.ReadToEnd());

Was this reply helpful? Yes No
Yash Doshi 25 on at

Like (0)

Report
Copy link

Link copied!

streamRead = new System.IO.StreamReader(dataStream);

returnValue = streamRead.ReadToEnd();

map = RetailCommonWebAPI::getMapFromJsonString(returnValue);

mapEnumerator = map.getEnumerator();

while(mapEnumerator.moveNext())

{

switch (mapEnumerator.currentKey())

{

case "data":

container1 = mapEnumerator.currentValue();

map1 = Map::create(container1);

hostApplicatioLocalDataId = map1.lookup('hostapplicationlocaldata_id');

//hostApplicationKeyValue = map1.lookup('hostapplicationkeyvalues');

//info(map2.lookup('hostapplicationlocaldata_id'));

}

}

As I used map, I got the value of hostapplicationlocaldata_id which is in under the node of "data", Now I want to get HostApplicationKeyValue node's value which is a array.

Was this reply helpful? Yes No