Hello everyone, we are working on new versions of the Salesforce components and would like to get some community input. I'd like to start a discussion here and ask about your experience with the Salesforce extractor and writer; what functionalities are missing and what could be improved?
Where am I?
In Keboola you can ask and answer questions and share your experience with others!
Would be great to have chunking settings - with the current writer, I am unable to edit batch processing rules, so we get a lot of failures when trying to write back to salesforce.
May not be a suggested improvement so much as a description edit, but I've been nervous about setting my SFDC extractions as incremental because the extractor says it will download new records since the last run. What about updates to existing records? Are those captured too?
The current extractor uses the LastModifiedDate field of salesforce for incremental fetching, so both new and updated fields are fetched. We will make this more clear in the next version. Thank you for your input :)
But keep in mind that if you have a formula field on the record and you change the formula, this won't update the LastModifiedDate on the record itself, and the incremental extractor won't pick up the change. That is the main reason we are still using full load extraction.