how to send attachment from servicenow to Monday.com?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 02:37 AM
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;
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 02:50 AM - edited 01-11-2024 02:53 AM
Whats the response error ?
This will help :
youtube.com/watch?v=ptPlW4tQXEw
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 03:33 AM
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}"