+ Start a Discussion
Abhishek Pal 33Abhishek Pal 33 

How to export bulk data using dataloader/workbench?

I am using relationships in soql and have about 10k records. Does anyone knows how to export because I am getting an error as "Bulk API is not supported in salesforce.

Error:---> "FUNCTIONALITY_NOT_ENABLED: Foreign Key Relationships not supported in Bulk Query".

I saw lot of posts about this but dont find any solution yet.

I am facing this error for a quite while now. Please help if anyone found a solution for this.

Thanks in advance.

-Abhishek
Amit Chaudhary 8Amit Chaudhary 8
Bulk API does not support relationships currently, you are currently limited to a single Table

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

Check below post also
1) https://help.salesforce.com/HTViewSolution?id=000214827

Let us know if this will help you
Abhishek Pal 33Abhishek Pal 33
Hi Amit,

I know these links but do you know any alternative from which we can export 10k(approx) using relationship in soql.

Thanks in advance.

-Abhishek
Amit Chaudhary 8Amit Chaudhary 8
Bulk API does not support relationships currently, you are currently limited to a single Table.

You need to export both table record and then need to perform the vlookup in exl file