Coldfusion parsing cfhttp.filecontent into list

Question

I am trying to parse through a cfhttp.filecontent that is returned and evaluate each variable.

Here is an example of what is being returned:

{"multicast_id":6110507831830919692,
 "success":0,
 "failure":1,
 "canonical_ids":0,
 "results":[{"error":"NotRegistered"}]}

So I would like to set to a list and loop through it so I can get the following:

multicast_id VARCHAR
success BIT
failure BIT
canonical_ids BIT
results VARCHAR

Any ideas would be great!!!

Thanks!

Answer 1

You need to have a proper CF object. cfhttp.filecontent is a just a string.

<cfscript>
data = DeserializeJSON(cfhttp.filecontent);


 writedump(data); // now you should have a proper cf variable.
</cfscript>