Microsoft Dynamics AX (Archived)

calling json service and de-serializing data

(0) Share

Report

Posted on by krishna.rao@dax

3,006

Hi all,

I'm trying to call json service and update data in AX. I am trying couple of blogs.

I see the data in rawresponse but getting error 'Object 'CLRObject' could not be created" in RetailCommonWebAPI::getMapFromJsonString(rawResponse);

Find the below image for detail.

can someone help me here how we could fix this error and get the data in appropriate format (might has to de-serializing) so we could insert in AX.

Appreciate your guidance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Jie G on at

Like (0)

Report

Hello Krishna,

Your code looks well. Object 'CLRObject' could not be created" is a generic message, which means an exception was thrown when constructing a .NET object. You should check the detailed exception message including inner exception. BTW, if you have "Enable the hot-swapping of assemblies for each development session" enabled on the AX server configuration, please try to disable it.

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

As per me, seems issue is in de-serializing, since we are assigning record have multiple values to 'map' object, as you see in main post.//hot swapping is in off.

//data = RetailCommonWebAPI::getMapFromJsonString(rawResponse);

----> Raw response

NAME:

rawResponse

VALUE:

[

{"

"id": 31,

"tableName": "LogisticsElectronicAddress",

".............

"modifiedDate": "2019-04-05T11:46:43.763"

}

]

would be great someone could help in de-serializing the json value so we could get the records

Was this reply helpful? Yes No
Pradeep_Prakash 717 on at

Like (0)

Report

Hi Krishna,

You can try the below using a .net api.

community.dynamics.com/.../296315

Regards,

Pradeep

Was this reply helpful? Yes No
Pradeep_Prakash 717 on at

Like (0)

Report

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Runtime.Serialization.Json;

using System.Runtime.Serialization;

namespace Integration.JsonAdapter

{

public class Convert

{

// Deserialize a JSON stream to a User object.

public static Person ReadToObject(string json)

{

Person deserializedUser = new Person();

MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(json));

DataContractJsonSerializer ser = new DataContractJsonSerializer(deserializedUser.GetType());

deserializedUser = ser.ReadObject(ms) as Person;

ms.Close();

return deserializedUser;

}

}

[DataContract]

public class Person

{

[DataMember]

internal string name;

[DataMember]

internal int age;

}

}

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Krishna, your input string is invalid. It's not valid JSON string at all, because the additional quotation marks between after {. Also, it's a JSON array, while the purpose of the method is deserializing a JSON object (not an array) to a map (mapping property names to their values).

This would be a valid input:

str rawResponse = @'{ "id": 31, "tableName": "LogisticsElectronicAddress", "modifiedDate": "2019-04-05T11:46:43.763" }';

Was this reply helpful? Yes No

Community site session details

calling json service and de-serializing data

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

calling json service and de-serializing data

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