The CreatorCon Call for Content is officially open! Get started here.

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

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}"