Finance | Project Operations, Human Resources, ...

How to DeSerialize Json file

(0) Share

Report

Posted on by TonyAx

570

Hi All,

I have JSON file, please find blow . I want to read and insert in d365fo

I follow below link to resolve but no luck, please give solution for this

community.dynamics.com/.../deserialize-json-build-from-an-array-of-values-in-d365fo

[
{
    "id": 1,
    "name": "Leanne Graham",
    "username": "Bret",
    "email": "Sincere@april.biz",
    "address": {
      "street": "Kulas Light",
      "suite": "Apt. 556",
      "city": "Gwenborough",
      "zipcode": "92998-3874",
      "geo": {
        "lat": "-37.3159",
        "lng": "81.1496"
      }
    },
    "phone": "1-770-736-8031 x56442",
    "website": "hildegard.org",
    "company": {
      "name": "Romaguera-Crona",
      "catchPhrase": "Multi-layered client-server neural-net",
      "bs": "harness real-time e-markets"
    }
},

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi Tony,

I haven't deserialized JSON to an array, but I deserialized it to contract.

First, you need to create a contract class for root information and for all nested nodes like address, geo, company contract should be created too in the same way.

[DataContract] class YourRootContractClass { private str id; ... private AddressContract address; //Create new contract for address fields ... private str phone; [DataMember("id")] public str parmId(str _id = id) { id = _id; return id; } .. [DataMember("address")] public AddressContract parmAddress(AddressContract _address = address) { address = _address; return address; } ... [DataMember("phone")] public str parmPhone(str _phone = phone) { phone = _phone; return phone; } }

And deserialize it

YourRootContractClass contract = FormJsonSerializer::deserializeObject(classId(YourRootContractClass), json_value);

Access variable from contract via parm methods

info(contract.parmId());

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Tony,

You can also have a look at the RetailCommonWebAPI class.

Map map = RetailCommonWebAPI::getMapFromJsonString(json);

str = map.lookup('KEY');

See the blog:

https://allaboutmsdynamics.wordpress.com/2018/12/18/d365-ax7read-parse-json-javascript-object-notation/

Hope this helps.

Was this reply helpful? Yes No
TonyAx 570 on at

Like (0)

Report

Hi Sergei,

Thanks for reply, your code is working but its task first record only.

please check below JSON data on that name are two .

{

"id": 1,
    "name": "Leanne Graham",
    "username": "Bret",
    "email": "Sincere@april.biz",
    "address":

}

{

"id": 2,
    "name": "Ervin Howell",
    "username": "Antonette",
    "email": "Shanna@melissa.tv"

}

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi Tony,

Try to create one more (root) contract to put customer contract to the list and use it in deserialize operation.

[DataContract] class CustomerListContract { List customerList = new List(Types::String); [ DataMemberAttribute("CustomerList"), DataCollectionAttribute(Types::Class, classStr(CustomerContract)) ] public List parmCustomerList(List _customerList = customerList) { if (!prmIsDefault(_customerList)) { customerList = _customerList; } return customerList; } }

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Hi Tony ,

Your requirement can be achieve using two contract classes. Take a look at examples from from below link might help you.

community.dynamics.com/.../serializing-and-deserializing-json-in-ax

Was this reply helpful? Yes No
Hassan najam 30 on at

Like (0)

Report
Hi

Its not working in my case.

I have JSON like this

{ "status": "OK", "message": "Good", "taxRefundResponse": { "taxRefundTagNumber": "T00001", } }

I created two contract class:

This is main contract

[DataContractAttribute] public class PGContract { str status,code; PGtaxRefundResponseContract taxRefundResponse; [DataMemberAttribute('status')] public str parmstatus(str _month = status) { status = _month; return status; } [DataMemberAttribute('code')] public str parmcode(str _month = code) { code = _month; return code; } [DataMember("taxRefundResponse"),DataCollectionAttribute(Types::class, classStr(PGtaxRefundResponseContract))] public PGtaxRefundResponseContract parmtaxRefundResponse(PGtaxRefundResponseContract _parmtaxRefundResponse = taxRefundResponse) { taxRefundResponse = _parmtaxRefundResponse; return taxRefundResponse; } }

For inner object

[DataContractAttribute] class PGtaxRefundResponseContract { str parmtaxRefundTagNumber; [DataMemberAttribute('taxRefundTagNumber')] public String50 parmtaxRefundTagNumber(String50 _parmtaxRefundTagNumber = parmtaxRefundTagNumber) { parmtaxRefundTagNumber = _parmtaxRefundTagNumber; return parmtaxRefundTagNumber; } }

When I debug it give me null value

Would you like share your opinion?

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

Like (0)

Report

First of all, fix the input, because it's not valid JSON. Even the editor here indicates an error. The bug is at line six; you shouldn't have the comma at the end.

Also, your PGContract doesn't have any member called 'message' (it's called 'code' instead).

Was this reply helpful? Yes No
Hassan najam 30 on at

Like (0)

Report
{ "status": "OK", "code": "Good", "taxRefundResponse": { "taxRefundTagNumber": "T00001" } }

Yes goshoom now correct the JSON.

Was this reply helpful? Yes No
Suggested answer

Hassan najam 30 on at

Like (0)

Report
Hi

After debug I found the solution how to get values of child JSON object.

YourContactClass yourContactClass = FormJsonSerializer::deserializeObjectStrict(classNum(YourContactClass), jsonString);

Thanks.

Was this reply helpful? Yes No