2

I am getting below error on running bulk query.Is there any way i can get result in bulk query.

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

I have used below bulk query in workbench.

SELECT Product__c,product__r.description FROM Sales_Quota__c
2
  • 1
    I don't think this question has anything to do with translations? Simple search to find the answer here, for example success.salesforce.com/answers?id=90630000000h8WkAAI
    – Adrian Larson
    Oct 4, 2016 at 19:43
  • @adrian-I wanted for bulk query. That foreign and parent relationship is already enabled in workbench.It is just not working with bulk query.
    – Jack vardy
    Oct 4, 2016 at 19:57

2 Answers 2

1

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
1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .