You need to sign in to do that
Don't have an account?
Aleksandra Czepierga
python simple salesforce - insert data
Hi!
I wanted to use python imple salesforce to get data from google sheet and import it into salesforce. In more details, I want to create tasks with information included in this excel.
Simplifying sth like this:
#sf.Task.create({'WhatId': columnD, 'Subject': columnE })
I don't think i can bulk insert it so I'm thinking how to iterate it but I have issues with iterating through cells. Have you ever tried to insert sth from gsheet, how?
I have connected to gsheet and pulled data to dataframe.
But what then?
I wanted to use python imple salesforce to get data from google sheet and import it into salesforce. In more details, I want to create tasks with information included in this excel.
Simplifying sth like this:
#sf.Task.create({'WhatId': columnD, 'Subject': columnE })
I don't think i can bulk insert it so I'm thinking how to iterate it but I have issues with iterating through cells. Have you ever tried to insert sth from gsheet, how?
I have connected to gsheet and pulled data to dataframe.
But what then?
The below blogs have working examples and code snippets for your requirement.
https://towardsdatascience.com/using-python-to-get-salesforce-data-97bb5a7ef2cf
https://jereze.com/code/salesforce-rest-api-python/
I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.
Thanks.
https://highlights.pointgoals.com