File size: 678 Bytes
4e424bc 1d73476 b0ee55c 4e424bc 43c2b75 95854b9 4e424bc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
from simple_salesforce import Salesforce
import pandas as pd
def fetch_poles():
sf = Salesforce(
username="[email protected]",
password="Vedavathi@04",
security_token="jqe4His8AcuFJucZz5NBHfGU"
)
query = """
SELECT Name, Site__c, Solar_Generation__c, Wind_Generation__c,
Power_Required__c, Power_Sufficient__c, Camera_Status__c,
Location_Latitude__c, Location_Longitude__c, RFID_Tag__c,
Alert_Level__c, Tilt_Angle__c, Vibration_Level__c
FROM Pole__c
LIMIT 50
"""
results = sf.query_all(query)
df = pd.DataFrame(results['records']).drop(columns='attributes')
return df
|