Sending attachments using custom scripted web service

[Thej1]

HI,

Created  a Scripted REST API and resources for the creation, updation, deletion and adding attachment for an incdent.

Tried with sending request from postman and working fine for Incident creation, updation and deletion.

But when i tried to add an attachment getting the response in postman as “request cannot sent” via postman or as “Invalid content type”.

Tried attachment with the OOB table API and it is working as expected.

Could someone help how to send request of adding attachment from postman ?

@Dr Atul G- LNG @Ankur Bawiskar 

Thanks

[Ankur Bawiskar · Accepted solution]

@Thej1 

it worked. you were not using the correct script which I shared above for SOAP Attachment creator.

I updated your scripted rest API script.

Also it seems you were not sending the complete base64 data

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Thej1 

you are not sending the request body in json format

if your requirement is to attach file via scripted rest api then check this link where I shared solution and enhance it based on your requirement

Scripted Rest API to update incident with attachment 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Thej1]

Hi @Ankur Bawiskar ,

This is the json request sent and modified script in scripted rest api. showing as file uploaded to incident and cannot open it. 

Sample JSON request:

{

  "incidentNumber": "INC0010002",

  "fileName": "myfile.jpeg",

  "contentType": "image/png",

  "fileData": "iVBORw0KGgoAAAANSUhEUgAABA8AAAJJCAYAAADFkR6QAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAAP+lSURBVHhe7L0HoCxLVa..."

}

script:

(function process(request, response) {

    // Get the body of the request and decode the JSON

    var requestBody = request.body.dataString; // Get raw request body

    var parser = new global.JSON();

    var parsedData = parser.decode(requestBody); // Parse the JSON

    var number = parsedData.incidentNumber; // Incident number

    var fileName = parsedData.fileName; // Name of the file to be uploaded

    var fileContentType = parsedData.contentType; // File content type (e.g., image/png, application/pdf)

    var fileData = parsedData.fileData; // Base64-encoded file content

    // Fetch the incident record using GlideRecord

    var rec = new GlideRecord('incident');

    rec.addQuery('number', number);

    rec.query();

    if (rec.next()) {

        // Incident found, proceed to attach the file

        // Decode the Base64 file data to binary

        var decodedData = GlideStringUtil.base64Decode(fileData); // Decode from Base64

        // Create a GlideSysAttachment object to handle the attachment

        var sa = new GlideSysAttachment();

        sa.write(rec, fileName, fileContentType, decodedData); // Attach the file to the incident

        // Respond with a success message

        var responseBody = {

            incNumber: number,

            status: "Success",

            message: "File uploaded successfully."

        };

        response.setBody(responseBody);

    } else {

        // Incident not found, respond with failure

        var responseBodyFailure = {

            status: "Failure",

            message: "Incident not found."

        };

        response.setBody(responseBodyFailure);

    }

})(request, response);

Incident screenshot:

Thanks

[Ankur Bawiskar]

@Thej1 

update as this

For global scope write() method works only for plain text

(function process(request, response) {
    // Get the body of the request and decode the JSON
    var requestBody = request.body.dataString; // Get raw request body
    var parser = new global.JSON();
    var parsedData = parser.decode(requestBody); // Parse the JSON

    var number = parsedData.incidentNumber; // Incident number
    var fileName = parsedData.fileName; // Name of the file to be uploaded
    var fileContentType = parsedData.contentType; // File content type (e.g., image/png, application/pdf)
    var fileData = parsedData.fileData; // Base64-encoded file content

    // Fetch the incident record using GlideRecord
    var rec = new GlideRecord('incident');
    rec.addQuery('number', number);
    rec.query();

    if (rec.next()) {
        // Incident found, proceed to attach the file
        // Decode the Base64 file data to binary
        var decodedData = GlideStringUtil.base64Decode(fileData); // Decode from Base64

        // Create a GlideSysAttachment object to handle the attachment

        var eccGr = new GlideRecord('ecc_queue');
        eccGr.initialize();
        eccGr.setValue('agent', 'AttachmentCreator');
        eccGr.setValue('topic', 'AttachmentCreator');
        eccGr.setValue('name', fileName + ':' + fileContentType);
        eccGr.setValue('source', 'incident' + ':' + rec.sys_id);
        eccGr.setValue('payload', fileData);
        eccGr.insert();

        // Respond with a success message
        var responseBody = {
            incNumber: number,
            status: "Success",
            message: "File uploaded successfully."
        };
        response.setBody(responseBody);
    } else {
        // Incident not found, respond with failure
        var responseBodyFailure = {
            status: "Failure",
            message: "Incident not found."
        };
        response.setBody(responseBodyFailure);
    }
})(request, response);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Thej1]

Hi @Ankur Bawiskar ,

Still getting the same result.

Thanks

[Ankur Bawiskar]

@Thej1 

are you sending the correct base64 data for that image and the correct file name, content type?