Scripted REST API
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
(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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Hi @Alon Grod ,
I would use the GlideSysAttachment instead attachment.write() inside your if loop.
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.