You need to sign in to do that
Don't have an account?
CRMfusion - 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
Bulk API does not support relationships currently, you are currently limited to a single Table.
It also does not yet support compresses responses.
When they get relationship queries and zipped responses in this will be very usefull.
Hi,
I would suggest posting an Idea on the Idea exchange for these useful features.
Regards
Vivek
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
> 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