Extracting Files From Monday Updates

Hi @marcbarnes,

Great question. At this time, you’re able to retrieve a public_url by querying this field for the asset of your choosing. One thing to keep in mind, however, is that this public URL will only last for an hour. Here is the section of our API documentation that explains this: Files.

I see that Integromat has both an “Add a File to an Update” as well as an “Add a File to a File Column Value” module for monday.com. Perhaps you can utilize one of these to push your files into your other account.

What do you think? Could something like this work?

Thank you Helen. I did see those Integromat options, and had earmarked the  “Add a File to an Update” . What I am struggling with is the API query to retrieve a list of all of the assets that we have- so that I can plug that into the 'Add File' option.
It seems that you need to know the name of the asset to query it, but there is no variable that i can see in a 'search items on a board' Integromat Monday module to expose a variable for the underlying assets attached to an update. 

**So I guess my question is:** Can I use the Monday API, and a GraphQL query, to retrieve a list off all of the asset ids (for files) attached to a board (or all boards)?  If you or anyone could add that in a reply it would be an amazing start. Then i will try to use Integromat to move the files.  

Please see the query below- how do I filter the query to only include results where the item has a file asset? Thank you

query {
updates (limit: 2000) {
id
created_at
item_id
assets {
id
}
}
}

Hi marcbarnes

I’ve solved the problem with the file in integromat. You have to use the HTTP Module and the public URL, then you can get a file. Does this work for you? I’ve not tried it with updates only with the file column.

Hi @marcbarnes,

Great question. In this case, you can query only the updates in certain boards.

For instance, with a query like this:

I would only see the updates, and by association, the assets within that one board. You wouldn’t be able to not see the updates without files, but for those, the result will return empty.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.