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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / DAXology (Study about Dynamics AX and Dynamics ... / Serialize Json with data fr...

Serialize Json with data from a table in D365FO

Views (1156)
Chaitanya Golla Profile Picture Chaitanya Golla 17,225

Hi,

In this post, we will see how to serialize the data to Json from a table in D365FO. If we have all the required data in a single table then this approach can be used.

class CG_SerializeJsonFromTable
{       
    /// <summary>
    /// Runs the class with the specified arguments.
    /// </summary>
    /// <param name = "_args">The specified arguments.</param>
    public static void main(Args _args)
    {      
        CustTable custTable;
        JsonSerializerSettings settings = null;
        str json;
 
        select firstonly custTable
            where custTable.AccountNum == "1000";
 
        JsonTableSerializer jsonTable = new JsonTableSerializer(settings);
 
        json = jsonTable.serialize(custTable);
 
        Info(strFmt("%1", json));
    }
 
}

Output: https://drive.google.com/open?id=1pptktN6Js7BEpoPOePzLKF7bq9v5XuAN

Regards,

Chaitanya Golla

Comments

*This post is locked for comments