Hi all! 👋 I’m trying to figure out how to find and download attachments associated with NetSuite purchase orders and/or vendor bills through NetSuite’s API. Here’s what I know/understand so far: • the NetSuite UI allows users to attach files to purchase orders / vendor bills • we can query for NetSuite vendorbills using this SuiteQL query:

SELECT * FROM transaction WHERE transaction.type = 'VendBill'

• we can query for files using this SuiteQL query:

SELECT File.* FROM File WHERE File.id = XXX

However, I can’t figure out how to get the File ids for attachments to a purchase order / vendor bill. Does anyone know how to do this? Thank you! Any help is greatly appreciated 🙏

Anthony's given a good answer to your related question on your other thread.

in terms of querying attachments, it seems transaction/record attachments are not queryable via suiteQL

Ah, I see. That’s disappointing but good to know. What do you mean by

N/search

? Is that a REST endpoint I can use to query for files by purchase order?

yes, the search module is used with suitescript only. I do not know of a way to get attachments via rest api