queryExecute

FileRead

array_key_exists

Has anyone used google.visualization.LineChart recently? 
I am looking to have a query result returned by a CFC, and I can't quite grasp how to pass the result ( as JSON? ) to the google API. 
I was hoping not to re-invent the wheel. 
What is causing me concern the most, is setting the data types of the columns. An example that better explains it then me ( although php) . The ajax call would call a method of a CFC.
<https://developers.google.com/chart/interactive/docs/php_example>

<cfhttp method="get" url="<https://example.com>" result="httpResponse">

<cfdump var="#httpResponse#">

Unknown host: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty

/siteRepository

regexp = "<img\s[^>]*?src\s*=\s*['\""](\/siteRepository\/[^'\""]*?)['\""][^>]*?>";
    fileRegexp = "\/userfiles\/(.+)";

    contentPagePosts.each(
        function(struct row, numeric rowNumber, query query) {
            <!--- Take the body of the post and replace the img src to point to S3 bucket location --->
            currentPostBody = row.body;
            currentSchoolId = row.schoolid;

            <!--- Find all image references in the post body --->
            <!--- images is an array that has length (len), match, and position (pos) --->
            images = reFindNoCase(regexp, currentPostBody, 1, true, "all");

            <!--- Loop through images arrays --->
            images.each(function(element, index) {
                if (element.match[1] NEQ "") {
                    fileName = "";

                    <!--- Retrieve the file name --->
                    element.match[2].each(function(e, i) {
                        findFileName = reFindNoCase(fileRegexp, e, 1, true, "all");
                        fileName = findFileName[1].match[2];

                        writeDump(e);
                        writeDump(fileName);
                    });

                    writeDump(element);
                }
            });

            <!--- Update the body value with the updated data --->

            //writeDump(images);

            //newPostBody = reReplaceNoCase(currentPostBody, regexp, "#s3LinkBase##currentSchoolId#/userfiles/", "ALL");
        },
        false,
        500
    );

<p style="text-align: center;"><img alt="" src="/siteRepository/203/userfiles/Hoodie.jpg" style="width: 100px; height: 133px;" /></p>

<p style="text-align: center;">Woodgrove Hoodie (Blue)<br />
$40<br />
S, M, XL</p>

<hr />
<p style="text-align: center;"><img alt="" src="/siteRepository/203/userfiles/hat.jpg" style="width: 100px; height: 133px;" /></p>

<p style="text-align: center;">Woodgrove Hats<br />
Adjustable (Blue)<br />
$20<br />
MD, XL</p>

<hr />
<p style="text-align: center;"><img alt="" src="/siteRepository/203/userfiles/greenhat.jpg" style="width: 100px; height: 133px;" /></p>

<p style="text-align: center;">Woodgrove Hats (Green)<br />
$20<br />
LG, XL</p>

<p>&nbsp;</p>