[SalesForce] SOQL query to load all documents in a content library

I am trying to query for all the documents in a library using the BULK API. The SOQL query I use is

SELECT ContentDocument.Id,ContentDocument.CreatedDate,ContentDocument.LastModifiedDate,ContentDocument.IsDeleted,ContentDocument.SystemModstamp,ContentDocument.Title,ContentWorkspace.Name 
FROM ContentWorkspaceDoc

This will give me all the information for the latest version of each document. When I execute this query via the BULK API I get an error –

'InvalidBatch : Failed to process query: FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query'

What should SOQL query (usable with the BULK API) be for fetching document from a content library?

Best Answer

It seems SOQL queries with relationships are not supported in Bulk API.

There is an idea posted here

Related Solutions

[SalesForce] How to retrieve compound fields like address using Bulk API

There is a clue in this help page on compound fields:

Compound fields can't be included in Bulk queries. Use the individual field components to access or update field values.

It turns out that you can use the component fields like so:

SELECT BillingStreet, BillingCity, 
       BillingState, BillingCountry, BillingPostalCode, 
       BillingLatitude, BillingLongitude
FROM Account

[SalesForce] Failed: InvalidBatch : Failed to process query: FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query

I think your best bet is just to define a field on the Sales_Quota__c Object called Product_Description__c, which would be a formula equal to product__r.description. Then use this in your query.

SELECT Product__c,Product_Description__c FROM Sales_Quota__c

Related Topic