Hi folks...

I am trying to get a list of the file attachments associated with an account that I have created in Salesforce.com, but cannot figure out the details. (The attachments are simple text files that have been uploaded via the website and are fully accessible in the corresponding account via any browser.)

Using Java and the Web Services API, my code looks like this (listing the essential bits only):

SObject[] records = null;

try
{
	records = binding.query("SELECT Id, Name FROM Account").getRecords();
			
	if (records != null)
	{
		System.out.println("Found " + records.length + " records");
	}

	Account account = null;
	QueryResult attachments = null;
					
	for (int i = 0; i < records.length; i++)
	{
		account = (Account)records[i];
		System.out.println(account.getId() + ": " + account.getName());
				
		attachments = account.getAttachments();
				
		System.out.println("Attempt 1: attachments = " + attachments);

		attachments = account.getNotesAndAttachments();
				
		System.out.println("Attempt 2: attachments = " + attachments);
				
		attachments = binding.query("SELECT Id, Name FROM Attachment WHERE ParentId = '" + account.getId() + "'");
		System.out.println("Attempt 3: attachments = " + attachments);
	}				
}
catch (Exception e)
{
}

The first query does return several account objects, including the one that holds the attached files (all ending in .txt). However, no attachments are retrieved from any of these account objects.

As you can see, I try to get the attachments in 3 different ways, i.e. via calling the getAttachments(), getNotesAndAttachments() and query() methods. The first two always return null, whereas the last returns 0 records found.

Obviously I am missing something, so could anyone please enlighten me?

Thanks!