Hi there - we are trying to use Airbyte open sourc...
# ask-community-for-troubleshooting
s
Hi there - we are trying to use Airbyte open source to pull data from Salesforce? We've run into issues with the very basics and I wonder if we're missing anything. To give you an example - we try to fetch the Account data and it does not allow us to use BULK API because there is a couple of unsupported fields. We can't exclude these fields since Airbyte seems to only allow all or nothing at this time and so the job falls back to REST API that ends up in a timeout after trying to load the entire table for the first time (400k+ records). Any suggestions on the workarounds?
m
there is a couple of unsupported fields
are missing fields or fields you dont’ have permissions?
s
Hey @Marcos Marx (Airbyte) - thanks for the quick reply! Our integration user has full read access and so it runs into a couple of Account fields that are not supported by BULK API. I believe these are compound address fields and the best practice is to exclude them from the BULK API calls - https://salesforce.stackexchange.com/questions/127552/how-to-retrieve-compound-fields-like-address-using-bulk-api
Hi @Marcos Marx (Airbyte) - checking in here just to make sure this is on your radar. I'd appreciate some guidance when you have a chance this week.
@Marcos Marx (Airbyte) - sorry to bug you but I'm really looking for an update on my question. It is currently blocking us from exploring Airbyte in more detail.