+ Start a Discussion
CRMfusion - GWCRMfusion - GW 

Batch Query fail

As soon as I try to query data using the Bulk API (24.0) and use a relationship I get the following message:

 

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

 

According to the docs this is not a limitation of the Bulk API.  Is it possible to perform a query like: "SELECT Id, FIrstName, LastName, Account.Name FROM Contact"  or are we limited to a single table?

 

GlennW

Vivek ViswanathanVivek Viswanathan

Bulk API does not support relationships currently, you are currently limited to a single Table.

CRMfusion - GWCRMfusion - GW

It also does not yet support compresses responses.

 

When they get relationship queries and zipped responses in this will be very usefull.

 

 

Vivek ViswanathanVivek Viswanathan

Hi,

I would suggest posting an Idea on the Idea exchange for these useful features.

Regards

Vivek

lonedeveloperlonedeveloper

I have created an Idea for this on Ideaexchange please comment or promote if you think it will be useful. 

 

https://sites.secure.force.com/success/ideaView?id=08730000000h6C2AAI

Avijit GoraiAvijit Gorai
v39.0 API is currently supporting `Relationship fields`.

> https://developer.salesforce.com/docs/atlas.en-us.204.0.api_asynch.meta/api_asynch/asynch_api_using_bulk_query.htm

v39.0 API - Bulk API query doesn’t support the following SOQL:

 - COUNT
 - ROLLUP
 - SUM
 - GROUP BY CUBE
 - OFFSET
 - Nested SOQL queries

----
For v38.0 API:-
Bulk API query doesn’t support the following SOQL:
COUNT

 - ROLLUP
 - SUM
 - GROUP BY CUBE
 - OFFSET
 - Nested SOQL queries
 - Relationship fields