As a Salesforce admin, this package IS one of the only two things that makes Salesforce worthwhile. Another is any Apex class with @RestResource annotation. I spoke my piece. Edit: I spoke too soon. This library seems to provide a means to log in the user through connected apps, but it's not as easy as the documentation indicated.
You don't need to use connected apps for Python with simple Salesforce. You just need email password security token. That's it. You can also use instance URL and session ID if you know how to get that.
What's the benefit of using this over say the Salesforce Inspector extension to write SOQL queries and then pasting the information into an Excel sheet and then using Dataloader to make the updates?
It will just be significantly slower, if you are good at manipulating data with python, you are able to pull data immediately back into the notebook after uploading, allowing you to adjust if any errors occur. The ability to avoid shuffling CSVs saves a lot of time and headache.
@@hulkbuster5903 yes you need python installed. here's how I do it on MacOS: medium.com/@wbmcdonald4/how-to-setup-python-on-macos-the-right-way-for-data-teams-be06bb6f0c1d
This video is really helpful. I have a requirement to identify the specific rows for which errors occurred during data insertion using Simple Salesforce. However, currently, Simple Salesforce only provides the error status without the associated rows for which the errors occurred. As a result, it is not possible to retrieve all the error rows and their descriptions directly from Simple Salesforce. Could you please assist me in obtaining the error rows and their error descriptions?
Yes, for this I believe you have to go into Setup >> Bulk Data Load Jobs, then click into one of the jobs you just ran. It should display a JSON file which contains records that inserted successfully, and the ones that failed. The ones that failed should include an error message.
Very informative, would highly recommend this if I were a consultant.
Glad you found it useful.
As a Salesforce admin, this package IS one of the only two things that makes Salesforce worthwhile. Another is any Apex class with @RestResource annotation. I spoke my piece.
Edit: I spoke too soon. This library seems to provide a means to log in the user through connected apps, but it's not as easy as the documentation indicated.
You don't need to use connected apps for Python with simple Salesforce. You just need email password security token. That's it.
You can also use instance URL and session ID if you know how to get that.
@wbrendanmcdonald Thanks for answering, but I already migrated away from Salesforce. My life has been easier ever since.
@@atsanonwadsanthat166 lmao
What's the benefit of using this over say the Salesforce Inspector extension to write SOQL queries and then pasting the information into an Excel sheet and then using Dataloader to make the updates?
It will just be significantly slower, if you are good at manipulating data with python, you are able to pull data immediately back into the notebook after uploading, allowing you to adjust if any errors occur. The ability to avoid shuffling CSVs saves a lot of time and headache.
@@wbrendanmcdonald Thank you I didnt realise this. So just takes a little time to learn?
yea exactly @@hulkbuster5903
@@wbrendanmcdonaldDumb question but do I need to have Python installed or can I install this and use it as is. Thanks
@@hulkbuster5903 yes you need python installed. here's how I do it on MacOS:
medium.com/@wbmcdonald4/how-to-setup-python-on-macos-the-right-way-for-data-teams-be06bb6f0c1d
This video is really helpful. I have a requirement to identify the specific rows for which errors occurred during data insertion using Simple Salesforce. However, currently, Simple Salesforce only provides the error status without the associated rows for which the errors occurred. As a result, it is not possible to retrieve all the error rows and their descriptions directly from Simple Salesforce. Could you please assist me in obtaining the error rows and their error descriptions?
Yes, for this I believe you have to go into Setup >> Bulk Data Load Jobs, then click into one of the jobs you just ran. It should display a JSON file which contains records that inserted successfully, and the ones that failed. The ones that failed should include an error message.
any alternative in php like simple-salesforce package
I honestly don't know, but probably.