Python Salesforce.get_all_columns Examples

Example #1

    my_data = s_f.get_salesforce_data('my_table', ["abc", "123", "more"], "WHERE abc=123")
    row_count = 0
    for row in my_data:
        row_count += 1
        print(row)

    print(f"Query returned: {row_count} rows.")

except SalesforceMalformedRequest as s:
    print('Malformed Query')
    # Remove next line to print exception
    # print(s)

tables = s_f.get_all_salesforce_tables()

columns = s_f.get_all_columns('Account')

try:
    # rows_returned = s_f.get_salesforce_data(tables[0], columns[0: 10])
    rows_returned =   s_f.get_salesforce_data('Account', ["Id", "IsDeleted"], "WHERE Id != ''")



    s_f.display_rows(rows_returned)
except SalesforceMalformedRequest as s:
    print('Malformed Query')

# Other tips:
# Convert your data to pandas data frame to easily parse and manipulate data.
# Documentation:
# https://pandas.pydata.org/pandas-docs/stable/user_guide/10min.html