Skip to Main Content
Automated version numbers for your APEX apps Boxes

Bar Code Image in JSON document

How to put an APEX generated bar code Image in a JSON document

Example:

SELECT
    JSON_QUERY(
        JSON_OBJECT(
            KEY 'images' VALUE
            JSON_OBJECT(
                    KEY 'image1' VALUE
                        JSON_OBJECT(
                            KEY 'source' VALUE 'URL',
                                    KEY 'url' VALUE 'data:image/png;base64,'
                                                    || apex_web_service.blob2clobbase64(p_blob => apex_barcode.get_code128_png(
                                p_value            => '0123456789',
                                p_scale            => 5,
                                p_foreground_color => '#000000',
                                p_background_color => NULL
                            ))
                        )
                ) RETURNING CLOB
            FORMAT JSON
        ) ,
               '$' RETURNING CLOB pretty) AS json_output_clob
FROM
    dual;

Output:

{
  "images" :
  {
    "image1" :
    {
      "source" : "URL",
      "url" : "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAiYAAADhCAMAAADLYo5RAAAABlBMVEUAAAD"
    }
  }
}