Home

Fetch file of of attachment thorough sdk

Please help me in fetching the file id of attachment through SDK.

Agile User Asked on April 27, 2018 in Other APIs,   Software Development Kit (API).
Add Comment
Cancel
2 Answer(s)

Hi Raju,

For a given part number, you can load the attachment table and iterate through the attached items. However that won’t give you file_id as far as i tried, it gives you filename

You can get file id for a given attachment using the below query.

Select fin.file_id “File ID”, fil.filename “File Name”,fil.file_type,fil.file_size,fin.ifs_filepath
from file_info fin, files fil
where fin.file_id=fil.id
and fil.filename= ‘YOUR INPUT FILE NAME’

Regards,
Arif

Cancel
Agile Angel Answered on April 27, 2018.

raju1

Hi Arif,

I want to fetch the attachment name,size,file path for a given item. can we get it using any query, please let me know.

Thanks

on April 27, 2018.
Cancel
Add Comment
Cancel

RE: Fetch file of of attachment thorough sdk

Cancel
Agile Expert Answered on June 2, 2018.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.