returning a JSON object

user_8408576 0
Viewed 510

is there any way to return a real JSON object through a function in ColdFusion? My current solution is to turn a query into a string and in another CF-file I'm converting it back to a JSON object:

<cffunction name="addLicense" access="remote" returntype="string" returnFormat="JSON" httpmethod="POST">
  <cfquery datasource="hostmanager" name="createCustomer">
    SELECT * FROM license
  </cfquery>
  <cfreturn serializeJSON(createCustomer)>
</cffunction>
coldfusion cfml rest json
4 Answers

There are many different ways to use serializeJSON

<cfscript>
    myQuery = queryNew("id,name,amount","Integer,Varchar,Integer", 
                [ 
                        {id=1,name="One",amount=15}, 
                        {id=2,name="Two",amount=18}, 
                        {id=3,name="Three",amount=32} 
                ]); 
    writeOutput("The new query is:")
    writeDump(myQuery)
</cfscript>

<cfoutput>
    <h4>Default</h4>
    <p><code>#serializeJSON(myQuery)#</code></p>
    <h4>Row</h4>
    <p><code>#serializeJSON(myQuery, "row")#</code></p>
     <h4>Column</h4>
    <p><code>#serializeJSON(myQuery, "column")#</code></p>
     <h4>Struct</h4>
    <p><code>#serializeJSON(myQuery, "struct")#</code></p>
</cfoutput>

Which Results in

enter image description here

See: https://cffiddle.org/app/file?filepath=58f7cee2-dabb-42f8-91ef-7dd41e1691c0/49ad94cb-23e4-4c9c-9986-b7c1d4c15e3a/c818a99e-4476-4625-8bec-657bcfa9b0e2.cfm

user_18458690

In ColdFusion2016 I use something like this.

deserializeJSON(serializeJSON(createCustomer, 'struct'))

This basically give you an array of structures(with query columns as struct keys).

user_14795350

Now I'm using this solution to return JSON:

returntype="any" produces="application/json"
user_84085760

You could use returnType="query" and the function will return the results in JSON format. You might need to use <cfcontent type="application/json"> to make sure the returned content type is correct.

user_9271690
Related