Using PowerShell to create an item in Monday.com?

Hello @Pearce and welcome to the community!

I hope you like it here 💪

What do you mean send emails? In which format do you want to send them and where do you want them to be in the board?

Thank you, I appreciate that!

We have a batch file that has PowerShell code in it. When that batch file runs, it takes the spreadsheet file in that folder, generates an email, attaches the spreadsheet to that email, then it sends the email.

I’m wanting to take out the email part and send it straight to a Monday board instead. Take the xlsx spreadsheet file in the host folder and create an item on a Monday board with that item attached along with a description

Hi Pearce, documentation of uploading files via the API is a bit scattered, but I was able to get get it to work a while back. Here are some links that should help you out.

https://api.developer.monday.com/docs/files-queries

A couple tips… When uploading files, you should use an alternate endpoint: https://api.monday.com/v2/file
Also remember that will need to create a multipart request. There are some tips in the links I posted for this.

Here is an example of a curl request:

curl --location --request POST 'https://api.monday.com/v2/file' \\
--header 'Authorization: yourSuperSecretApiKey' \\
--form 'query="mutation add_file($file: File!, $update_id: Int!) {add_file_to_update(update_id: $update_id, file: $file) {id}}"' \\
--form 'variables="{\\"update_id\\":920768626}"' \\
--form 'map="{\\"image\\":\\"variables.file\\"}"' \\
--form 'image=@"path to your file/in local memory/cool picture.jpg'

I don’t want to hijack this thread but does anyone have a working example in Powershell? I’ve run into a brick wall with uploading files. I posted the question yesterday.

Hi @mcdemon !

I will take a look into the question you posted recently 😁

Cheers,
Matias

I haven’t tried it yet, but came across this on github: