how to send attachment from servicenow to Monday.com?

Tushar Jain3
Tera Contributor

Using below code but not working.

 

var   gr = new GlideRecord('sys_attachment');
gr.addQuery('sys_id', 'xxxxxxxxxxxxxxxxx');
gr.query();
if (gr.next()){
var StringUtil = new GlideStringUtil();
var sa = new   GlideSysAttachment();
var binData =   sa.getBytes(gr);
var encData =   StringUtil.base64Encode(binData);
gs.log("encData" +encData);
  gs.log("binData" +binData);
}
    try {
        var r = new sn_ws.RESTMessageV2('Monday_servicenow', 'POSTM');

 

        var myobj1 = {
"query": "mutation {add_file_to_column (item_id: xxxxxxxx, column_id: \"files\", file: "+ encData +") {id}}"

        }
    r.setStringParameter("file",encData);
        r.setRequestBodyFromAttachment(encData);
    gs.log("query=" +current.variables.Attachment);
    gs.log("myobj1=" +myobj1);
        r.setRequestBody(JSON.stringify(myobj1));
        var response = r.execute();
    gs.log("response==" +response);
        var responseBody = response.getBody();
        var httpStatus = response.getStatusCode();
    } catch (ex) {
        var message = ex.message;
    }

2 REPLIES 2

Sohail Khilji
Kilo Patron
Kilo Patron

Whats the response error ?

 

This will help : 

youtube.com/watch?v=ptPlW4tQXEw

https://www.servicenow.com/community/developer-forum/how-to-send-attachment-from-one-instance-to-oth...

 

 


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

When using Content-Type as "multipart/form-data" (which monday.com has recommended for sending files) getting below error

 

responseBody=="{\"errors\":[{\"message\":\"No query string was present\"}],\"account_id\":xxxxxx}"