Scripted REST API

Alon Grod
Tera Expert
(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

    var answer = [];
    var table_name = 'cmdb_model';
    var attachment = new Attachment();

    try {
        var result = JSON.parse(request.body.dataString);

        for (var i in result.attachments) {

            var ids    = result.attachments[i].id;
            var base64 = result.attachments[i].base64;

            if (!base64) continue;

            var fileBytes = GlideStringUtil.base64DecodeAsBytes(base64);

            for (var j = 0; j < ids.length; j++) {
                var id        = ids[j].elcam_part_no;
                var file_name = ids[j].file_name;

                if (!id || !file_name) continue;

                var gr = new GlideRecord('cmdb_model');
                gr.addQuery('u_elcam_part_no', id);
                gr.query();

                if (gr.next()) {

                    // getUniqueValue() returns a plain string — gr.sys_id is a GlideElement
                    // and must NOT be passed directly to attachment.write() or addQuery.
                    var targetSysId = gr.getUniqueValue();

                    var bb = new GlideRecord('sys_attachment');
                    bb.addQuery('table_name',   table_name);
                    bb.addQuery('table_sys_id', targetSysId);
                    bb.addQuery('content_type', 'application/pdf');
                    bb.query();

                    var wasUpdated = bb.hasNext();
                    bb.deleteMultiple();

                    attachment.write(table_name, targetSysId, file_name, 'application/pdf', fileBytes);

                    answer.push("Attachment was " + (wasUpdated ? "updated" : "created") + " " + file_name + ' id:' + gr.u_elcam_part_no);
                    answer.push({ "id": id, "file_name": file_name, "state": "true" });

                } else {
                    answer.push("Attachment was not created " + file_name + ' id:' + id);
                    answer.push({ "id": id, "file_name": file_name, "state": "false" });
                }
            }
        }

        response.setStatus(201);

    } catch (error) {
        var serviceError = new sn_ws_err.ServiceError();
        serviceError.setStatus(500);
        serviceError.setMessage('Service error');
        serviceError.setDetail('The server could not process the request.');
        response.setError(serviceError);
    }

    response.setBody(answer);

})(request, response);

 

Hi, this is my script, for some reason all attachment are being written to the same record. Any idea what can cause that?

1 REPLY 1

Hemanth M
Tera Sage

Hi @Alon Grod ,

 

I would use the GlideSysAttachment instead attachment.write() inside your if loop.

HemanthM_1-1795084549941.png

 

Something like this :

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

    var answer = [];
    var table_name = 'cmdb_model';
   // var attachment = new Attachment();

    try {
        var result = JSON.parse(request.body.dataString);

        for (var i in result.attachments) {

            var ids    = result.attachments[i].id;
            var base64 = result.attachments[i].base64;

            if (!base64) continue;

            var fileBytes = GlideStringUtil.base64DecodeAsBytes(base64);

            for (var j = 0; j < ids.length; j++) {
                var id        = ids[j].elcam_part_no;
                var file_name = ids[j].file_name;

                if (!id || !file_name) continue;

                var gr = new GlideRecord('cmdb_model');
                gr.addQuery('u_elcam_part_no', id);
                gr.query();

                if (gr.next()) {

                    // getUniqueValue() returns a plain string — gr.sys_id is a GlideElement
                    // and must NOT be passed directly to attachment.write() or addQuery.
                    var targetSysId = gr.getUniqueValue();

                    var bb = new GlideRecord('sys_attachment');
                    bb.addQuery('table_name',   table_name);
                    bb.addQuery('table_sys_id', targetSysId);
                    bb.addQuery('content_type', 'application/pdf');
                    bb.query();

                    var wasUpdated = bb.hasNext();
                    bb.deleteMultiple();
// Logic Added here //
var gsa = new GlideSysAttachment();
gsa.writeBase64(gr, file_name, 'application/pdf', base64);// writeBase64 takes the GlideRecord object directly, not table_name and sys_id

                    //attachment.write(table_name, targetSysId, file_name, 'application/pdf', fileBytes);

                    answer.push("Attachment was " + (wasUpdated ? "updated" : "created") + " " + file_name + ' id:' + gr.u_elcam_part_no);
                    answer.push({ "id": id, "file_name": file_name, "state": "true" });

                } else {
                    answer.push("Attachment was not created " + file_name + ' id:' + id);
                    answer.push({ "id": id, "file_name": file_name, "state": "false" });
                }
            }
        }

        response.setStatus(201);

    } catch (error) {
        var serviceError = new sn_ws_err.ServiceError();
        serviceError.setStatus(500);
        serviceError.setMessage('Service error');
        serviceError.setDetail('The server could not process the request.');
        response.setError(serviceError);
    }

    response.setBody(answer);

})(request, response);

 

Let us know if any issues!

 

 

Thank you,
Hemanth
CTA, ServiceNow MVP.