Finance | Project Operations, Human Resources, ...

Answered

Error in Parsing the JSON in Batch Job

(1) Share

Report

Posted on by Raj Borad

1,424

Hi Users,

I am trying to parse the JSON using Below link:

axgrind.azurewebsites.net/.../AX-2009-and-JSON-Parsing

I copied the Newtonsoft.Json.dll into client and server bin folder, also added reference in AOT.

Parsing of JSON works fine in simple job running, but not working in Batch Job.

Getting below error:

on the line number 50 in the code below.

private anytype traversePath(str                               path,                             Newtonsoft.Json.Linq.JContainer   obj = jObject){    List                            pathElements;    ListEnumerator                  le;    Newtonsoft.Json.Linq.JValue     value;    Newtonsoft.Json.Linq.JToken     token;    Newtonsoft.Json.Linq.JTokenType thisType,                                    nestedType;    Newtonsoft.Json.Linq.JObject    newObject;    Newtonsoft.Json.Linq.JArray     newArray;    str                             current,                                    thisTypeString,                                    nestedTypeString;     #define.JObject(/Newtonsoft.Json.Linq.JObject/)    #define.JArray (/Newtonsoft.Json.Linq.JArray/)     ;     pathElements = strSplit(path, @/.////);     le = pathElements.getEnumerator();     if (le.moveNext())    {        current = le.current();         thisType = obj.GetType();        thisTypeString = thisType.ToString();         switch (thisTypeString)        {            case #JObject:                token = obj.get_Item(current);                break;            case #JArray:                token = obj.get_Item(str2int(current) - 1);                break;            default:                return null;        }         if (token)        {            nestedType = token.GetType();            nestedTypeString = nestedType.ToString();             if (nestedTypeString != #JObject && nestedTypeString != #JArray)            {                switch (thisTypeString)                {                    case #JArray:                        return obj.get_Item(str2int(current) - 1);                    case #JObject:                        return obj.get_Item(current);                    default:                        return null;                }            }                         switch (nestedTypeString)            {                case #JObject:                    newObject = Newtonsoft.Json.Linq.JObject::FromObject(token);                    return this.traversePath(strDel(path, 1, strLen(current) + 1), newObject);                case #JArray:                    newArray = Newtonsoft.Json.Linq.JArray::FromObject(token);                    return this.traversePath(strDel(path, 1, strLen(current) + 1), newArray);                default:                    return null;            }        }        else        {            return null;        }    }    else    {        return null;    }}

If you know anything about the issue, Plese reply.

Thank you,

Raj Borad

I have the same question (0)

All responses (7)

Answers (1)

Raj Borad 1,424 on at

Like (0)

Report

HI here is the code.

private anytype traversePath(str path,
Newtonsoft.Json.Linq.JContainer obj = jObject)
{
List pathElements;
ListEnumerator le;
Newtonsoft.Json.Linq.JValue value;
Newtonsoft.Json.Linq.JToken token;
Newtonsoft.Json.Linq.JTokenType thisType,
nestedType;
Newtonsoft.Json.Linq.JObject newObject;
Newtonsoft.Json.Linq.JArray newArray;
str current,
thisTypeString,
nestedTypeString;

#define.JObject("Newtonsoft.Json.Linq.JObject")
#define.JArray ("Newtonsoft.Json.Linq.JArray")

;

pathElements = strSplit(path, @".\/");

le = pathElements.getEnumerator();

if (le.moveNext())
{
current = le.current();

thisType = obj.GetType();
thisTypeString = thisType.ToString();

switch (thisTypeString)
{
case #JObject:
token = obj.get_Item(current);
break;
case #JArray:
token = obj.get_Item(str2int(current) - 1);
break;
default:
return null;
}

if (token)
{
nestedType = token.GetType();
nestedTypeString = nestedType.ToString();

if (nestedTypeString != #JObject && nestedTypeString != #JArray)
{
switch (thisTypeString)
{
case #JArray:
return obj.get_Item(str2int(current) - 1);
case #JObject:
return obj.get_Item(current);
default:
return null;
}
}

switch (nestedTypeString)
{
case #JObject:
newObject = Newtonsoft.Json.Linq.JObject::FromObject(token);
return this.traversePath(strDel(path, 1, strLen(current) + 1), newObject);
case #JArray:
newArray = Newtonsoft.Json.Linq.JArray::FromObject(token);
return this.traversePath(strDel(path, 1, strLen(current) + 1), newArray);
default:
return null;
}
}
else
{
return null;
}
}
else
{
return null;
}
}

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

Like (0)

Report

What type of object do you have in your obj variable?

Is it about AX 2009 or another version?

How did you determine that the highlighted line is to blame? It sounds strange to me that obj.GetType() would call Convert.ChangeType() (but I can't rule it out).

Was this reply helpful? Yes No
Raj Borad 1,424 on at

Like (0)

Report
Hi Martin,

I am using AX 2012.

And for obj variable:

jObject = Newtonsoft.Json.Linq.JObject::Parse(_json); // _json is a string.

and stored it in obj = jObject;

While debugging the code, I get the error in that line so...

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

OK, I see. GetType() returns System.Type, but you're trying to assign it to a variable of type Newtonsoft.Json.Linq.JTokenType, which isn't possible. I think you mean Type property, which you can access by get_Type() method. GetType() has a similar name, but it's something completely different. It's a method inherited from System.Object that gives you an instance of System.Type describing the type of the object in the variable.

Was this reply helpful? Yes No
Raj Borad 1,424 on at

Like (0)

Report

Martin,
Thank you for your quick response.

Regards,

Raj Borad

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

Like (1)

Report

Did it solve your problem? If so, please mark the helpful reply (or replies) as the answer (by Does this answer your question?). If it doesn't work for you (there is a known problem with the site), I (as a moderator) can try it on your behalf.

Was this reply helpful? Yes No
Raj Borad 1,424 on at

Like (0)

Report

Hi Martin,

I tried since yesterday to tick the Does this answer your question?

but it is not ticked, and page is gone in reload.

Please try to mark your reply as a verified answer, if you can...

Thank you,

Raj Borad

Was this reply helpful? Yes No

Join the conversation

Community site session details

Error in Parsing the JSON in Batch Job

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Error in Parsing the JSON in Batch Job

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 > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates