search

heroku / salesforce-bulk

Python interface to the Salesforce.com Bulk API
MIT License
207 stars 154 forks source link

Cannot read all Salesforce fields using salesforce_bulk #96

Closed sullivanjoh closed 3 years ago

sullivanjoh commented 3 years ago

Hi All, Not sure sure if this is an issue with the library.

I’m using the python salesforce_bulk library to extract data from Salesforce.

If I attempt to read all fields of some tables an error is returned INVALID_FIELD. Using the CONTACT table as an example I first perform a describe on the object to return all fields, then use that field list to query Salesforce. This returns an error giving me a list of invalid fields.

The query will work once those fields are removed. I’m sure my account has access to those fields because I can extract them using the synchronous (non bulk) query-all API. This uses the requests library.

I know compound fields are not supported by the bulk API so those have all been removed.

List of invalid fields from the CONTACT table:

Column Salesforce Data-type EmailBouncedDate DateTime IsEmailBounced Bool PhotoUrl V_WString Jigsaw V_WString JigsawContactId V_WString IndividualId V_WString ActivityMetricId V_WString Preferred_Name__c V_WString Any advice would be greatly appreciated. Thank you

sullivanjoh commented 3 years ago

Since I posted I tried the bulk API using simple salesforce and it has the same issue. So it not a problem with the library. I think the issue will be on the Salesforce side. Cheers