How to format a table extracted from salesforce into python?
I was able to extract some fields from salesforce using python.
I used the following code block :
!pip install simple_salesforce
from simple_salesforce import Salesforce
import pandas as pd
sf = Salesforce(
username='',
password='',
security_token='')
sf_data = sf.query_all("SELECT Brand_Name__c,Name FROM AuthorisedProduct__c")
sf_df = pd.DataFrame(sf_data)
sf_df.head()
This process puts all items in one 'record' field.
|records | total size |
|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------:|:-------------------------:|
|OrderedDict([('attributes', OrderedDict([('type', 'AuthorisedProduct__c'), ('url', '/services/data/v42.0/sobjects/AuthorisedProduct__c/a020o00000xC1fmAAC')])), ('Brand_Name__c', 'ABB'), ('Name', 'UNO-DM-1.2-TL-PLUS-B')]) | 14000 |
|OrderedDict([('attributes', OrderedDict([('type', 'AuthorisedProduct__c'), ('url', '/services/data/v42.0/sobjects/AuthorisedProduct__c/a020o00000xC1fnAAC')])), ('Brand_Name__c', 'ABB'), ('Name', 'UNO-DM-1.2-TL-PLUS-SB')]) | 14000 |
|OrderedDict([('attributes', OrderedDict([('type', 'AuthorisedProduct__c'), ('url', '/services/data/v42.0/sobjects/AuthorisedProduct__c/a020o00000xC1foAAC')])), ('Brand_Name__c', 'ABB'), ('Name', 'UNO-DM-2.0-TL-PLUS-B')])| 14000 |
Please note there are 14000 values under records.
I wanted to have only two fields in a simple dataframe. A Table with 'Brand_Name__c' and 'Name' fields.
|Brand_Name__C |Name |
|:--:|:------------------:|
|ABB|UNO-DM-2.0-TL-PLUS-B |
|ABB|UNO-DM-1.2-TL-PLUS-SB|
and we will have a matrix of 14000 by 2.
Please advise how to achieve that?
> And also, How to reverse that process?
Thank you all so much.
