How to find out matching attachment Id and filename?

[Albert Cameron]

Jira stores all attachments not with the filename in the attachment but as an ID.

Now I have to find out which ID belongs to a specific filename. 

The only way to do this in my opinion is to query the database .

I do not know which table I have to query. Maybe attachment .

There I should find the matching of Id and filename.

Has anyone done this before ? 

[Nic Brough -Adaptavist- · Accepted solution]

You either need to read the database or code for asking the API for the id of any given attachment.

I'd question why you think you need this though - the attachment ID doesn't tell you anything you would need to know that you can't get by reading the issue the attachment is attached to (and you'll get the name of the file if you go via the issue)

[Albert Cameron]

Thanks. It is indeed possible to get the Id of the attachment . I did not know it matches the filename.

Querying the database would have cost me some hours :)