I want to upload image file and .wav file to an item in a board

monday Apps & Developers
1

I am using below code to upload pic to an item row but gets blank response, no error
Please help

$filepath = “dec-logo201901.png”;

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, ‘https://api.monday.com/v2/file’);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
$post = array(
‘query’ => “mutation {
add_file_to_column (item_id: 6441733054, column_id: ‘files’, file: ‘$filepath’) {
id
}
}”,
‘variables’ => ‘"{"item_id": 6441733054, "column_id": "files"}"’,
‘map’ => ‘"{"image":"variables.file"}"’,
‘file’ => ‘@’ .realpath(“$filepath”)
);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post);

$headers = array();
$headers = ‘Api-Version: 2024-01’;
$headers = 'Authorization: '.$token;
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

echo $result = curl_exec($ch);
if (curl_errno($ch)) {
echo ‘Error:’ . curl_error($ch);
}
curl_close($ch);

2

Hello there @rajnish123saini and welcome to the community!

I hope you like it here :muscle:

I have this example that might help you with your script:

import fs from 'fs';
import fetch from 'node-fetch';

// set filename
var upfile = 'images.png';

// set auth token and query
var API_KEY = "APITOKEN"
var query = 'mutation ($file: File!) { add_file_to_column (file: $file, item_id: 1122334455, column_id: "files") { id } }';

// set URL and boundary
var url = "https://api.monday.com/v2/file";
var boundary = "xxxxxxxxxx";
var data = "";

fs.readFile(upfile, function(err, content){

    // simple catch error
    if(err){
        console.error(err);
    }

    // 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";

    // construct file part
    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" : "APITOKEN"
        },
        body: payload,
    };

    // make request
    fetch(url, options)
      .then(res => res.json())
      .then(json => console.log(json));
});
3

Whats does this parameter means

$file: File!

Is this $file a simple var name?
What does File! mean does it represent some dynamic value or just a label to use as it is?

Can you do above code in PHP?

4

Hello again @rajnish123saini,

I do not have much experience with PHP but using an automatic “translator” from JS to PHP, I got this (again, please double-check it because it was done automatically):

<?php
// set filename
$upfile = 'images.png';

// set auth token and query
$API_KEY = "APITOKEN";
$query = 'mutation ($file: File!) { add_file_to_column (file: $file, item_id: 1122334455, column_id: "files") { id } }';

// set URL and boundary
$url = "https://api.monday.com/v2/file";
$boundary = "xxxxxxxxxx";
$data = "";

$content = file_get_contents($upfile);

// simple catch error
if ($content === false) {
    echo "Error: " . error_get_last()["message"] . "\n";
    exit;
}

// 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";

// construct file part
$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";
$payload = implode("", array(
    $data,
    $content,
    "\r\n--" . $boundary . "--\r\n"
));

// construct request options
$options = array(
    'http' => array(
        'method' => 'POST',
        'header' => array(
            "Content-Type: multipart/form-data; boundary=" . $boundary,
            "Authorization: " . $API_KEY
        ),
        'content' => $payload
    )
);

$context = stream_context_create($options);
$response = file_get_contents($url, false, $context);

if ($response === false) {
    echo "Error: " . error_get_last()["message"] . "\n";
} else {
    $json = json_decode($response, true);
    print_r($json);
}

$files is the name of the variable. Check the part that says // construct file part

File! is the type of data for that variable.

I hope that helps!

Cheers,
Matias