Need Help with Monday.com SDK File Upload

monday Apps & Developers
, ,
1

Hi everyone, I’ve hit a snag while trying to upload a file to a column using the Monday SDK. Below is the snippet I’m working with:

import initMondayClient from 'monday-sdk-js';
import { Logger } from '@mondaycom/apps-sdk';
import path from 'path';
import fs from 'fs';
import FormData from 'form-data';

export async function changeColumnValue(token, itemId, columnId) {
  const formData = new FormData();
  const filePath = path.join(__dirname, 'test.txt');
  formData.append('variables[file]', fs.createReadStream(filePath), 'test.txt');
  formData.append(
    'query',
    `mutation ($file: File!) {
      add_file_to_column (item_id: ${itemId}, column_id: "${columnId}", file: $file) {
        id
      }
    }`,
  );

  try {
    const response = await fetch('https://api.monday.com/v2/file', {
      method: 'POST',
      headers: {
        Authorization: token,
        ...formData.getHeaders(),
      },
      body: formData,
    });

    const data = await response.json();
    console.log(data);
  } catch (error) {
    console.error(error);
    throw new Error(error.message);
  }
}

When I run this, I encounter the following error:
{ “error_message”: “Unsupported query”, “status_code”: 400 }

I’m using Node v18.0.0 and have taken this code as a base from the quickstart-integrations-monday documentation, with minor adjustments to test some functionalities. The goal here is to craft a function that receives itemId, columnId, and a token, and uploads a file located on my server to the specified column/item.

Would appreciate any insights or suggestions on what I might be doing wrong or missing. Thanks in advance!

1 Like
2

Hello there @ethanolle1,

I replied in the ticket you opened :grin:

Cheers,
Matias

3

For anyone interested, here is a working function thanks to @Matias.Monday help.

export async function changeColumnValue(token, boardId, itemId, columnId) {
  // make string item id and column id
  itemId = JSON.stringify(itemId);
  // columnId = JSON.stringify(columnId);
  // set filename current path images.png
  var upfile = path.join(__dirname, 'images.png');
  // set query
  var query = `mutation ($file: File!) { add_file_to_column (file: $file, item_id: "${itemId}", column_id: "${columnId}") { id } }`;
  // set URL and boundary
  var url = 'https://api.monday.com/v2/file';
  var boundary = 'xxxxxxxxxx';

  try {
    const content = await fs.promises.readFile(upfile);
    var data = '';

    // construct query part
    data += '--' + boundary + '\r\n';
    data += 'Content-Disposition: form-data; name="query"; \r\n';
    data += 'Content-Type:application/json\r\n\r\n';
    data += '\r\n' + query + '\r\n';
    data += '--' + boundary + '\r\n';
    data += 'Content-Disposition: form-data; name="variables[file]"; filename="' + upfile + '"\r\n';
    data += 'Content-Type:application/octet-stream\r\n\r\n';
    var payload = Buffer.concat([Buffer.from(data, 'utf8'), new Buffer.from(content, 'binary'), Buffer.from('\r\n--' + boundary + '--\r\n', 'utf8')]);

    // construct request options
    var options = {
      method: 'post',
      headers: {
        'Content-Type': 'multipart/form-data; boundary=' + boundary,
        Authorization: token,
      },
      body: payload,
    };

    // make request
    const response = await fetch(url, options);
    const json = await response.json();
    console.log(json);
  } catch (err) {
    console.error(err);
  }
}
1 Like
4

Happy to help @ethanolle1 !!!