function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Prachi PotdarPrachi Potdar 

How to convert in json format with soql query

Commission_JSON__c": "{\n  \"totalCommission\" : 100,\n  \"isEditable\" : true,\n  \"CommissionWrapperList\" : [ {\n    \"isEditable\" : true,\n    \"employeeName\" : \"Salman Ahmad\",\n    \"employeeId\" : null,\n    \"employeeCommission\" : 100\n  } ]\n}"

How to convert in json format with soql query? 
Prateek Prasoon 25Prateek Prasoon 25
Hey, Prachi

If you meant how to convert json format into SOQL then

we use JSON.Serialize
and json.deserialize

Kindly mark it as the best answer if it helps. 
SwethaSwetha (Salesforce Developers) 
HI Prachi,
Your ask is not clear. Recommend reviewing below posts related to converting soql result to Json format 
https://developer.salesforce.com/forums/?id=9062I000000IMYOQA4
https://salesforce.stackexchange.com/questions/126212/how-to-convert-list-data-into-json-in-apex
https://salesforce.stackexchange.com/questions/21200/json-from-nested-query

Thank you