web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error in Parsing the J...
Finance | Project Operations, Human Resources, ...
Answered

Error in Parsing the JSON in Batch Job

(1) ShareShare
ReportReport
Posted on by Raj Borad 1,531
Hi Users,
I am trying to parse the JSON using Below link:
 
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)
  • Raj Borad Profile Picture
    Raj Borad 1,531 on at
    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;
        }
    }
  • Martin Dráb Profile Picture
    Martin Dráb 238,848 Most Valuable Professional on at
    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).
  • Raj Borad Profile Picture
    Raj Borad 1,531 on at 
    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...
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 238,848 Most Valuable Professional on at
    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.
     
     
  • Raj Borad Profile Picture
    Raj Borad 1,531 on at
    Martin,
    Thank you for your quick response.
     
    Regards,
    Raj Borad
  • Martin Dráb Profile Picture
    Martin Dráb 238,848 Most Valuable Professional on at
    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.
  • Raj Borad Profile Picture
    Raj Borad 1,531 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 470

#3
Adis Profile Picture

Adis 270 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans